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

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

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;

wat has been most common programming mistake?

3 Answers  

---

What are the automatic variables for macro? : sas-macro

0 Answers  

---

how to delete the duplicates by using proc sql?

3 Answers   Genpact,

---

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

1 Answers   Pfizer,

---

How do you add a number to a macro variable? : sas-macro

0 Answers  

---

What are the data types that sas contain?

0 Answers  

---

Can we replace a dataset into view?

6 Answers   CliniRx,

---

What was the last computer book you purchased? Why?

0 Answers   Oracle,

---

What's the difference between VAR A1 - A4 and VAR A1 - A4?

1 Answers   Quintiles,

---

Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

0 Answers  

---

what are the differences between proc report and proc tabulate?

3 Answers  

---

i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?

3 Answers   L&T,

---