We want to merge file A and B. File A has variable age, file B provide birthd

We want to merge file A and B. File A has variable age,
file B provide birthdate. How to merge the data according
to age in file B

Question Posted / guest

3 Answers
6637 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge t..

Answer / ramesh

First calculate age in B datase

data age;
set b;
age=int(intck('day',bday,today())/365.25);
run;

sort both datasets by the age key variable and Use the
merge statement to combine the both datasets

Is This Answer Correct ?

10 Yes

1 No

We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge t..

Answer / vishal

Calculate age in dataset B by using the following code:
data ages;
set b;
retain current;
if _n_=1 then current=today();
format bday current worddate20.;
age=int(intck('month',bday,current)/12);
if month(bday)=month(current) then
age=age-(day(bday)>day(current));
run;

Source: http://support.sas.com/kb/24/567.html

Is This Answer Correct ?

0 Yes

0 No

We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge t..

Answer / alok karan

First calculate age in BB dataset:

data bbb;
set bb;
age=round(yrdif(birthdate,today(),'Actual'),1);
run;
proc sort data=bbb;
by age;
drop birthdate;
run;

Now merge both dataset by age variable:
data abc;
merge aa bbb;
by age;
run;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer