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
- 6923 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 does sas handle missing values in assignment statements? : Sas programming
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
What are symget and symput? : sas-macro
What are the difficulties u faced while doing vital signs table or dataset?
What is the use of %include statement?
What is the purpose of trailing @ and @@? How do you use them?
Which function is used to count the number of intervals between two sas dates?
What do the SAS log messages "numeric values have been converted to character" mean?
For clinical entire study how many tables will create approx?
What is a macro routine?
How do you test for missing values?
How would you include common or reuse to be processed along with your statements?
What are the applications primarily used by business analyst? : Sas-bi
How would you determine the number of missing or nonmissing values in computations?
What is the sas data set? : sas-grid-administration
