Solved: how to output "total" in dataset from proc freq

HitmonTran · Posted 07-25-2022 11:18 PM

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;

Ksharp · Posted 07-26-2022 08:27 AM

ods output CrossTabFreqs=want;
proc freq data=sashelp.class order=data;
tables sex*age ;
run;

mkeintz · Posted 07-26-2022 12:14 AM

Do you want just the column totals? That's all that you marked.

What about the row totals and the grand total?

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Ksharp · Posted 07-26-2022 08:27 AM

ods output CrossTabFreqs=want;
proc freq data=sashelp.class order=data;
tables sex*age ;
run;

how to output "total" in dataset from proc freq