Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you define the end of a macro?

1088


what are all the reports you generated in your recent project?

2197


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1193


How does proc sql work?

1076


Define run-group processing?

1035


what type of graphs we will create(for 2+years candidates)?

2302


i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2492


Describe a time when you were really stuck on a problem and how you solved it?

2547


What is the difference between class statement and by statement in proc means?

1287


What makes sas stand out to be the best over other data analytics tools?

1056


Name validation tools used in SAS

1176


What do you code to create a macro? : sas-macro

1136


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

997


Have you ever used the SAS Debugger?

1753


Briefly explain input and put function?

1079