proc sql;
1397 create table DADFY19_int as
1398 select distinct a.princ_interv_cci_code,a.DAD_TRANSACTION_ID as TXN_ID_AB,
1398! a.ANALYTICAL_INST_TYPE_CODE,
1399 a.ADMISSION_CATEGORY, a.ENTRY_CODE,a.submitting_prov_code, a.PROV,
1400 b.DAD_TRANSACTION_ID,b.INTERV_CCI_CODE, b.INTERV_SEQ_ID, b.EPISODE_SEQ_ID,
1401 b.STATUS_ATTRIBUTE_CODE, b.OOH_IND, b.ANESTHETIC_TECH
1402 from abs_AC_F1920_excl_QC_BC as a
1403 inner join dad19sas.interv as b
1404 on a.DAD_TRANSACTION_ID=b.DAD_TRANSACTION_ID
1405 where b.INTERV_SEQ_ID=1 and b.EPISODE_SEQ_ID=1
1406 and b.INTERV_CCI_CODE not in('','5CA20', '5CA24', '5CA88', '5CA89', '5CA90', 'ZZZZZZZZZZ' )
1407 and UPCASE(b.STATUS_ATTRIBUTE_CODE) NOT IN ('A') and b.OOH_IND not in ('Y')
1408 inner join dad19sas.diagnosis as b
-----
22
76
ERROR 22-322: Syntax error, expecting one of the following: ;, !, &, AND, EXCEPT, GROUP, HAVING,
INTERSECT, OR, ORDER, OUTER, UNION, |.
ERROR 76-322: Syntax error, statement will be ignored.
1409 on a.DAD_TRANSACTION_ID=b.DAD_TRANSACTION_ID
1410 where substr(diag_icd10_code,1,3) in ('O04','O07') or substr(diag_icd10_code,1,4) in
1410! ('P964')
1411 ;
1411! quit;
Any advice on how to correctly join multiple tables?
