Get SAS data set from proc freq

[GeorgeSAS]

Hello all,

I want get SAS data set instead of output.

proc freq data =sashelp.class ;
table sex / MISSING ;

          output out=need;/*not work*/
run;

I want to generate a SAS data set with data like this:     (two rows,5 variables):

Sex    Frequency    Percent      Cumu_Frequency    Percent
F                9              47.37                   9               47.37
M              10             52.63                   19             100.00

How to program?

Thanks!

[Reeza · Accepted solution]

Use OUT on the TABLE statement.

Note that I also used the NOPRINT option so you don't have output that goes to the Listing or HTML output. This is optional, but I find useful feature.

proc freq data=sashelp.class noprint;
table age*sex / out=want;
run;