View source for Age

{{Reporting Indicators
|description=See page
|Program=Critical Care and Medicine
|indicator_start_date=1988-07-11
|indicator_name={{PAGENAME}}
|program=Critical Care and Medicine
}}
{{Data_element
| 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). 
| in_table = Created_Variables_Common table, Created_Variables_CC table
| data_type = number
| datafield_length = 
| program_collecting = Med and CC
| created_raw = Created
| data_element_sort_index = 3
}}


Age is part of the [[APACHE_Scoring_table#Age_Points|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)

== Reported as ==
* Mean, Median, Minimum, Maximum in years per period of time
* Counts or scores based on age ranges  per period of time
== Frequency ==
* monthly, quarterly, yearly based on admission dates or discharge dates
* by site and  by ward/unit

== Related fields ==
* [[Date of Birth]]
* [[Accept DtTm]] 
* [[Arrive DtTm]]

== Related articles == 
{{Related Articles}}


[[Category:APACHE II]]
[[Category:ALERT Scale Elements]]
[[Category:Data structure]]
[[Category:Data Use]]
[[Category:Created Variables]]