Build reports by using ODS to create HTML, PDF, RTF, Excel, text reports and more!

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

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

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

output.jpg

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!


Accepted Solutions
Solution
‎03-19-2018 12:06 PM
Super User
Posts: 24,027

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

[ Edited ]
Posted in reply to cherryjingo
 Proc freq data=sashelp.class;
Table sex*age / out=want outpct;
Run;

View solution in original post


All Replies
Solution
‎03-19-2018 12:06 PM
Super User
Posts: 24,027

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

[ Edited ]
Posted in reply to cherryjingo
 Proc freq data=sashelp.class;
Table sex*age / out=want outpct;
Run;
New Contributor
Posts: 2

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

Thanks!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 131 views
  • 0 likes
  • 2 in conversation