topic Re: How to save proc freq result as a table? in SAS Programming

How to save proc freq result as a table?

afiqcjohari — Thu, 06 Apr 2017 04:13:34 GMT

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;

Re: How to save proc freq result as a table?

Rohit12 — Thu, 06 Apr 2017 04:27:25 GMT

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;

Re: How to save proc freq result as a table?

lakshmi_74 — Thu, 06 Apr 2017 04:28:21 GMT

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

Re: How to save proc freq result as a table?

Reeza — Thu, 06 Apr 2017 04:46:37 GMT

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;

Re: How to save proc freq result as a table?

afiqcjohari — Thu, 06 Apr 2017 05:26:32 GMT

I see, thanks for the explanation Reeza.

Re: How to save proc freq result as a table?

afiqcjohari — Thu, 06 Apr 2017 05:35:22 GMT

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

Re: How to save proc freq result as a table?

Reeza — Thu, 06 Apr 2017 12:45:24 GMT

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