topic Re: Proc freq in pdf format - printing out top frequences in SAS Programming

Proc freq in pdf format - printing out top frequences

myboys2 — Mon, 20 Jul 2015 15:35:39 GMT

I am printing a proc freq via pdf and I was wondering if there is a way to only print 200 observations in a proc freq?

Thank you

Re: Proc freq in pdf format - printing out top frequences

ballardw — Mon, 20 Jul 2015 15:52:51 GMT

Since your subject line says "top frequencies" what I would suggest would be to run proc freq with no print and create an output data set and then print that with the OBS= dataset option to print the top 200.

Something like:

proc freq data=have noprint order=freq;

tables variable /out= want;

run;

proc print data=want (obs=200) noobs ;

run;

Re: Proc freq in pdf format - printing out top frequences

Rick_SAS — Mon, 20 Jul 2015 15:53:02 GMT

I assume you want only the Top 200 groups, ordered by frequency. See the PROC FREQ discussion at https://communities.sas.com/thread/82076

Basically you can use ORDER=FREQ and suppress output by using the NOPRINT option, then use the OUT= option on the TABLES statemnt to write the frequencies to a data set. Then use PROC PRINT with OBS=200.

Re: Proc freq in pdf format - printing out top frequences

myboys2 — Wed, 22 Jul 2015 11:29:38 GMT

Thank you and what you provided worked however I have 10 variable is my freq that I want to print. When I do the out= it only prints the variable in front of the out - which happens to be the last variable.