topic how to output "total" in dataset from proc freq in SAS Programming

how to output "total" in dataset from proc freq

HitmonTran — Tue, 26 Jul 2022 03:18:06 GMT

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;

mkeintz — Tue, 26 Jul 2022 04:14:28 GMT

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

What about the row totals and the grand total?

Ksharp — Tue, 26 Jul 2022 12:27:55 GMT

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