topic Re: Error 108-322 in SAS Studio

Error 108-322

eashcra1 — Fri, 11 Oct 2019 16:41:13 GMT

Hello,

I am new to using SAS and am having trouble creating a two-way frequency table. I've done some web searches and I believe I am using the correct code, but apparently not. Would appreciate some help!

proc freq data=work.import1;
order=frequency;
table jurisdiction*reportablecondition;
run;

Thank you!

Re: Error 108-322

PaigeMiller — Fri, 11 Oct 2019 16:45:20 GMT

You do not want a semi-colon after

proc freq data=work.import1

Re: Error 108-322

Kurt_Bremser — Fri, 11 Oct 2019 16:46:36 GMT

Please post logs in the future by simply copy/pasting them into a window opened with the {i} button.

ORDER is not a valid statement in proc freq; I guess you wanted to use either BY or WEIGHT.

See the documentation of PROC FREQ.

Re: Error 108-322

Tom — Fri, 11 Oct 2019 16:50:39 GMT

You have an extra semi-colon in the middle of your PROC FREQ statement.

To help avoid this type of mistake when typing a statement that is too long to fit legibly on one line (more than about 75 characters) I always place the semi-colon that ends the statement on a new line. The same as I would place the END statement that ends a multiple statement block of code.

proc freq data=work.import1
  order=frequency
;
  table jurisdiction*reportablecondition;
run;

Re: Error 108-322

PaigeMiller — Fri, 11 Oct 2019 16:52:05 GMT

@Kurt_Bremser wrote:

ORDER is not a valid statement in proc freq;

Actually, it is a valid option

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=statug&docsetTarget=statug_freq_syntax01.htm&locale=en

Re: Error 108-322

Reeza — Fri, 11 Oct 2019 16:55:25 GMT

ORDER= is an option on the PROC FREQ statement, not a statement on its own. So it needs to be before the semi colon.

Also, the valid values for ORDER are DATA, FORMATTED, FREQ or INTERNAL. I suspect SAS may correct frequency to FREQ but you may get a warning about that.

proc freq data=work.import1 order = freq;

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.3&docsetId=procstat&docsetTarget=procstat_freq_syntax01.htm&locale=en