Sas Age Calculation Floor

Unlike the floorz function the floor function fuzzes the result.

Sas age calculation floor. How can you reliably compute the age of someone or something. Age intck year dob eventdate continuous hi i was wondering if two methods above have the same function on calculating age based on dob. For example and while. For an adult study all of these approaches in calculating age seem to be ok.

Will cause the following message to be placed on the log. The use of yrdif function is detailed in the sas online document. Sure you could write your own function for calculating such things as i suggested 0 1753424658 years ago. If the argument is within 1e 12 of an integer the floor function fuzzes the result to be equal to that integer.

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. To compute age using a date of birth and the current. Age floor yrdif datepart birth date today age view solution in original post. Or you could ask your colleagues in the discussion forums as i noticed some people doing just.

The precision of the memberdateofbirth a stored sas date variable was causing the age15 variable to resolve to 18 with no decimal places. Age int yrdif birth date ending date actual. Therefore with the floorz function you might get unexpected results. 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.

There is also an article in sas blog discussing this. The approach is to first calculate the number of completed months between the two dates and then divide by 12. It seems like such a simple problem. For example the following lines.

Based on the outputs the calculation using yrdif seems to be a good option. The floorz function does not fuzz the result. Calculate age from birth date posted 02 07 2018 01 07 pm 12008. 1 like 14 replies 14.

The macro is used in a sas data step as follows.