Outputing Cell Chi-square values to a dataset

ZachiD — Fri, 24 Mar 2023 10:53:07 GMT

Hi,

I trying to find an association of specific combinations of values in a very large contingency table. I'm using proc freq with the option cellchi2. I don't want to scan the result table with my eyes in order to find all the cells with a relative high cellchi values which also have high frequencies. The out option does not output the cellchi data.

So I thought of creating a program that will submit a seperate proc freq for each value.
I've already created a program (see below) that uses macro for issolating a specific value and consoliate all the other and then conduct a chi-square test for it. The question is how to a create an automatic loop that will do this for a series of values?

%LET celltype = '4';

data cell;
set tinc;
cell_type='Other';
where class=&class and &sc_filter;
if &type=&celltype then cell_type=&celltype;
run;

proc freq data=cell;
table cell_type * site / chisq norow nopercent exact out=freqout;
weight count_number ;
run;

Re: Outputing Cell Chi-square values to a dataset

PaigeMiller — Fri, 24 Mar 2023 11:05:44 GMT

Add this into your PROC FREQ

ods output crosstabfreqs=crosstabfreqs;

By the way, you say you are using CELLCHI2 but your code is not using CELLCHI2.

Re: Outputing Cell Chi-square values to a dataset

ZachiD — Sat, 25 Mar 2023 19:53:53 GMT

I didn't share the main proc freq. I shared the code that produces a chi-square test to a specific value. i.e. conducting manually a cell-Chi-square test.

topic Re: Outputing Cell Chi-square values to a dataset in SAS Procedures

Outputing Cell Chi-square values to a dataset

Re: Outputing Cell Chi-square values to a dataset

Re: Outputing Cell Chi-square values to a dataset