topic Re: ODS OUTPUT in SAS Programming

ODS OUTPUT

kristiepauly1 — Thu, 10 Dec 2020 21:17:33 GMT

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.

Re: ODS OUTPUT

ballardw — Thu, 03 Dec 2020 01:56:30 GMT

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.

Re: ODS OUTPUT

Allie_Haun — Thu, 10 Dec 2020 15:13:22 GMT

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

Re: ODS OUTPUT

kristiepauly1 — Thu, 03 Dec 2020 15:25:07 GMT

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!

Re: ODS OUTPUT

kristiepauly1 — Thu, 03 Dec 2020 15:29:07 GMT

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!

Re: ODS OUTPUT

ballardw — Thu, 03 Dec 2020 16:04:14 GMT

@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)😉