Running a Chi Square

[bhufman]

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...

[PaigeMiller]

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

[bhufman]

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.

[PaigeMiller]

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.

[PaigeMiller]

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.