topic Re: output proc freq percent in SAS Programming

output proc freq percent

GS2 — Tue, 04 Aug 2020 14:46:08 GMT

Hello,

I have the following proc freq:

Complete

127

63.50

127

Other

36.50

Total

200

Is it possible to output the "Complete" frequency (127) and percent (63.50) and into a data set? Thank you

Re: output proc freq percent

Reeza — Tue, 04 Aug 2020 14:54:07 GMT

Look at the OUT option on the TABLE statement.

proc freq data=sashelp.class;
table age*sex / out=want outpct;
run;

It's also the first example in the documentation here:
https://documentation.sas.com/?docsetId=procstat&docsetTarget=procstat_freq_examples01.htm&docsetVersion=9.4&locale=en

And specific documentation on the OUT statement is here:
https://documentation.sas.com/?docsetId=procstat&docsetVersion=9.4&docsetTarget=procstat_freq_syntax08.htm&locale=en

Re: output proc freq percent

ballardw — Tue, 04 Aug 2020 14:55:55 GMT

It usually helps to show the code you are using so we can post code suggestions.

Proc freq will create output data sets several ways. One is to add an OUT=datasetname option to the tables statement. would require an OUTPCT option to get the percents. The OUT= option only will have result for a single table request. If you creating multiple tables then you either split the Tables statements or use ODS OUTPUT to capture results. You can use ODS OUTPUT CROSSTABFREQS=datasetname; as a statement in the Proc freq code to capture two-way tables.

This would have all the counts and percents, more less, and if you only want a specific value then you use the typical options to subset a data set.