11811 proc sql; 11812 create table nmedss_complete_inv as 11813 select c.INV_PROCESS_STATUS as status, c.UPDATED_OUTCOME as outcome, 11813! c.MONITORING_PROCESS as process, 11814 c._INV_START_DT as investStartDate format mmddyy10., c._patient_id as 11814! nmedss_id, c.INV_LOCAL_ID, c.PATIENT_LAST_NAME as lastname, c.PATIENT_FIRST_NAME as 11814! firstname, 11815 c._patient_dob as dob, c.PATIENT_CURRENT_SEX as sex, c.PATIENT_STREET_ADDR_1 as 11815! address1, c.patient_city as city, c._combined_county as county, 11816 s.state_name as state, c.JURISDICTION_NM as jurisdiction, c.PATIENT_TEL_HOME as 11816! home_phone, c.PATIENT_TEL_CELL as cell_phone, 11817 c._nm_race_ethnicity as ethnicity, c.Tribal_affiliation, c.PHC_INV_LAST_NAME as 11817! investigator, c.ORDERING_FACILITY as orderfac, c.ltc_facility, c.ltc_status 11818 from covid19_complete c, states_fips s 11819 11820 where Symptomatic not in ("","Unknown") and _illness_onset_dt ne '' or upcase 11820! (INV_PROCESS_STATUS) contains 'COMPLETE' 11821 and c.patient_state = s.fips_code 11822 and JURISDICTION_NM not in ("NWTribal","Tribal","Federal Facility", "ICE Facility", 11822! "New Mexico Corrections Department") 11823 and _detention_facility='' 11824 and upcase(ltc_status) not in ('RESIDENT', 'UNKNOWN') 11825 and (upcase(PHC_INV_LAST_NAME) like '%CENTRAL%' or upcase(PHC_INV_LAST_NAME) like 11825! '%BAUMBACH%' or upcase(PHC_INV_LAST_NAME) like '%EKPE%' 11826 or upcase(PHC_INV_LAST_NAME) like '%FITZPATRICK%' or upcase(PHC_INV_LAST_NAME) 11826! like '%GARCIA-LOPEZ%' 11827 or upcase(PHC_INV_LAST_NAME) like '%ADMINISTRATIVE OFFICE%' or 11827! upcase(PHC_INV_LAST_NAME) like '%LAS CRUCES HEALTH%' 11828 or upcase(PHC_INV_LAST_NAME) like '%GALLUP%') 11829 and (upcase(orderfac) not like '%NAVAJO-%' and upcase(orderfac) not like 11829! '%CROWNPOINT%' and upcase(orderfac) not like '%CHINLE%' 11830 and upcase(orderfac) not like '%INDIAN HEALTH CENTER%' and upcase(orderfac) not 11830! like '%NORTHERN NAVAJO MED%' and upcase(orderfac) not like 11831 '%INDIAN HOSPITAL %' and upcase(orderfac) not like '%ZIA HEALTH %' and 11831! upcase(orderfac) not like '%AIH CLINICAL %' and 11832 upcase(orderfac) not like '%PUEBLO%');ERROR: Expression using not equals (^=) has components that are of different data types. 11833 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 14.17 seconds cpu time 0.45 seconds   ... View more

Thanks! I pasted the code snippet above. Essentially, I'm trying to evaluate with a WHERE statement in PROC SQL whether is a null in both (variable1 *AND* variable2) OR find a string in variable3). ... View more

proc sql;      create table X as      select ....      from ....      where (Symptomatic not in ("","Unknown") AND _illness_onset_dt ne ' ') OR upcase (INV_PROCESS_STATUS) contains 'COMPLETE' and c.case = s.case_no quit; ERROR: Expression using not equals (^=) has components that are of different data types. ... View more