topic Re: Storing Proc Freq Data in a table in SAS Programming

Storing Proc Freq Data in a table

BStats — Thu, 10 Dec 2015 23:20:06 GMT

Hi,

I am writing several proc freq procedures and am wanting to store them output table in a file. I am specifying that I only want the frequency and the column percentage. However, when I open the table that is created (newdata) the percentage stored is the total frequency percentage not the column percentage. What am I doing wrong? The results tab shows what I am wanting in the frequency table.

Here is my code.......

proc freq data=mydata;

tables varA*varB/ out=newdata nopercent nocum norow;

run;

But the table "newdata" is showing

varA varB Frequency Count Percent of Total Frequency

Not

varA varB Frequency Count Column Percentage

Re: Storing Proc Freq Data in a table

Reeza — Thu, 10 Dec 2015 23:33:19 GMT

You need to add OUTPCT to add the pct columns to the output data set, check the docs for details.

This is a bit of a roundabout way to get what you want, but easy enough. Someone else may have a better answer 🙂

proc freq data=sashelp.class;
table age*sex/out=want(drop=pct_row) outpct norow nocum;
run;

proc print data=want;
run;

Re: Storing Proc Freq Data in a table

BStats — Thu, 10 Dec 2015 23:40:34 GMT

This drops the row percentage. Thank you. How do I also get it to drop the percentage of frequency total? I tried adding pct_tabl but it did not work

(drop=pct_row, pct_tabl)

Re: Storing Proc Freq Data in a table

Astounding — Fri, 11 Dec 2015 01:05:14 GMT

The variable name holding the total percent is PERCENT:

(drop=percent)

Re: Storing Proc Freq Data in a table

Reeza — Fri, 11 Dec 2015 01:55:26 GMT

Change the drop statement to reflect the variables you want to drop, they are space separated, not comma delimited.

(drop=pct_row percent)

Re: Storing Proc Freq Data in a table

ballardw — Fri, 11 Dec 2015 15:41:03 GMT

If you want to use Proc Freq to generate multiple output sets from a single input dataset use multiple TABLE statements. Each table statement will only build one output data set.

Re: Storing Proc Freq Data in a table

BStats — Tue, 15 Dec 2015 16:34:43 GMT

Thank you