By jclloren - August 12, 2018

Incident Diabetes

Here lists variables in the files 'hhf-diabetes_incident_cases.csv' and 'hhf-diabetes_incident_cases.rds'. These files are identical, and include variables used to capture incident diabetes reported in HHFs 1, 3, 5, and 6.

To reconcile the year of incident diabetes diagnoses between HHFs, the 'Diabetes Diagnosis Year Algorithm' was developed. This file is stored in 'S:\SHARED\RESEARCH\Source Data\HHF\'.

Files and Locations

Associated files:
* Location: 'S:\SHARED\RESEARCH\Source Data\HHF\Diabetes\'
* 'HHF_DM_reconciliation.xlsx'

Code files:
* Location: 'S:\SHARED\RESEARCH\Utility Code\HHF Incident Diseases\'
* Files:
* 'diabetes_hhf_cases.R'
* 'dmdx_year_lookup_table.R'

Output files:
* Location: 'S:\SHARED\RESEARCH\Source Data\HHF\'
* Files:
* 'hhf-diabetes_incident_cases.csv'
* 'hhf-diabetes_incident_cases.rds'

Dictionary

Variable	Description
ANALYSISID	Subject identifier
BASELINE_DATE	Date baseline questionnaire was returned. This is considered the enrollment date.
END_DATE	Date of right censoring
HHF1_DATE	Date HHF1 was returned
HHF3_DATE	Date HHF3 was returned
HHF5_DATE	Date HHF5 was returned
HHF6_DATE	Date HHF6 was returned
DMDXTX_0	Prevalent diabetes. This is captured using the 'year of first diagnosis' variable, and the question, 'Have you been treated for this in the last 12 months?' for diabetes types I & II. All prevalent diabetes cases were excluded from the construction of succeeding incident diabetes variables.
DMDX_H1	Based on HHF1, page3, question 9: 'During the last two years, have you developed [diabetes] for the FIRST TIME?'\\ 0:No, 1:Yes
DMDXY_H1	Assigned year of incident diabetes, if\\ * this is not a prevalent DM case (DMDXTX_0 = 0),\\ * only 1 HHF is returned, and this is HHF1,\\ * the subject reported having been diagnosed for the first time with DM during the last 2 years, and\\ * HHF1 was returned after baseline (HHF1_DATE > BASELINE_DATE).
H1	HHF1 was returned\\ 1:Yes, Otherwise missing
DMDXY_H3	Reported year of DM diagnosis in HHF3 ('2002-2004', '2005-2006', '2007-2008', 'returned-blank' (returned but no diagnosis year reported)
DMTX_H3	Reported having been treated in the last 12 months for diabetes.\\ 0:No, 1:Yes
H3	HHF3 was returned\\ 1:Yes, Otherwise missing.
DMMED1_H5	Prescription medication write-in reported for DM in HHF5
DMMED2_H5	Prescription medication write-in reported for DM in HHF5
DMMED3_H5	Prescription medication write-in reported for DM in HHF5
DMMEDS_H5	Any prescription medication reported for DM in HHF5
DMDXY_H5	Reported year of DM diagnosis in HHF5 ('Never', 'Before 2002', '2002-2003', '2004-2005', '2006-2007', '2008-2009', '2010-2011', '2012-2013', 'returned-blank' (returned but no diagnosis year reported)
DMDXTX_H5_MED_Y	Incident DM based on reported diagnosis year in HHF5, and if any prescription was listed.\\ 0:No, 1:Yes
DMDXTX_H5_MED_N	Incident DM based ONLY on reported diagnosis year HHF5, NOT considering any listed prescription.\\ 0:No, 1:Yes
H5	HHF5 was returned\\ 1:Yes, Otherwise missing
DMMED1_H6	Prescription medication write-in for DM reported in HHF6
DMMED2_H6	Prescription medication write-in for DM reported in HHF6
DMMED3_H6	Prescription medication write-in for DM reported in HHF6
DMMEDS_H6	Any prescription medication reported for DM in HHF6
DMDXTX_H6_MED_Y	Incident DM based on reported diagnosis year in HHF6, and if any prescription was listed.\\ 0:No, 1:Yes
DMDXTX_H6_MED_N	Incident DM based ONLY on reported diagnosis year HHF6, NOT considering any listed prescription.\\ 0:No, 1:Yes
H6	HHF6 was returned\\ 1:Yes, Otherwise missing
DMDXYPRE	Year of incident diabetes diagnosis, based only on the lookup table.
DMDXY	Year of incident diabetes diagnosis, considering adjustments (baseline_date + 6 months) in cases where reported diagnosis year(s) are before baseline.
X_DM	DMDXY = 'EXCLUDE'. This exclusion is based on the 'Diabetes Diagnosis Year Algorithm'.
I_DM_OVERALL	Incident diabetes variable.\\ Based on the diabetes questions in HHFs 1, 3, 5, and 6. Any medication write-in reported in HHFs 5 and 6 are assigned a “Yes” for this variable.\\ 0:No, 1:Yes
I_DM_TIMEBASED	Incident diabetes variable.\\ Based on the diabetes questions in HHFs 1, 3, 5, and 6. Medication write-ins reported in HHFs 5 and 6 are notconsidered in generating this variable.\\ 0:No, 1:Yes
AGEOUT_DM	Age at right censoring.\\ For cases: AGEOUT_DM is the difference between date of birth and date of diagnosis. Cases with not diagnosis year will be dropped from the analysis.\\ For non-cases: AGEOUT_DM is the difference between date of birth and the earliest end date (withdrawal date, do not contact date, deceased date, date of last returned HHF).