SAS proc transpose for 2 Columns

We have a data set with columns Name, Month, Day and Sale. And we require a variable like Sale in January Monday for against each name.

Difference between two consecutive rows in SAS

Dataset is shown on right side. Here Visit, Time and Page are given and we need to calculate the duration by subtracting two consecutive rows.

E.g
Duration of Page "A" in Visit 1 is 23:39:23 - 23:34:10.
For Calculating Time difference we first need to convert this into time variable.

data libname.dataset;
set libname.dataset;
time1 = hms (scan(time,1,':'), scan(time,2,':'), scan(time,3,':');
run;

Now this time can be use for calculation. Now, Try the  macro below for calculation of duration. For Difference calculation I am using proc sql .

Note: Duration of last page of every visit is marked as Zero (as it can't be calculated).


Copy the macro below in file and for using type
%include "<filename complete path>";

%time_calc( libname,input_dataset,output_dataset,visit,time1,Duration);

Macro

Regression using Scatter Plot

Using Scatter plot obtain Regression equation and R-Square (R-Sq) in Excel.

Google Motion plot

Select Color as Unique Color, X-axis as Sales, Y-axis as Growth and Size as Contribution. In case one want to group the bubble (means same color code) then another variable is required in data-set for grouping.

Motion Plot

Enable Auto Filter in protected sheet in Excel

In Excel 2010

• Goto to Review Tab.
• Select Protect sheet, a dialog box (protect sheet) will appear.
• Check Use Auto Filter.

Plot Normal Curve Excel?

How to plot a normal distribution/bell curve in excel?

awdddw try

I am trying to make my blog visible in google search. So, I put a query word namely awdddw in the google analytics.

Who can use google analytics?

Friend

Abhinav Bharat

Analytics Attempt

This the first attempt to understand google analytics