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!!!!!!!
Thanks reeza..i just noticed that as you replied...
Please disregard. I found the issue, and it was simple like I knew it would be. Sleep deprivation is a powerful thing
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.