topic Re: Top 5 values in SAS Procedures

Top 5 values

Siddhartha — Fri, 22 Oct 2010 23:26:36 GMT

I am having a dataset with variables empcode,empname,sal,designation
I want to find out the top 5 salaries based on the designation.
Designation is a group variable.
Can anyone help me on this using datastep and proc sql;

Regards,
Siddhartha

Re: Top 5 values

Patrick — Sat, 23 Oct 2010 00:34:04 GMT

Searching the forums you'll find several threads dealing with this question.

Re: Top 5 values

R_Win — Mon, 25 Oct 2010 10:19:12 GMT

proc sql number outobs=5;
create table kk as
select * from sashelp.class desc group by designation order by sal descending;
quit;

Re: Top 5 values

Ksharp — Tue, 26 Oct 2010 04:41:07 GMT

Hi.
Op means a group variable.(i.e. need every group's first five observations).
I have two way, one is proc ,the other is data step;

[pre]
proc sort data=sashelp.class out=class;
by sex;
run;
ods select extremeobs;
proc univariate data=class nextrobs=5;
by sex;
var weight;
run;

proc sort data=sashelp.class out=class;
by sex descending weight;
run;
data temp;
set class;
by sex;
if first.sex then id=0;
id+1;
run;
data result;
set temp;
where id in (1 2 3 4 5);
run;
proc print;
run;

[/pre]

Ksharp

Re: Top 5 values

ArtC — Tue, 26 Oct 2010 05:57:37 GMT

Just so that you will have one more choice take a look at the IDGROUP option on the OUTPUT statement in PROC MEANS/SUMMARY.

Re: Top 5 values

Ksharp — Thu, 28 Oct 2010 05:09:09 GMT

Thanks, Art Carpenter.
I will take a look.
:)