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;

i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers

3 Answers   SAS,

---

how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this?

8 Answers   Wipro, Xansa,

---

How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C

3 Answers   Accenture, Oracle,

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

0 Answers  

---

Give e an example of..

0 Answers  

---

What are the ways in which macro variables can be created in sas programming?

0 Answers  

---

Which are the statements whose placement in the data step is critical?

0 Answers  

---

if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??

6 Answers   Accenture,

---

How do you use the do loop if you don’t know how many times you should execute the do loop?

0 Answers  

---

Can you execute macro within another macro? : sas-macro

0 Answers  

---

Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 Answers  

---

How would you include common or reuse code to be processed along with your statements?

3 Answers   Accenture,

---