topic Re: Output row and col pct from a table to a sas dataset in ODS and Base Reporting

Output row and col pct from a table to a sas dataset

cherryjingo — Mon, 19 Mar 2018 14:45:35 GMT

Hello!

I am wondering if I can let SAS automatically create a dataset from the pcts of the table in the picture attached.

so the layout of the created dataset can be:

S12 G8 RowPct ColPct

0 0 40.00 3.77

0 1 60.00 1.18

1 0 16.89 96.23

1 1 83.11 98.82

Thank you!

Reeza — Mon, 19 Mar 2018 14:52:03 GMT

 Proc freq data=sashelp.class;
Table sex*age / out=want outpct;
Run;

cherryjingo — Mon, 19 Mar 2018 16:07:18 GMT

Thanks!