data have; input firm year asset; datalines; 1 1997 535 1 1998 453 1 1999 7856 2 1997 87 2 1998 87687 2 1999 452 2 2000 78 2 1997 78 3 1998 986 ; proc sort data=have; by year ; run; data mak; set have; by year; if first.year then Top=0; Top+1; if Top < 3 ; run; ... View more

Thank You even ur answer are right.  ... View more

Thank You @Reeza @RW9 i rally appreciate you ppl took a time and answered. frequently i started using SAS Communities and i don’t know how to attach data. but well answered by you people. ... View more

Am really thank full @jklaverstijnJklaverstin you have solved my question, actually i tried in many ways but you have given me perfect solution. now i can continue my practice      And thanks for others too who replayed ... View more

Sir the quest is how to split the date set in to multipal data set by month wise?  Ex:- I have a data set XYZ it have a observation called 'Date'  and Date varibale have a daly sales or etc observation in MMDDYY formate and i want to split the data according to the month wise like JAN FEB MAR till DEC. i got the point of using data set names like   Data Jan Feb etc; ;??????? run;  for forther detailes i have atteched file.   Thank You ... View more