topic Re:Data set, Please reply me ASAP in SAS Programming

Re:Data set, Please reply me ASAP

deleted_user — Tue, 14 Oct 2008 05:11:56 GMT

This is my input data set with 2 variables id and sal and my output should only contain top 5 observations for each id value.
Input Data set:
data sam;
input id sal;
cards;
1 4000
1 4000
1 4000
2 5000
2 6000
2 3000
2 3000
2 3000
2 3000
2 3000
2 3000
3 5000
3 5000
3 5000
3 5000
3 5000
3 5000
3 5000
4 6000
4 6000
run;

Output Dataset:

1 4000
1 4000
1 4000
2 5000
2 6000
2 3000
2 3000
2 3000
3 5000
3 5000
3 5000
3 5000
3 5000
4 6000
4 6000

Re:Data set, Please reply me ASAP

LinusH — Tue, 14 Oct 2008 06:53:21 GMT

First, sort you data by id and descending sal.
Then go through your data with a data step, counting no of observations in each by-group and output the first five each. You can accomplish this using first.id and a retain variable.

/Linus

Re:Data set, Please reply me ASAP

deleted_user — Tue, 14 Oct 2008 08:03:05 GMT

Hi Linus,

Thank you very much for ur reply.

sam