topic Re: DOB in SAS Programming

DOB

helpmedoubts — Thu, 20 Aug 2020 18:06:45 GMT

Write a program to calculate your date of birth if your age is 30.

Re: DOB

Kurt_Bremser — Thu, 20 Aug 2020 18:15:38 GMT

What have you tried so far? Please post your code.

Re: DOB

helpmedoubts — Thu, 20 Aug 2020 18:24:04 GMT

Data want;
DOB=today()-365*30;
Format dob date9.;
Run;

Re: DOB

Kurt_Bremser — Thu, 20 Aug 2020 18:36:15 GMT

Looks good to me. Have a look at the INTNX function for an alternative.

Re: DOB

Reeza — Thu, 20 Aug 2020 20:08:47 GMT

You cannot get an exact date of birth. You know the date of birth is within 364 days of the 30 years from today but not the exact date.
You would need more specific information to answer this correctly.

Re: DOB

Astounding — Fri, 21 Aug 2020 01:17:38 GMT

The previous posts all raise valid points. Let's take a look at your code a bit more closely.

You move back 365 * 30 days. That's only approximately correct. A block of 30 years will contain approximately 7 leap years, where that year contains 366 days. So a more accurate attempt would be:

DOB = intnx('year', today(), -30, 'same');

That moves back to the same day of the year as the current date, 30 years ago. And as was pointed out, there will be many valid dates that fit the bill. This calculation gives you one of those valid dates.

Re: DOB

helpmedoubts — Mon, 24 Aug 2020 03:26:44 GMT

Thanks a lot for explaining it so well. The code worked perfectly.