Good day Expects,
i have 2 data set and i wanna join/compress , however they do not have a common denominator. when i run the bellow script i am only getting 5 records, and i was expecting 19m records , please assist
PROC SQL;
CREATE TABLE SAP_WI AS
SELECT *
'W&I' AS BU, A.*
FROM DTA.WI_ALL_BA_SAP_ACCOUNTS B
INNER JOIN VBM.SAP_BUT_MATCH A
ON INPUT(PUT(COMPRESS(INPUT(PUT(ACC_NUM,16.),$16.)||PUT(SERIAL_NUM,Z3.)),$16.),16.) = INPUT(PUT(ZZ0011,$16.),16.)
;
QUIT;