topic Re: Subtraction between 2 different date formats in SAS Procedures

Subtraction between 2 different date formats

sanketshah07 — Tue, 18 Nov 2014 01:11:32 GMT

I am dealing with a situation where I have 2 different date formats. One is a full date formatted as yymmdd8. The other is just a year formatted as BEST12. I need to do a subtraction to calculate age at the event and select cases higher than a certain age. Please advise a solution.

Re: Subtraction between 2 different date formats

PGStats — Tue, 18 Nov 2014 03:10:22 GMT

One way is to transform YEAR into a SAS date, say the first of April of that year with MDY(4, 1, YEAR) and then use function YRDIF to calculate the age. Assuming DATE is greater than MDY(4, 1, YEAR) :

if yrdif( mdy(4, 1, year), date, "AGE" ) > ageLimit;

Re: Subtraction between 2 different date formats

Tom — Tue, 18 Nov 2014 05:18:27 GMT

You just need to define what your algorithm is for defining age at event. The simplest is to just use the year from the event.

age_at_event = year(event_date) - year_of_birth ;

Re: Subtraction between 2 different date formats

sanketshah07 — Tue, 18 Nov 2014 16:18:26 GMT

Tom,

This was very helpful and it solved the problem. Thank you for your time. I really appreciate the help.

Sanket