HEALTHCARE COST & UTILIZATION PROJECT

User Support

Do Your own analysis
Explore Expert Research & Limited Datasets

Central Distributor SASD: Description of Data Elements

 
AGEDAY - Age in days (when AGE is less than 1 year)
 
Documentation Sections:
General Notes
Uniform Values
State Specific Notes
General Notes
 

Age in days (AGEDAY) is reported for patients less than 1 year old. AGEDAY is calculated from date of birth (DOB) and the admission date (ADATE) with the following exceptions:

  • AGEDAY is set to the supplied age in days if the age cannot be calculated (ADATE and/or DOB is missing or invalid).
  • AGEDAY is missing (.) if the age cannot be calculated and the reported age in days is missing.
  • AGEDAY is missing (.) if the calculated age in years is out of range (AGE NE 0-124).
  • AGEDAY is invalid (.A) if the age in days cannot be calculated and the supplied age in days is nonnumeric. An invalid calculated AGEDAY is not replaced by the reported age in days.
  • If the data source does not provide the necessary dates to calculate age in days or the reported age in days, then beginning in the 1998 data, AGEDAY is not present on the HCUP files. In the 1988-1997 data, AGEDAY is retained on the HCUP files and is set to unavailable from source (.B).
  • AGEDAY is set to inconsistent (.C) if one of the HCUP edit checks is triggered. The age edit checks vary by year.
    • Beginning in the 1998 data, AGEDAY is inconsistent with neonatal diagnoses (EAGE04), or is inconsistent with maternal diagnoses/procedures (EAGE05).
    • In the 1998-1997 data, AGEDAY is inconsistent with AGE (ED021), neonatal diagnoses (ED3nn), maternal diagnoses (ED4nn), or maternal procedures (ED5nn).

When processing the 1996 HCUP inpatient data, no adjustment was made for the leap year when age was calculated from date of birth and admission date. This caused infants admitted on the day before their first birthday to have AGE=1 and AGEDAY = missing (.), instead of AGE=0 and AGEDAY=364.

 
Top
 
 
 
Uniform Values
 
VariableDescriptionValueValue Description
AGEDAYAge in days (when AGE is less than 1 year)0-364Days
.Missing
.AInvalid
.BUnavailable from source (coded in 1988-1997 data only)
.CInconsistent: beginning with 1998 data, EAGE04, EAGE05; in 1988-1997 data, ED021, ED3nn, ED4nnn, ED5nn
 
Top
 
 
 
State Specific Notes

California

Central Distributor only - because of confidentiality restrictions, age in days (AGEDAY) is suppressed on some records.

Only the calculated age in days could be used to assign AGEDAY because California did not supply this information. Because California did not provide an admission date, the date of service was used to calculate age in days.



Colorado

Beginning in data year 2014, Colorado no longer supplies age in days. Age in days could not be calculated because the date of birth (DOB) provided by Colorado does not include the day of birth. Only birth month and year are provided. The day of birth was set to 15 for all records.



District of Columbia

Only the calculated age in days could be used to assign AGEDAY because the District of Columbia did not supply this information.



Indiana

Only the calculated age in days was used to assign AGEDAY.



Kentucky

Prior to 2008, only the calculated age in days could be used to assign AGEDAY because Kentucky did not supply this information. Beginning 2008, age in days was used to assign AGEDAY.



Maryland

Beginning in 2013, the supplied age in days is used when the data element cannot be calculated.



Minnesota

Only the calculated age in days could be used to assign AGEDAY because Minnesota did not supply this information.



Nebraska

Only the calculated age in days could be used to assign AGEDAY because Nebraska did not supply this information.



New Jersey

Beginning in 2009, New Jersey supplied age in months.

In 2008, only the calculated age was used to assign AGEDAY because New Jersey did not supply age in days.

Beginning in 2001, the reported Age in Days was used when AGEDAY could not be calculated. Prior to 2001, only the calculated age could be used to assign AGEDAY because New Jersey did not supply age in days.



New York

Beginning with the 2008 data, the HCUP data element AGEDAY is missing (.) for AIDS/HIV patients. New York identifies AIDS/HIV records by ICD-9-CM diagnosis code, DRG, or MS-DRG:

  • An admitting, principal or any secondary diagnosis of "042", "043", "044", "7958", "27910", "27919", "2793", "1363", "79571", "07951", "07952", "07953", "V017" or "V08".
  • A DRG of 488 through 490 (prior to October 2007) or MS-DRG of 700 through 716 (beginning in October 2007).

Please note that the admitting diagnosis is not retained in the HCUP databases prior to 2012.

In the 1988-1997 HCUP New York databases, the data source provided admission year and month, but did not provide the day. A day of "01" was imputed for all records. The imputed date was not used to calculate other data elements or to perform edit checks. Beginning in 1998, the complete admission date was provided by the data source.



New York

Beginning in 2002, both ADATE and DDATE are loaded from the admission date because full admission dates are provided, but only the year and month is provided for the services/discharge date.

In the 1988-1997 HCUP New York databases, AGEDAY could not be calculated because New York did not report full admission and birth dates. During HCUP processing, only the reported age in days could be used to assign AGEDAY.



North Carolina

Because North Carolina did not provide an admission date, the principal procedure date was used to calculate age in days.



Utah

Only the calculated age could be used to assign AGEDAY because Utah did not supply age in days.



Vermont

Only the calculated age in days could be used to assign AGEDAY because Vermont did not supply this information.


Top
 
 
 

Internet Citation: HCUP Central Distributor SASD Description of Data Elements - All States. Healthcare Cost and Utilization Project (HCUP). April 2008. Agency for Healthcare Research and Quality, Rockville, MD. www.hcup-us.ahrq.gov/db/vars/sasddistnote.jsp?var=ageday.
Are you having problems viewing or printing pages on this website?
If you have comments, suggestions, and/or questions, please contact hcup@ahrq.gov.
Privacy Notice, Viewers & Players
Last modified 4/11/08