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
- 6686 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 do you convert basic cube to transaction cube and transaction cube to basic cube?
what is transformation in sas data integration? : Sas-di
how to change the execute of macro
What is the general format of function in sas? : sas-grid-administration
what is the purpose of _error_? : Sas programming
What can be the size of largest dataset in SAS?
: and & modifiers.
What is a pdv and what are its functions?
Briefly explain input and put function?
How do you debug and test your SAS programs?
Mention common programming errors committed in sas ?
How to create list output for cross-tabulations in proc freq?
What is the difference between proportion and average?
what are validation tools that are used in sas? : Sas-administrator
What is the basic structure of a sas program?
