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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.