Hi Tom, Thank you. Finally, it works. It seems the tab character for indention is causing the issue. There are now observations found. 100 %dynamic_left_join(COUNTERPARTY, COUNTERPARTY_HIST);
MPRINT(DYNAMIC_LEFT_JOIN): data UNQ_KEY;
MPRINT(DYNAMIC_LEFT_JOIN): set CTL_JOINFLD;
MPRINT(DYNAMIC_LEFT_JOIN): length t1 t2 $ 30;
MPRINT(DYNAMIC_LEFT_JOIN): t1 = trim(tbl_name1);
MPRINT(DYNAMIC_LEFT_JOIN): t2 = trim(tbl_name2);
MPRINT(DYNAMIC_LEFT_JOIN): put t1=t2=;
MPRINT(DYNAMIC_LEFT_JOIN): if t1 eq "COUNTERPARTY" and t2 eq "COUNTERPARTY_HIST" then join_key = catx(' = ','X.' || prim_key,
'Y.' || prim_key);
MPRINT(DYNAMIC_LEFT_JOIN): else delete;
MPRINT(DYNAMIC_LEFT_JOIN): run;
t1=COUNTERPARTY t2=COUNTERPARTY_HIST
t1=COUNTERPARTY t2=COUNTERPARTY_HIST
t1=LKP_BS_GL_FRP_MAP t2=LKP_BS_GL_FRP_MAP
t1=LKP_BS_GL_FRP_MAP t2=LKP_BS_GL_FRP_MAP
NOTE: There were 4 observations read from the data set WORK.CTL_JOINFLD.
NOTE: The data set WORK.UNQ_KEY has 2 observations and 7 variables.
... View more