topic Top N values in sas in SAS Programming

Top N values in sas

BrahmanandaRao — Wed, 03 Feb 2021 11:09:47 GMT

proc sql outobs=5;
select  age from sashelp.class;
group by age;
order by age desc;
quit;

Top N Values how to get

Re: Top N values in sas

PeterClemmensen — Wed, 03 Feb 2021 11:11:15 GMT

Sort by descending and take the first N values of that.

Re: Top N values in sas

BrahmanandaRao — Wed, 03 Feb 2021 11:16:58 GMT

i am not getting ouput

Re: Top N values in sas

gamotte — Wed, 03 Feb 2021 11:28:41 GMT

Hello,

Your SQL code is only one instruction so you only need a semi-colon at the end.

You also need to add the DISTINCT keyword.

proc sql outobs=5;
select distinct age from sashelp.class
order by age desc;
quit;

EDIT: removed group by.

Re: Top N values in sas

PeterClemmensen — Wed, 03 Feb 2021 11:19:13 GMT

proc sort data = sashelp.class out = temp;
   by descending age;
run;

data want;
   set temp (keep = age obs = 5);
run;

Re: Top N values in sas

andreas_lds — Wed, 03 Feb 2021 11:24:14 GMT

@BrahmanandaRao wrote:
i am not getting ouput

Please post the code you use and the complete log. Both as text!

Re: Top N values in sas

Rick_SAS — Wed, 03 Feb 2021 13:59:39 GMT

In addition the solutions given, you might also want to learn how to create a table and bar chart of the Top N values by using PROC FREQ: How to create a "Top 10" table and bar chart.