topic Re: calculate date someone turned a certain age in SAS Programming

calculate date someone turned a certain age

GreggB — Tue, 20 Jun 2017 20:03:07 GMT

I need to calculate when this person turned 6 and then count the the number of days from the servedate to the date he turned six, essentially TurnedSix-Servedate (expressed in days)

data temp;
infile datalines dsd missover;
informat dob servedate mmddyy8.;
input dob servedate;
cards;
10/20/10, 01/20/16
;
run;
proc print;
format dob servedate mmddyy.;
run;
data need;
set temp;
TurnedSix= ;
DaysServed= ;
run;

Re: calculate date someone turned a certain age

PaigeMiller — Tue, 20 Jun 2017 20:12:08 GMT

Date person turns 6 can be computed with the INTNX function, or just by incrementing the year by 6.

Since the variables of interest are already SAS date values (am I correct about this?), all you have to do is do the subtraction and you will know the number of days. You could also use INTNX, but subtraction is simpler.

Re: calculate date someone turned a certain age

Reeza — Tue, 20 Jun 2017 20:05:32 GMT

Use INTNX to increment the birthdate 6 years.

date_6years = intnx('year', dob, 6, 's');

date_diff = servedate - date_6years;