topic Re: Adding a condition in PROC FREQ? in SAS Programming

Adding a condition in PROC FREQ?

braam — Fri, 10 Jan 2020 22:48:44 GMT

Can I limit my PROC FREQ result to groups where there are more than 30 observations in the below code? In other words, I would like to just report the number of observations in SUV, Sedan, and Sports groups, respectively, using PROC FREQ. In general, I would like to know how I can add a condition to limit my result.


proc freq data= sashelp.cars;
	table type/ nopercent nocol; run;

Type Frequency Cumulative
Frequency

Hybrid 3 3

SUV 60 63

Sedan 262 325

Sports 49 374

Truck 24 398

Wagon 30 428

Type	Frequency	Cumulative Frequency
Hybrid	3	3
SUV	60	63
Sedan	262	325
Sports	49	374
Truck	24	398
Wagon	30	428

Re: Adding a condition in PROC FREQ?

novinosrin — Fri, 10 Jan 2020 23:11:13 GMT

Not Sure directly on a PRINT output, but a workaround could be the following

ods output  OneWayFreqs=want(where=(Frequency>30));
proc freq data= sashelp.cars ;
	table type/ nopercent nocol; run;

proc print noobs;run;

Re: Adding a condition in PROC FREQ?

Astounding — Fri, 10 Jan 2020 22:57:44 GMT

And what should appear in the Cumulative Frequency column?

Re: Adding a condition in PROC FREQ?

braam — Sat, 11 Jan 2020 11:15:34 GMT

Oh, that column isn't needed.

Re: Adding a condition in PROC FREQ?

Astounding — Sat, 11 Jan 2020 23:12:40 GMT

If you don't need to worry about cumulative frequency, PROC FREQ can output the right numbers directly into a data set:

proc freq data= sashelp.cars;
   table type / noprint out=want (where=(count > 30));
run;
proc print data=want label;
   label count = 'Frequency';
   var type count;
run;