How to save proc freq result as a table?

[afiqcjohari]

This should be pretty much straightforward but I can't get it work even after reading through the documentation...

/*save the var1 freq table*/
proc freq data=have order=freq ;
output out=var1_freq;
tables var1/list missing;  
run;

/*save the two freq tables*/
proc freq data=have order=freq ;
output out=var1_freq var1var2_freq;
tables var1 var1*var2/list missing;  
run;

[Rohit12]

proc freq data=have order=freq ;
tables var1/list missing out=var1_freq;
run;

/*save the two freq tables*/
proc freq data=have order=freq ;
tables var1 var1*var2/list missing out=var2_freq;
run;

[lakshmi_74]

proc freq data=have;
tables var1/out=var1_data;
tables var1*var2/out=var2_data;
run;

[afiqcjohari]

But it seems that the output doesn't include the cumulative frequency and cumulative percent. Is it possible to get these variables as well?

[Reeza]

RTM for the options on the TABLES statement that control the output. 

[Reeza · Accepted solution]

Read the warnings in your log. Always. 

They state that a statistic is required. 

OUT on the TABLES statement is used to capture the frequencies. 

OUTPUT statement is used to capture test statistics. 

ODS OUTPUT is a different way to keep the counts. 

See the example below. 

Proc freq data=SASHELP.class;

tables sex / out = freqs chisq;

output out= stats chisq;

ODS onewayFreq= frreqs2;

run;

[afiqcjohari]

I see, thanks for the explanation Reeza.