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
- 5642 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
What are pdv and it functions?
Differentiate between format and informat? : sas-grid-administration
describe how to adjust the performance of data integrator? : Sas-di
what are validation tools that are used in sas? : Sas-administrator
Describe 5 ways to do a “table lookup” in SAS?
How do dates work in sas?
What is maximum storage capability of SAS?
Mention sas system options to debug sas macros.
what is ae onset date n what is RDS
what is intially documentation in sas?
What is the difference between SAS functions and procedures?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
explain about various caches available in data integrator? : Sas-di
Explain proc sort?
what is the difference between floor and ceil functions in sas? : Sas-administrator
