topic Re: How can I output the crosslist results from proc freq to a dataset? in SAS Programming

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

zachi_dv — Mon, 05 Feb 2024 17:18:36 GMT

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)

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

Tom — Mon, 05 Feb 2024 18:06:46 GMT

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.

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

PaigeMiller — Mon, 05 Feb 2024 18:48:20 GMT

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

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

zachi_dv — Tue, 06 Feb 2024 04:51:25 GMT

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;

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

zachi_dv — Tue, 06 Feb 2024 04:51:46 GMT

thanks!!