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
- 3 Answers
- 6816 Views
- I also Faced
- E-Mail Answers
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
How to specify variables to be processed by the freq procedure?
What are all the problems you faced while validating tables and reports?
what is sas olap server? : Sas-di
What are the functions which are used for character handling functions?
Tell e how how dealt with..
Describe a time when you were really stuck on a problem and how you solved it?
What was the last computer book you purchased? Why?
what is the use of proc contents and proc print in sas? : Sas-administrator
what is factor analysis? : Sas-administrator
what is change analysis in sas di ? : Sas-di
How can you limit the variables written to output dataset in data step?
what are the types of interactive display types? : Sas-bi
In sas, what are the areas that you are most interested in? : sas-grid-administration
What is the basic structure of the SAS base program?
what is sas metadata repository? : Sas-bi
