Sas Age Calculation Floor

Calculate age from birth date posted 02 07 2018 01 07 pm 12008.

Sas age calculation floor.

Based on the outputs the calculation using yrdif seems to be a good option. Unlike the floorz function the floor function fuzzes the result. The precision of the memberdateofbirth a stored sas date variable was causing the age15 variable to resolve to 18 with no decimal places. To compute age using a date of birth and the current.

There is also an article in sas blog discussing this. In sas date type variables contain the number of days between january 1 1960 and the date specified. 1 like 14 replies 14. The approach is to first calculate the number of completed months between the two dates and then divide by 12.

Will cause the following message to be placed on the log. In mathematics and computer science the floor function is the function that takes as input a real number and gives as output the greatest integer less than or equal to denoted or similarly the ceiling function maps to the least integer greater than or equal to denoted or. For example the following lines. Computing ages with yrdif the sas help and documentation states that the yrdif function returns the difference in years between two dates since age is the difference in years between two dates a birth date and some other date the yrdif function has been used to compute ages in this way.

The floorz function does not fuzz the result. Susan lamented the subtle issues using the yrdif function exactly 1 0356164384 years ago. Age int yrdif birth date ending date actual. How can you reliably compute the age of someone or something.

For an adult study all of these approaches in calculating age seem to be ok. The macro is used in a sas data step as follows. The simple way using 365 25 as divider is actually a pretty good option. If the argument is within 1e 12 of an integer the floor function fuzzes the result to be equal to that integer.

For example and while. Sure you could write your own function for calculating such things as i suggested 0 1753424658 years ago. Therefore with the floorz function you might get unexpected results. The use of yrdif function is detailed in the sas online document.

Age floor yrdif datepart birth date today age view solution in original post.