= HRT / Birth Control (Categorical variables)
* HRT_FINAL -- denotes the use of any hormone replacement therapy
* BCP_FINAL First mentioned on Jing's computer: 2014/05/22
Oral Contraceptives
From file: ''female variables_JING.sas''\\
Location: ''F:\Users\jingfan\Desktop\ahs2\RegistryCancer\May2014\All_Cancers''\\
Note: Necessary for calculating ''AGEATMENOPAUSE''. (See the Menopause Section
)\\
HRT / Birth Control (Duration variables)
Hormone Replacement Therapy (HRT) is a solution to combat the onset of menopause.
| Variable | Meaning |
|---|---|
| Questions 24 - 26 are regarding Hormone Replacment Therapy (HRT) and are measured in years || | |
| HRT | Have you used the estrogen pill/patch around menopause? |
| 1 | No, I have never taken |
| 2 | Yes, I am using estrogens now |
| 3 | Yes, I used them in the past, but not now |
| HRT_TOTAL | approximately the number of decades using estrogen |
| ESTROGEN_FINAL | an almost-boolean varible also dictating the use of HRT |
| -99 1 | left all HRT-associated variables blank -- reassigned to missing |
| -98 2 | premenopausal woman -- reassigned to 0 |
| 1 | marked any HRT-associated variable affirmative |
| 0 | marked did not use HRT |
| ERT_DURATION | Q24: Cumulative years in Estrogen Replacement Therapy (ERT) |
| ERT_LAST_START | Q25: Last started taking ERT |
| ERT_LAST_STOP | Q25: Last stopped taking ERT |
| ERT_LAST_DURATION | Q25: Duration of last ERT |
| ERT_LONG_DURATION | Q26: Duration of longest ERT |
| PROGEST | Have you ever used progesterone for at least 4 courses in one year? |
| 1 | No, I did not take these, or not this often |
| 2 | Yes, I am using them now |
| 3 | Yes, I have used them in the past, but not now. |
| PROGESTERONE_FINAL | an almost-boolean varible also dictating the use of progesterone |
| -99 3 | left all progesterone-associated variables blank -- reassigned to missing |
| -98 4 | premenopausal woman -- reassigned to 0 |
| 1 | marked any progesterone-associated variable affirmative |
| 0 | marked did not use progesterone |
| HRT_FINAL | *Unlike the above HRT variables which refer to estrogen, HRT_FINAL refers to usage of estrogen and/or progesterone |
| -99 5 | Left all associated variables blank -- reassigned to missing |
| -98 6 | Premenopausal woman -- reassigned to 0 |
| 1 | Has taken estrogen or progesterone |
| 0 | Has not taken estrogen and has not taken progesterone -- automatically assigned to men |
| PRG_DURATION | Q28: approximately the number of years progesterone was used |
| PRG_LAST_DURATION | Q29: duration of last-used progesterone medication |
| PRG_LONG_DURATION | Q30: duration of longest-used progesterone medication |
| ALLERT_LAST_MISSING | 0 1 |
| ALLERT_LONG_MISSING | 0 1 |
| ALLPRG_LAST_MISSING | 0 1 |
| ALLPRG_LONG_MISSING | 0 1 |
| ERT_LAST_MISSING | 0 1 |
| ERT_LONG_MISSING | 0 1 |
| PRG_LAST_MISSING | 0 1 |
| PRG_LAST_MISSING | 0 1 |
| ALLHRT_MISSING1 | |
|---|---|
| Variable | Meaning |
| ALLHRT_MISSING0 | |
| Miscelaneous | |
| ALLHRT_MISSING | 1 |
| ALLHRT_MISSING | 0 |
| PRG_TOT_DUR | Numeric variable: total duration of progesterone |
| ERT_COMB_TOT_DUR | ? |
| BCP_TOT_DUR | Birth Control Pill duration-of-use variable |
ERT_DURATION and PRG_DURATION\\
The calculation of for ERT_DURATION and PRG_DURATION are included in the code below. These are based on questions 24 and 28, respectively, in section D of the baseline questionnaire.\\
ERT_COMB_TOT_DUR and PRG_TOT_DUR\\
ERT_COMB_TOT_DUR is the estrogen and combination medication duration-of-use variable, and is based on questions 24-26 and 29-30 in section D of the baseline questionnaire. In calculating the duration,
* questions 25 and 26 are reconciled if both are present
* question 24 is used when only the last-used estrogen medication is present
* question 26 is used when only the longest-used estrogen medication is present
* estrogen medication duration-of-use is compared with the combination medication duration-of-use
* question 28 is not used for ERT_COMB_TOT_DUR as it does not distinguish between progesterone and combination medication use.
PRG_TOT_DUR is the progesterone duration-of-use variable, and is based on questions 28-30 in section D of the baseline questionnaire. In calculating the duration,
* questions 29 and 30 are reconciled if both are present
* question 28 is used when only the last-used progesterone (or combination) medication is present
* question 30 is used when only the longest-used progesterone (or combination) medication is present
Currently, ERT_COMB_TOT_DUR and PRG_TOT_DUR are constructed in multiple datasteps (diagrammed below). Since these variables only apply to menopausal women, non-menopausal women are separated from menopausal women (in MTOT0 and MTOT1, respectively). Furthermore, menopausal women who answered none of the HRT questions were separated from those who did (in HRT_DUR_ALLMISSING1 and HRT_DUR_ALLMISSING0, respectively). PRG_TOT_DUR is constructed in HRT_DUR_ALLMISSING0, and ERT_COMB_TOT_DUR is constructed in ERT_COMB_DATA. All datasets are then combined in a datastep (FEMALE_SPEC2 in the diagram), to create a female-specific dataset with processed HRT duration-of-use variables for all female subjects. This process could be further streamlined.
{{https://www.lucidchart.com/publicSegments/view/2d383b70-45f9-40b9-aa53-…}}
BCP_TOT_DUR \\
Birth control pills duration-of-use variable