How merge two datasets using macro

[aaaaa34]

Hi,

I'm very new in SAS and I have problem which is difficult to me to settle.

I have two datasets.

First is:

name	age
cole	12
emma	13
lisa	15

Second is:

answer

lisa_my_name

what??

How can I merge them by macro only for cases in which answer has values of name variable. The results should be:

answer	age
lisa_my_name	15

[novinosrin · Accepted solution]

Hi @aaaaa34  All you need is a simple inner join or in other words a match merge

proc sql;
create table want as
select a.*,b.*
from second a inner join first b
on answer=name;
quit;

[aaaaa34]

Hi thanks a lot. But I wonder if it's possible to put find condition into do until loop and the make join procedure?
%macro xxx(data_out=);
%let namelist=;
proc sql noprint;
select name
into :namelist separated by "!"
from bbb
;
run;
quit;

data &data_out;
set &data_out;
%let i_1 =1;
%do %until (%qscan(&namelist,&i_1,'!') = %str());
%let zm1=%scan(&namelist,&i_1,'!');
if find(namelist, "&zm1", "i")>0 then answer= answer;
%let i_1=%eval(&i_1+1);
%end;
run;

[aaaaa34]

I edited my post to show you more complex cases.