ODS OUTPUT

[kristiepauly1]

My code: 

ODS OUTPUT ChiSq = data set (DROP = TABLE WHERE = (STATISTIC = 'Chi-Square'));

PROC PRINT DATA =data set;
RUN;

 I get the following warning:

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.

[ballardw]

The ODS OUTPUT statement needs to come immediately before in the body of Proc Freq.

Since you show not Proc Freq code there is nothing to create chi-square output of any flavor.

[kristiepauly1]

That worked for me. I had 2 ODS OUTPUT statements and was thinking the
proc freq I ran with the first one was sufficient when I ran this one.
Thanks!

[Allie_Haun · Accepted solution]

Hi Kristie, 

Try adding 

PROC FREQ DATA= LibName.Name;

TABLES  Hypertension * State / NOPERCENT NOROW MISSING NOCUM CHISQ;

RUN; 

It took me a while to get this on my code and this is what worked

[kristiepauly1]

Thanks Allie. That was all it was. I wrote a PROC FREQ for the
StatePercents and thought that was sufficient. During office hours I tried
adding the PROC FREQ after the ODS OUTPUT but it did not work. Now of
course, it worked. Sas hates me. Good Luck!

[ballardw]

---

@kristiepauly1 wrote:
Thanks Allie. That was all it was. I wrote a PROC FREQ for the
StatePercents and thought that was sufficient. During office hours I tried
adding the PROC FREQ after the ODS OUTPUT but it did not work. Now of
course, it worked. Sas hates me. Good Luck!

---

Likely not any where near as much as Excel hates me (an vice versa)😉