Hi All,
I've two datasets , called test1 and test2 , i want to create one more dataset based upon "name" fields with all the data of test1 and test2. I want to add one more field like "action_flag" with value 1 or 0. if name match then action_flag=1 else 0
data test1;
input id name $;
cards;
1 ab
2 cf
3 er
;
run;
data test2;
input id name $;
cards;
1 ab
2 df
3 er
4 hj
;
run;
Thank you in advance.
proc sort data=test1; by name; run; proc sort data=test2; by name; run; data want; merge test1 (in=a) test2 (in=b); by name; action_flag=ifn(a and b,1,0); run;
proc sort data=test1; by name; run; proc sort data=test2; by name; run; data want; merge test1 (in=a) test2 (in=b); by name; action_flag=ifn(a and b,1,0); run;
I'm interpreting the problem slightly differently:
proc sort data=test1;
by id;
run;
proc sort data=test2;
by id;
run;
data want;
merge test1 (rename=(name=name1))
test2 (rename=(name=name2));
by id;
action_flag = (name1=name2);
run;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.