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)
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.
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.
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;
ods output crosslist=crosslist_table;
proc freq data= ... ;
/* Other PROC FREQ statements */
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.