Is there a way to output the "Total" row in proc freq into a dataset?
output (does not have "Total")_
sas code:
proc freq data=&out order=data;
tables codec*result /out=freqall_&out ;
run;
ods output CrossTabFreqs=want; proc freq data=sashelp.class order=data; tables sex*age ; run;
Do you want just the column totals? That's all that you marked.
What about the row totals and the grand total?
ods output CrossTabFreqs=want; proc freq data=sashelp.class order=data; tables sex*age ; run;
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.