topic Re: Add a numeric suffix after matching of two lists in New SAS User

Add a numeric suffix after matching of two lists

NewUsrStat — Fri, 08 Nov 2024 10:02:19 GMT

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

Re: Add a numeric suffix after matching of two lists

yabwon — Fri, 08 Nov 2024 09:44:10 GMT

data db3_test;
  if 1=_N_ then
    do;
      declare hash h(dataset: "db2");
      h.defineKey('ID');
      h.defineDone();
    end;
  set db1;

  if h.check()=0 then id = cats(id,'999');
run;
proc print;
run;

Re: Add a numeric suffix after matching of two lists

yabwon — Fri, 08 Nov 2024 09:45:24 GMT

According to your description this:

170999
170999
170999

should not exist in DB3.

Re: Add a numeric suffix after matching of two lists

NewUsrStat — Fri, 08 Nov 2024 10:02:58 GMT

Sorry I edited. I made a mistake!