topic Re: ERROR 73-322: Expecting an OUT. in SAS Procedures

ERROR 73-322: Expecting an OUT.

GKati — Wed, 08 Feb 2017 13:21:12 GMT

DEAR SAS USERS,

PROC SORT DATA=randrandomsampleCLAIMS2;

BY YEAR;

RUN;

Proc freq data=randrandomsampleCLAIMS2;

BY YEAR;

tables claims*QUARTER /nocol nopercent norow;

output OUT=claimtypes N=freq;

Run;

I get "ERROR 73-322: Expecting an OUT." for the code above. There is an OUT in there. What's my error?

Thanks,

Re: ERROR 73-322: Expecting an OUT.

Astounding — Wed, 08 Feb 2017 13:58:48 GMT

The syntax for creating an output data set in PROC FREQ is a little different:

Proc freq data=randrandomsampleCLAIMS2;

BY YEAR;

tables claims*QUARTER / noprint out=claimtypes;

Run;

It's easy enough to rename the variables if you want to.

Re: ERROR 73-322: Expecting an OUT.

Reeza — Wed, 08 Feb 2017 14:08:29 GMT

The syntax is different than proc means, but you're pretty close. The rest of the syntax are options but you don't get to rename the variable. What happens with the following code:

Proc freq data=randrandomsampleCLAIMS2;
BY YEAR;
tables claims*QUARTER /nocol nopercent norow;
output OUT=claimtypes N;
Run;

Re: ERROR 73-322: Expecting an OUT.

GKati — Wed, 08 Feb 2017 14:24:33 GMT

Thanks for the encouragement :-)) For some reason, this code didn't produce any output dataset. why is that? I also tried Astounding's and that produced a dataset. the difference between the two codes in minimal.

Re: ERROR 73-322: Expecting an OUT.

Reeza — Wed, 08 Feb 2017 14:26:46 GMT

Without a log I can't say. According to SAS docs the code is correct.

Re: ERROR 73-322: Expecting an OUT.

Astounding — Wed, 08 Feb 2017 14:36:28 GMT

I suspect that the error message comes from this combination:

The options on the OUTPUT statement (nocol, etc.) suppress all the printed output.
Because of that, the OUT= option is required.

It's true that the OUTPUT statement is added, but evidently PROC FREQ isn't smart enough to figure out that the combination is OK (no printed output, but using an OUTPUT statement). If you wanted to add an OUTPUT statement to save additional statistics, that ought to work.