topic Re: proc freq in SAS Programming

proc freq

myboys2 — Wed, 06 Jan 2016 21:39:15 GMT

i only want to view/print 100 observations in a proc freq. I am just looking for 100 obs even if I am reading in 1 millon records

I am currently doing the following

proc freq data=a order=freq

tables ssn customer_id test_name/nocum nopercent;

Thank you

Re: proc freq

Astounding — Wed, 06 Jan 2016 21:56:11 GMT

PROC FREQ does not support this. You can work around it, by creating output data sets. However, your program becomes longer because (a) you need an output data set for each table, and (b) you then have to print as a separate step. For example:

proc freq data=a order=freq;

tables ssn / noprint out=ssn_counts (keep=ssn count);

tables customer_id / noprint out=custid_counts (keep=customer_id count);

run;

proc print data=ssn_counts (obs=100);

run;

proc print data=custid_counts (obs=100);

run;

Re: proc freq

Steelers_In_DC — Wed, 06 Jan 2016 21:58:18 GMT

Add an options command before your proc freq.

options obs=100;

Re: proc freq

Reeza — Wed, 06 Jan 2016 22:32:43 GMT

1. Are you looking for the top 100 records

2. Are you looking for sample output to test a program by limiting analysis?

If 1, then there's not an easy way.

If 2, then use either option obs=100; to limit all processing to 100 observations or the data set option obs=100 to limit the data input to proc freq directly, sample code below.

proc freq data=a (obs=100) order=freq

tables ssn customer_id test_name/nocum nopercent;

Re: proc freq

PGStats — Thu, 07 Jan 2016 03:29:14 GMT

I think this might be a legitmate use of undocumented function monotonic()

proc freq data=sashelp.heart noprint;
table ageAtStart / out=ageFreq(where=(monotonic() <= 10));
run;

proc print data=ageFreq; run;

It works with order=freq as well.

Re: proc freq

myboys2 — Wed, 13 Jan 2016 20:07:01 GMT

this is perfect - thank you:)

Re: proc freq

myboys2 — Wed, 13 Jan 2016 20:18:31 GMT

Thank you i am also trying to remove the percent column by using the nopercent option however the few areas I have used it is not working. Any ideas?