Age
Data Element (edit) | |
Field Name: | age |
CCMDB Label: | not stated |
CCMDB tab: | not stated |
Table: | Created variables common |
Data type: | number |
Length: | |
Program: | Med and CC |
Created/Raw: | Created |
Start Date: | 1988-07-11 |
End Date: | 2300-01-01 |
Sort Index: | 3 |
The number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if applicable, Arrive DtTm otherwise).
Also: Created variables CC
Age is part of the APACHE II score for Critical Care and ALERT scale used in Medicine.
Function to calculate Age
- Both formula yields the same AGE values.
ACCESS
- CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)
- where Birth = Date of Birth and Adm = (Accept DtTm if available, Arrive DtTm otherwise)
SAS
- Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
- where Birth = Date of Birth and R_Adm = (Accept DtTm if available, Arrive DtTm otherwise)
Decided to keep this for now for cross-checking even though it duplicates the calculation in Access.