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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between nodupkey and nodup options?

969


Differentiate between sas functions and sas procedures.

1142


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1835


what is the use of proc contents and proc print in sas? : Sas-administrator

996


where are dashboard components are created and maintained? : Sas-bi

965


How would you determine the number of missing or nonmissing values in computations?

1006


how can you import .csv file in to sas? : Sas programming

1043


what are input dataset and output dataset options? : Sas programming

1022


Can you suggest us materials for sdtm mapping?

4387


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

1208


what are the best practices to process the large data sets in sas programming? : Sas-administrator

958


What does the trace option do?

1054


What areas of SAS are you most interested in?

1471


What is SAS? What are the functions does it performs?

1137


hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

2057