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.....
This code reads in the data, but notice i create a month variable to be the month of the date.
format date mmddyy10.;
input 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
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;
var salary salary2;
output out=tots(drop=_type_ _freq_ month) sum= ;