on work.EXUPL_GVA4_&YYMM from table is EXUPL_GVA2_&YYMM. or EXUPL_GVA3_&YYMM the below code will work if you want to use EXUPL_GVA3_&YYMM to create work.EXUPL_GVA4_&YYMM. PROC SQL;
CREATE TABLE WORK.EXUPL_GVA4_&YYMM. AS
SELECT
S.FIL AS FILMAP,
S.KTO AS KTOMAP,
(CASE WHEN S.KTO EQ 9999989 AND S.KTOMAP NOT IN (. 9999989) THEN S.FIL) END) AS FIL,
(CASE WHEN S.KTO EQ 9999989 AND S.KTOMAP NOT IN (. 9999989) THEN S.KTO) END) AS KTO,
S.PCC,
S.GBM,
R.*
FROM
WORK.EXUPL_GVA1_&YYMM. AS R
LEFT JOIN LIB_CLNT.CLIENT2SEGMENT_FKN_FINAL_&YYMM.(WHERE =( FIL AND KTO <=0)) AS S
ON R.ORG_ID=S.ORG_ID
LEFT JOIN LIB_CLNT.CLIENT_MASTER_&YYMM. AS S1
ON S.FIL=S1.FIL AND S.KTO=S1.KTO;
QUIT;
... View more