Error 22-322

wheddingsjr — Thu, 04 Nov 2021 17:55:44 GMT

Hi all

I checked some of the other posts when it comes to this error, but nothing that helped. I am guessing I am tired or frustrated after working on this project for almost 24 hours straight and I am confused as to why this simple little code is giving me this error and why I cant figure out why its creating the error. Here is the code:

PROC SQL;
CREATE TABLE work.mc_c AS
Select mc *
	  ,npi.ProvOrgNm
From work.mc mc
Left Join dbo.NPIDATA npi On mc.Referral_NPI = npi.NPI
;QUIT;

and this is the error in the log:

26         PROC SQL;
27         CREATE TABLE work.mc_c AS
28         
29         Select mc *
30         	  ,npi.ProvOrgNm
              _
              22
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, 
              a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.  

31         From work.mc mc
32         Left Join dbo.NPIDATA npi On mc.Referral_NPI = npi.NPI
33         ;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
33       !  QUIT;

Can anyone else see something that I am missing?? I just want to go sleep!!!!!!!

Re: Error 22-322

Reeza — Thu, 04 Nov 2021 18:02:48 GMT

You forgot the period.

Select mc.*
,npi.ProvOrgNm

Re: Error 22-322

wheddingsjr — Thu, 04 Nov 2021 18:02:56 GMT

Please disregard. I found the issue, and it was simple like I knew it would be. Sleep deprivation is a powerful thing

Re: Error 22-322

wheddingsjr — Thu, 04 Nov 2021 18:03:50 GMT

Thanks reeza..i just noticed that as you replied...

topic Re: Error 22-322 in SAS Programming

Error 22-322

Re: Error 22-322

Re: Error 22-322

Re: Error 22-322