topic Re: Top N Values in Proc Report in SAS Programming

Top N Values in Proc Report

BrahmanandaRao — Tue, 26 Jan 2021 07:36:54 GMT

data rank;
input id marks;
cards;
1 22
2 33
3 45
4	23
5	23
6	80
7	85
8	46
9	60
10 60
;
run;

proc rank data=rank out=rank_report descending
ties=	high;
var marks;
ranks rankstatus;
run; 

proc report data=rank ;
column id marks status;
define id /display;
define marks/analysis ;
compute after status
marks order by descending;
endcomp;
run;

How to find top N values using proc report

Re: Top N Values in Proc Report

Shmuel — Tue, 26 Jan 2021 07:45:31 GMT

The easiest way is to sort by descending value and select by

data = <dsname> (obs=n)

Re: Top N Values in Proc Report

PaigeMiller — Tue, 26 Jan 2021 11:57:06 GMT

proc report data=rank_report(where=(rankstatus<=5));

Re: Top N Values in Proc Report

PhilC — Tue, 26 Jan 2021 21:14:16 GMT

We would be using PROC REPORT to print the values out. We would use PROC RANK or PROC SORT to order the values. The method we use to select either the first highest N or, another way, to select those records with the lowest rank status will be our use of "SAS dataset option syntax".

data = <dsname> (obs=n) 
                 ------
proc report data=rank_report(where=(rankstatus<=5)); ----------------------