This is the log summary: PROC SQL; 24 select cc.RPQ_CLASS_KEY, cl.RPQ_CLASS_CD, substr(cl.RPQ_CLASS_DESC,1,50) as RPQ_CLASS_DESC, cl.IQ_PROPER_CD, sic.SIC_CD, 25 cc.ST_CD as CLASS_STATE, d.ST_CD as PROPER_STATE, 26 d.AB_PROPER_CD, d.AC_PROPER_CD, d.AP_PROPER_CD, d.AU_PROPER_CD, d.FR_PROPER_CD, d.AD_PROPER_CD, 26 ! d.AW_PROPER_CD 27 from REF_DATA.RPQ_CLASS_CNTL cc 28 join REF_DATA.RPQ_PROPER_XREF d on cc.RPQ_CLASS_KEY = d.RPQ_CLASS_KEY and (cc.ST_CD = d.ST_CD or cc.ST_CD = 'CW' or 28 ! d.ST_CD = 'CW') and d.SYS_ACTIVE = 'Y' and d.EXP_DT >= current date 28 join REF_DATA.RPQ_PROPER_XREF d on cc.RPQ_CLASS_KEY = d.RPQ_CLASS_KEY and (cc.ST_CD = d.ST_CD or cc.ST_CD = 'CW' or 28 ! d.ST_CD = 'CW') and d.SYS_ACTIVE = 'Y' and d.EXP_DT >= current date ____ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, '.', /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GT, GTT, LE, LET, LT, LTT, NE, NET, OR, ^=, |, ||, ~=. 28 join REF_DATA.RPQ_PROPER_XREF d on cc.RPQ_CLASS_KEY = d.RPQ_CLASS_KEY and (cc.ST_CD = d.ST_CD or cc.ST_CD = 'CW' or 28 ! d.ST_CD = 'CW') and d.SYS_ACTIVE = 'Y' and d.EXP_DT >= current date ____ 76 ERROR 76-322: Syntax error, statement will be ignored. 29 join REF_DATA.RPQ_CLASS_LKUP cl on d.RPQ_CLASS_KEY = cl.RPQ_CLASS_KEY and cl.SYS_ACTIVE = 'Y' 30 left outer join ( 31 select GL_CLS_CODE as CLASS_CD, min(SIC_CD) as SIC_CD from REF_DATA.E_GL_SIC_ASSIGN where GL_CLS_CODE not 31 ! like '8%' and SYS_ACTIVE = 'Y' group by GL_CLS_CODE 32 union all 33 select CLASS_CD, min(SIC_CD) as SIC_CD from REF_DATA.E_PROPER_RECD where CLASS_CD like '8%' and SYS_ACTIVE 33 ! = 'Y' group by CLASS_CD 34 ) sic on cl.RPQ_CLASS_CD = sic.CLASS_CD 35 where cc.SYS_ACTIVE = 'Y' and cc.EXP_DT >= current date 36 order by RPQ_CLASS_DESC, CLASS_STATE, PROPER_STATE 37 ; NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 38 QUIT; NOTE: The SAS System stopped processing this step because of errors.
... View more
