Age: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (m) |
Ttenbergen (talk | contribs) m (m) |
||
Line 2: | Line 2: | ||
| field_name = age | | field_name = age | ||
| element_description = The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Accept DtTm]] if applicable, [[Arrive DtTm]] otherwise). | | element_description = The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Accept DtTm]] if applicable, [[Arrive DtTm]] otherwise). | ||
| in_table = | | in_table = Created_variables_common | ||
| data_type = number | | data_type = number | ||
| datafield_length = | | datafield_length = |
Revision as of 12:17, 2017 February 6
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.