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
Change the drop statement to reflect the variables you want to drop, they are space separated, not comma delimited.
(drop=pct_row percent)
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;
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)
The variable name holding the total percent is PERCENT:
(drop=percent)
Change the drop statement to reflect the variables you want to drop, they are space separated, not comma delimited.
(drop=pct_row percent)
Thank you
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.