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
- 6795 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vishal
Calculate age in dataset B by using the following code:
data ages;
set b;
retain current;
if _n_=1 then current=today();
format bday current worddate20.;
age=int(intck('month',bday,current)/12);
if month(bday)=month(current) then
age=age-(day(bday)>day(current));
run;
Source: http://support.sas.com/kb/24/567.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / alok karan
First calculate age in BB dataset:
data bbb;
set bb;
age=round(yrdif(birthdate,today(),'Actual'),1);
run;
proc sort data=bbb;
by age;
drop birthdate;
run;
Now merge both dataset by age variable:
data abc;
merge aa bbb;
by age;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
How would you include common or reuse to be processed along with your statements?
which date functions advances a date time or date/time value by a given interval? : Sas programming
What is the purpose of the trailing and How would you use them?
What are the prime responsibilities of data integration administrator? : Sas-di
how the sas basic syntax style described? : Sas-administrator
Enlist the functions performed by sas.
how will you location sas platform applications available from web browser? : Sas-bi
Does anybody has lastest SAS certification dumps,if anybody has please mail me on saggydesai@gmail.com
How to select the observations randomly from a SAS dataset
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
Can you explain the process of calendar?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
Teradata 
