topic Re: ERROR 78-322: Expecting a ','. in New SAS User

ERROR 78-322: Expecting a ','.

Sandeep77 — Tue, 12 Apr 2022 12:10:18 GMT

Hello Experts,

The error says expecting a ','. But I am not sure what is that. Can you please check and clarify it?

30 proc sql;
31 select a.*,
32 b.accountstatuskey_current,
33 b.accountstatuskey_previous,
34 b.Datekey as Movement_Date date9.
_____
78
76
ERROR 78-322: Expecting a ','.

ERROR 76-322: Syntax error, statement will be ignored.

35 from work.add_repcode as a
36 inner join DWHDW.fact_tx_AccountStatus as b on a.Accountkey = b.Accountkey;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
37 quit;
NOTE: The SAS System stopped processing this step because of errors.

Re: ERROR 78-322: Expecting a ','.

PaigeMiller — Tue, 12 Apr 2022 12:14:58 GMT

b.Datekey as Movement_Date format=date9.

Re: ERROR 78-322: Expecting a ','.

Kurt_Bremser — Tue, 12 Apr 2022 12:53:36 GMT

Please use this button to post logs (or other text where no layout change is desired):

The "little running man" right next to is for posting SAS code (provides coloring similar to the SAS Enhanced Editor).

You need to tell the SQL procedure that DATE9 is a format, otherwise it thinks it's another name.

Re: ERROR 78-322: Expecting a ','.

tarheel13 — Mon, 18 Apr 2022 17:49:02 GMT

the columns you select in proc SQL have to be separated by commas. you don't specify a format in proc sql by just writing date9. you have to put format= before. you can find examples in the SAS documentation. https://documentation.sas.com/doc/en/pgmsascdc/v_024/sqlproc/n1ncn0pznd8wrln1tnp3xdxjz9xz.htm