Hi guys,
suppose to have the following dataset:
data DB1;
input ID :$20. ;
cards;
8
8
8
170
170
170
166
166
166
;
run;
and a list:
data DB2;
input ID :$20. ;
cards;
8
170
152
166
;
run;
Is there a way to match DB1 with DB2 and every time IDs of DB2 are found in DB1 a suffix "999" will be added?
Desired output:
data DB3;
input ID :$20. ;
cards;
8999
8999
8999
170999
170999
170999
166999
166999
166999
;
run;
Thank you in advance.
Best