Age: Difference between revisions
Jump to navigation
Jump to search
(→SAS) |
(m) |
||
Line 1: | Line 1: | ||
{{Data_element | |||
| field_name = Age | |||
| element_description = Age is the number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if available, Arrive DtTm otherwise). | |||
| in_table = Created_Variables | |||
| data_type = integer | |||
| program_collecting = Med and CC | |||
| created_raw = Created | |||
}} | |||
Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT scale]] used in Medicine. | Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT scale]] used in Medicine. | ||
Line 19: | Line 33: | ||
*Both formula yields the same AGE values. | *Both formula yields the same AGE values. | ||
== Related fields == | |||
* [[Date of Birth]] | |||
* [[Accept DtTm]] | |||
* [[Arrive DtTm]] | |||
[[Category: APACHE II]] | [[Category: APACHE II]] | ||
[[Category: MOST Score Elements]] | [[Category: MOST Score Elements]] | ||
[[Category: Data structure]] | [[Category: Data structure]] |
Revision as of 12:42, 2016 September 19
Data Element (edit) | |
Field Name: | Age |
CCMDB Label: | not stated |
CCMDB tab: | not stated |
Table: | Created_Variables |
Data type: | integer |
Length: | not stated |
Program: | Med and CC |
Created/Raw: | Created |
Start Date: | 1988-07-11 |
End Date: | 2300-01-01 |
Sort Index: | 999 |
Age is the number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if available, Arrive DtTm otherwise).
Age is part of the APACHE II score for Critical Care and ALERT scale used in Medicine.
Function to calculate Age
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)
- this is calculated as part of queries ages and '; can we eliminate query "ages" or is it actually used somewhere? Ttenbergen 16:20, 2016 July 4 (CDT)
SAS
- Julie, do you still do your own calculation for this in SAS or do you now use the output of query ages that has been around for a long time? It would likely be best to only calculate this in one spot, and right now you'd have to update your SAS to use the new fields, so this might be a good time to start using the query. If you are up to it then please delete the SAS part when done. Ttenbergen 16:07, 2016 July 4 (CDT)
- I haven't used the query ages. I use the age field from the created variables. but if I need only the age and I have called the L_LOG_PHI, I used the formula instead of calling another query. I suggest we just keep the SAS formula in case someone will ask how we are computing age in SAS because this formula is just one of the ways to calculate age in 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)
- Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
- Both formula yields the same AGE values.