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
What is the difference between nodupkey and nodup options?
Differentiate between sas functions and sas procedures.
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.
what is the use of proc contents and proc print in sas? : Sas-administrator
where are dashboard components are created and maintained? : Sas-bi
How would you determine the number of missing or nonmissing values in computations?
how can you import .csv file in to sas? : Sas programming
what are input dataset and output dataset options? : Sas programming
Can you suggest us materials for sdtm mapping?
How do you use the do loop if you don’t know how many times you should execute the do loop?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
What does the trace option do?
What areas of SAS are you most interested in?
What is SAS? What are the functions does it performs?
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?