Proc freq in pdf format - printing out top frequences

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

Proc freq in pdf format - printing out top frequences


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


Accepted Solutions
Solution
‎07-20-2015 11:52 AM
Super User
Posts: 11,343

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

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;

View solution in original post


All Replies
Solution
‎07-20-2015 11:52 AM
Super User
Posts: 11,343

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

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;

SAS Super FREQ
Posts: 3,753

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

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.

Contributor
Posts: 20

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

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 276 views
  • 3 likes
  • 3 in conversation