Hello! I want to leave records from Table2 which match composite key from Table1 loaded to hash object but get an error data merged;
if 0 then set Table2;
if _n_ = 1 then do;
declare hash h(dataset: 'Table1(keep=MOV_CENTRO_ALTA MOV_CUENTA MOV_NUMER_MOV)');
h.defineKey('MOV_CENTRO_ALTA', 'MOV_CUENTA', 'MOV_NUMER_MOV');
h.DefineData('MOV_CENTRO_ALTA', 'MOV_CUENTA', 'MOV_NUMER_MOV');
h.defineDone();
end;
set Table2;
if h.find(key: 'DES_CENTRO_ALTA', key: 'DES_CUENTA', key: 'DES_NUMER_MOV')=0 then output;
run; ERROR: Undeclared key symbol MOV_CENTRO_ALTA for hash object at line 34 column 3. ERROR: DATA STEP Component Object failure. Aborted during the EXECUTION phase.
... View more