topic Re: Summarizing data as per month in SAS Procedures

Summarizing data as per month

venkatesh — Fri, 27 Feb 2009 09:53:13 GMT

Hi all.,

I Have a data set with variable like

empid, salary, salary2, date mmddyy10.;
101 15000 16000 10/11/2006
101 20000 25000 10/12/2006
101 5000 2500 10/12/2006
101 15600 18000 11/09/2006
101 16000 12500 11/12/2006

....
....
...

here i required the output as

101 40000 43500 10/11/2006
101 31600 30500 11/09/2006
.....
....

according to the month wise need to add salary1 and salary2 variables and displayed at startingdate of the each observation.(here month 10 two times and month 11 two times....i have nearly 3000 records....in a single year...)

i can use all the three Base Sas, Di Studio and Enterprise Guide.....

Help would be a great....

Venkatesh.

Re: Summarizing data as per month

deleted_user — Fri, 27 Feb 2009 10:53:38 GMT

Try this...

This code reads in the data, but notice i create a month variable to be the month of the date.

data emps;
format date mmddyy10.;
input empid salary salary2 date mmddyy10.;
month=month(date);
cards;
101 15000 16000 10/11/2006
101 20000 25000 10/12/2006
101 5000 2500 10/12/2006
101 15600 18000 11/09/2006
101 16000 12500 11/12/2006
run;

Then use a proc means to find the summarised values. Note the NWAY option to get only the highest level of combinations and the IDMIN which will take the minimum value of the ID vairable (as opposed to the maximum which is the default). Us the month vairable as the class variable as well as the employee id and drop the month variable along with the automatic variables.

proc means data=emps noprint nway idmin;
class empid month;
id date;
var salary salary2;
output out=tots(drop=_type_ _freq_ month) sum= ;
run;

Re: Summarizing data as per month

venkatesh — Fri, 27 Feb 2009 12:38:53 GMT

Thank You Pznew....

same thing i did by using retain statement in DI studio.,

its Good alternative for Me....both are working fine......

once again Thanks......