How can I output the crosslist results from proc freq to a dataset?

[zachi_dv]

Is it possible to output the crosslist data from PROC FREQ to a dataset? The OUT option in the TABLE statement only outputs the frequencies and percentages.

My goal is to generate a dataset containing a list of Standard Residuals (stdres)

[Tom · Accepted solution]

Huh?  How did you get PROC FREQ to generate that statistic?

If it can generate the statistic then turn on ODS TRACE before running it an see which output table contains the information. Then just add an ODS OUTPUT statement to tell ODS to save that result into a dataset when you run the PROC FREQ.

[zachi_dv]

yes, that works. I'm not much familiar with ODS so I didn't think of it. 

thank you so much.

Proc FREQ can produce Standard Residuals by adding CROSSLIST and STDRES in the Table options.

i.e.  table type * prov / chisq cellchi2 expected CROSSLIST stdres out=std_red crosslist ;
weight count_number;

run;

[PaigeMiller]

ods output crosslist=crosslist_table;
proc freq data= ... ;
/* Other PROC FREQ statements */
run;

[zachi_dv]

thanks!!