Yeah, I had tried using Calculated but got error : "the following were not found as CALCULATED references in the immediate query". Proc sql; create table b AS
SELECT DISTINCT
COALESCE(A.ID,B.ID) AS ACCT_ID,
COALESCE(A.ACCT_NUM, B.ACCT_NUM) AS ACCT_NUM,
A.PRD_CD AS PRODUCT,
A.OPRTR_ID AS PTS,
A.EVENT_SCRN_ID AS SCREEN,
A.EVENT_DT AS DATE,
A.TIME,
A.EVENT_TP_CD AS CODE,
A.FROM_EMPL_NAME,
A.TO_EMPL_NAME,
A.FROM_EMPL_ADDRESS,
A.TO_EMPL_ADDRESS,
B.FROM_JOB_TITLE,
B.TO_JOB_TITLE,
b.EVENT_TP_CD AS CODE_JOB_TITLE,
B.time AS TIME_JOB_TITLE,
b.oprtr_id AS PTS_JOB_TITLE,
B.EVENT_SCRN_ID AS SCREEN_JOB_TITLE,
C.crnt_bal_amt
FROM B0 AS A full
JOIN B1 AS b
ON A.ACCT_NUM=B.ACCT_NUM
AND A.EVENT_DT=B.EVENT_DT
AND A.EVENT_TP_CD='055'
AND B.EVENT_TP_CD='054'
INNER JOIN ice.snapshot C
ON calculated acct_id=C.ID
AND C.CUST_DATA_43=''; quit; I've highlighted the two lines of concern in green (the second line, and the one prior to the very last line). Should I instead make the join condition: on a.id or b.id=c.id?
... View more