topic Running a Chi Square in SAS Programming

Running a Chi Square

bhufman — Thu, 10 Dec 2020 15:13:55 GMT

I am trying to get this output to run for a Chi Square, here is my Code:

ODS Trace on;
Proc Freq Data=hypanl.hypanalysis2;
Tables hypreldeathInd * StateCd / Nopercent norow nocum chisq;
Run;
ODS Trace Off;

ODS OUTPUT CrossTabFreqs=HRslt.Percents (KEEP = Cd DeathInd Frequency ColPercent
WHERE = (DeathInd = 1 AND MISSING (Cd)=0));

ODS OUTPUT Chisq=HRslt.ChiSqResults
(DROP=TABLE
WHERE= (Statistic= 'Chi Square'));

PROC PRINT DATA=H.Percents;
RUN;
PROC PRINT DATA=H.ChiSqResults;
RUN;

I am getting this Error in the log:

ERROR: File H.ChiSq.DATA does not exist.

91 RUN;

And these Warnings:

WARNING: Output 'Chisq' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify

that the appropriate procedure options are used to produce the requested output object. For example, verify that the

NOPRINT option is not used.

WARNING: Output 'CrossTabFreqs' was not created. Make sure that the output object name, label, or path is spelled correctly.

Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify

that the NOPRINT option is not used.

Any suggestions on whats happening, particularly with the Error...

Re: Running a Chi Square

PaigeMiller — Sun, 06 Dec 2020 21:13:32 GMT

Your ODS OUTPUT statements belong immediately before or inside PROC FREQ. It doesn't work where you put it, after PROC FREQ ended.

Re: Running a Chi Square

bhufman — Sun, 06 Dec 2020 21:18:24 GMT

Thanks for this tip! I'm still getting the warning about the output for ChiSq and the Error that the ChiSq File doesn't exist.

Re: Running a Chi Square

PaigeMiller — Sun, 06 Dec 2020 21:20:55 GMT

Show us the log for your PROC FREQ, including all WARNINGs, ERRORs, NOTEs and the actual code for PROC FREQ as it appears in the log. Do not chop anything out.

Please provide the log following these instructions (and not via any other method): copy the log as text from the SAS log window, and paste it into the window that appears when you click on the </> icon.

Re: Running a Chi Square

bhufman — Thu, 10 Dec 2020 15:15:25 GMT

Re: Running a Chi Square

PaigeMiller — Sun, 06 Dec 2020 21:41:58 GMT

Maxim 2: Read the log.

NOTE: No statistics are computed for HypRelDeathInd * StateCd because HypRelDeathInd has fewer than 2 nonmissing levels.

Your data is not appropriate for this test.