Proc freq; select top 50 Highest observations

Hank — Wed, 05 Feb 2014 12:09:02 GMT

Hi,

The code below creates a table of the number of observation with the value "infinity" in the variable "tim_diff", for each variable observation "etikett".

I have made it so that the table is sorted in order of frequencies (order=freq).

My problem is that I want to choose just the 50 highest observations. I.e. the 50 observations in "etikett" with the highest number of frequencies in "tim_diff".

I have tried "(obs=50), but then it just chooses the first 50 observations, not the ones with the highest frequencies. Does anyone have a suggested solution to the problem?

proc freq data=Timlon order=freq nlevels;

table etikett*tim_diff / nopercent norow nocol list missing;

where tim_diff=.I;

run;

Thanks in advance!

Best regards,

Hank

Re: Proc freq; select top 50 Highest observations

data_null__ — Wed, 05 Feb 2014 14:09:36 GMT

This usually requires 2 steps one to summarize and another to select the top freqs.

proc summary data=sashelp.class nway; 
   class age / descending order=freq;
   output out=count;
   run; 
proc print data=count(obs=3);
   run;

topic Re: Proc freq; select top 50 Highest observations in SAS Procedures

Proc freq; select top 50 Highest observations

Re: Proc freq; select top 50 Highest observations