Hello all. I am getting the above mentioned Error and I am not sure why. I have read quite a few answers to others with this error but they weren't comparable to mine. The query is: PROC SQL; CREATE TABLE work.patient_cohort_w_Race AS SELECT DISTINCT pc.* ,CASE WHEN PatientRaceDSC = 'ASIAN' THEN 'Asian' WHEN PatientRaceDSC = 'BLACK OR AFRICAN AMERICAN' THEN 'Black or African American' WHEN PatientRaceDSC = 'Hispanic or Latino' THEN 'Hispanic or Latino' WHEN PatientRaceDSC LIKE ('WHITE%') THEN 'White or Caucasian' WHEN PatientRaceDSC = 'American Indian or Alaska Native' THEN 'American Indian or Alaska Native' WHEN PatientRaceDSC = 'Native Hawaiian or Other Pacific Islander' THEN 'Native Hawaiian or Other Pacific Islander' WHEN PatientRaceDSC IN ('Declined', 'Unavailable') THEN 'Unknown' WHEN PatientRaceDSC IS NULL THEN 'Unknown' ELSE 'Other' END AS RACE , CASE WHEN EthnicGroupDSC in ('Yes Hispanic','Hispanic') THEN 'YES' ELSE 'NO' END AS HISPANIC_LATINO FROM Fin.HospitalAccount HA LEFT JOIN work.patient_cohort pc on HA.PatientID = pc.PatientID LEFT JOIN pat.Race R on HA.PatientID = R.PatientID LEFT JOIN pat.Patient P on HA.PatientID = P.PatientID and this is the log with the error: 274 PROC SQL; ---- 78 ERROR 78-322: Expecting a ','. 275 CREATE TABLE work.patient_cohort_w_Race AS 276 SELECT DISTINCT pc.* 277 278 ,CASE WHEN PatientRaceDSC = 'ASIAN' THEN 'Asian' 279 WHEN PatientRaceDSC = 'BLACK OR AFRICAN AMERICAN' THEN 'Black or African American' 280 WHEN PatientRaceDSC = 'Hispanic or Latino' THEN 'Hispanic or Latino' 281 WHEN PatientRaceDSC LIKE ('WHITE%') THEN 'White or Caucasian' 282 WHEN PatientRaceDSC = 'American Indian or Alaska Native' THEN 'American Indian or 282! Alaska Native' 283 WHEN PatientRaceDSC = 'Native Hawaiian or Other Pacific Islander' THEN 'Native 283! Hawaiian or Other Pacific Islander' 284 WHEN PatientRaceDSC IN ('Declined', 'Unavailable') THEN 'Unknown' 285 WHEN PatientRaceDSC IS NULL THEN 'Unknown' 286 ELSE 'Other' END AS RACE 287 , CASE WHEN EthnicGroupDSC in ('Yes Hispanic','Hispanic') THEN 'YES' 288 ELSE 'NO' END AS HISPANIC_LATINO 289 290 FROM Fin.HospitalAccount HA 291 LEFT JOIN work.patient_cohort pc on HA.PatientID = pc.PatientID 292 LEFT JOIN pat.Race R on HA.PatientID = R.PatientID 293 LEFT JOIN pat.Patient P on HA.PatientID = P.PatientID ... View more

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!!!!!!! ... View more

Hello all   A few weeks ago I got some assistance in converting char into numeric and it worked. I am trying to use that same advice on another project but its not working. I am obviously not applying it correctly and not sure how or why. This is the code. PROC SQL; CREATE TABLE all_mrn AS SELECT * FROM epicfin.HospitalAccount a LEFT JOIN EPICPAT.Identity I on a.PatientID = I.PatientID RIGHT JOIN ed.all_mrn m on I.PatientIdentityID = m.mrn ;QUIT; With this code I get this error: 26 PROC SQL; 27 CREATE TABLE all_mrn AS 28 SELECT * 29 FROM epicfin.HospitalAccount a 30 LEFT JOIN EPICPAT.Identity I on a.PatientID = I.PatientID 31 RIGHT JOIN ed.all_mrn m on I.PatientIdentityID = m.mrn 32 ; ERROR: Expression using equals (=) has components that are of different data types. I checked and found out that I.PatientIdentityID is char while m.mrn is numeric so I changed the code to: PROC SQL; CREATE TABLE all_mrn AS SELECT * FROM epicfin.HospitalAccount a LEFT JOIN EPICPAT.Identity I on a.PatientID = I.PatientID RIGHT JOIN ed.all_mrn m on I.input(PatientIdentityID, best.) = m.mrn ;QUIT; These are the error messages I received: 34 PROC SQL; 35 CREATE TABLE all_mrn AS 36 SELECT * 37 FROM epicfin.HospitalAccount a 38 LEFT JOIN EPICPAT.Identity I on a.PatientID = I.PatientID 39 RIGHT JOIN ed.all_mrn m on I.input(PatientIdentityID, best.) = m.mrn _ _ 22 76 ERROR 22-322: Syntax error, expecting one of the following: ',', JOIN. ERROR 76-322: Syntax error, statement will be ignored. 2 The SAS System 11:46 Friday, June 11, 2021 39 ! RIGHT JOIN ed.all_mrn m on I.input(PatientIdentityID, best.) = m.mrn _ 22 ERROR 22-322: Expecting a name. What am I doing wrong?  ... View more