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;

What is interleaving in SAS?

0 Answers  

---

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

10 Answers   Accenture,

---

How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.

4 Answers   TCS,

---

proc means? proc sort? proc append? proc freq? proc print? proc content?

4 Answers   Oracle,

---

how many display types available in sas bi dashboard? : Sas-bi

0 Answers  

---

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?

2 Answers  

---

what is the need of INDEX in datasets?

6 Answers   CitiGroup,

---

Are you sensitive to code walk-throughs peer review or QC review?

0 Answers   Quintiles,

---

What is PROC in SAS?

0 Answers  

---

what is SAS/Graph?

1 Answers   CitiGroup, NTPC,

---

What are the different versions of sas that you have used until now? : sas-grid-administration

0 Answers  

---

explain about sas business intelligence? : Sas-bi

0 Answers  

---