* Derivation for Adherence and Non-adherence to Low Risk Drinking Guidelines (variable LOWRISKDRINK)
* Low risk includes females who have 9 or less drinks in the past week, males who have 14 or less drinks in the past week,
* plus no more than 2 drinks on each day of the week for both males and females,
* pregnant and breastfeeding women should be excluded from analysis- they are categorized as "pregnant or lactating"
* persons aged <19 should be excluded from analysis- they are categorized as "not applicable"
* This syntax file replaces a previous one that had an error in it as well as coding differences. These are documented
* at the bottom.
* Note that respondents could have an "average daily alcohol consumption" of zero and still be a high risk drinker because
* they had 3 drinks on one day during the week and zero on every other day, thus having a calculated average of 0.4 or 0.
** CCHS 2000/01 (Cycle 1.1)**
IF (dhha_sex = 1 & alcadwky <= 14 & alca_5a1 <=2 & alca_5a2 <=2 & alca_5a3 <=2 & alca_5a4 <=2 & alca_5a5 <=2 & alca_5a6 <=2 & alca_5a7 <=2) LOWRISKDRINK = 1 .
IF (dhha_sex = 2 & alcadwky <= 9 & alca_5a1 <=2 & alca_5a2 <=2 & alca_5a3 <=2 & alca_5a4 <=2 & alca_5a5 <=2 & alca_5a6 <=2 & alca_5a7 <=2) LOWRISKDRINK = 1 .
IF (dhha_sex = 1 & (alcadwky > 14 | alca_5a1 >2 | alca_5a2 >2 | alca_5a3 >2 | alca_5a4 >2 | alca_5a5 >2 | alca_5a6 >2 | alca_5a7 >2)) LOWRISKDRINK = 2.
IF (dhha_sex = 2 & (alcadwky > 9 | alca_5a1 >2 | alca_5a2 >2 | alca_5a3 >2 | alca_5a4 >2 | alca_5a5 >2 | alca_5a6 >2 | alca_5a7 >2)) LOWRISKDRINK = 2 .
EXECUTE.
IF (alcadwky=0) LOWRISKDRINK =1.
EXECUTE.
IF (alca_1=2) LOWRISKDRINK =1.
EXECUTE.
IF (mama_37 = 9 | mama_37 = 7) LOWRISKDRINK = 9 .
IF (brfa_03 = 9) LOWRISKDRINK = 9 .
IF (alcadwky = 999) LOWRISKDRINK = 9 .
IF (brfa_03 = 1) LOWRISKDRINK = 3 .
IF (mama_37 = 1) LOWRISKDRINK = 3 .
IF (dhha_age) <19 LOWRISKDRINK = 6.
EXECUTE .
FORMAT LOWRISKDRINK (f1.0).
VARIABLE LABEL LOWRISKDRINK 'Low Risk Drinking Guidelines'.
VALUE LABEL LOWRISKDRINK 1 "Low Risk" 2 "High Risk" 9 "Not Stated" 6 "Not Applicable" 3 "Pregnant or Lactating".
EXECUTE.
** CCHS 2003 (Cycle 2.1)
IF (dhhc_sex = 1 & alccdwky <= 14 & alcc_5a1 <=2 & alcc_5a2 <=2 & alcc_5a3 <=2 & alcc_5a4 <=2 & alcc_5a5 <=2 & alcc_5a6 <=2 & alcc_5a7 <=2) LOWRISKDRINK = 1 .
IF (dhhc_sex = 2 & alccdwky <= 9 & alcc_5a1 <=2 & alcc_5a2 <=2 & alcc_5a3 <=2 & alcc_5a4 <=2 & alcc_5a5 <=2 & alcc_5a6 <=2 & alcc_5a7 <=2) LOWRISKDRINK = 1 .
IF (dhhc_sex = 1 & (alccdwky > 14 | alcc_5a1 >2 | alcc_5a2 >2 | alcc_5a3 >2 | alcc_5a4 >2 | alcc_5a5 >2 | alcc_5a6 >2 | alcc_5a7 >2)) LOWRISKDRINK = 2.
IF (dhhc_sex = 2 & (alccdwky > 9 | alcc_5a1 >2 | alcc_5a2 >2 | alcc_5a3 >2 | alcc_5a4 >2 | alcc_5a5 >2 | alcc_5a6 >2 | alcc_5a7 >2)) LOWRISKDRINK = 2 .
EXECUTE.
IF (alccdwky=0) LOWRISKDRINK =1.
IF (alcc_1=2) LOWRISKDRINK =1.
EXECUTE.
IF (mamc_037 = 9 | mamc_037 = 7) LOWRISKDRINK = 9 .
IF (mexc_05 = 9) LOWRISKDRINK = 9 .
IF (alccdwky = 999) LOWRISKDRINK = 9 .
IF (mamc_037 = 1) LOWRISKDRINK = 3 .
IF (mexc_05 = 1) LOWRISKDRINK = 3 .
IF (dhhc_age) <19 LOWRISKDRINK = 6.
EXECUTE .
FORMAT LOWRISKDRINK (f1.0).
VARIABLE LABEL LOWRISKDRINK 'Low Risk Drinking Guidelines'.
VALUE LABEL LOWRISKDRINK 1 "Low Risk" 2 "High Risk" 9 "Not Stated" 6 "Not Applicable" 3 "Pregnant or Lactating".
EXECUTE.
** CCHS 2005 (Cycle 3.1)
IF (dhhe_sex = 1 & alcedwky <= 14 & alce_5a1 <=2 & alce_5a2 <=2 & alce_5a3 <=2 & alce_5a4 <=2 & alce_5a5 <=2 & alce_5a6 <=2 & alce_5a7 <=2) LOWRISKDRINK = 1 .
IF (dhhe_sex = 2 & alcedwky <= 9 & alce_5a1 <=2 & alce_5a2 <=2 & alce_5a3 <=2 & alce_5a4 <=2 & alce_5a5 <=2 & alce_5a6 <=2 & alce_5a7 <=2) LOWRISKDRINK = 1 .
IF (dhhe_sex = 1 & (alcedwky > 14 | alce_5a1 >2 | alce_5a2 >2 | alce_5a3 >2 | alce_5a4 >2 | alce_5a5 >2 | alce_5a6 >2 | alce_5a7 >2)) LOWRISKDRINK = 2.
IF (dhhe_sex = 2 & (alcedwky > 9 | alce_5a1 >2 | alce_5a2 >2 | alce_5a3 >2 | alce_5a4 >2 | alce_5a5 >2 | alce_5a6 >2 | alce_5a7 >2)) LOWRISKDRINK = 2 .
EXECUTE.
IF (alcedwky=0) LOWRISKDRINK =1.
IF (alce_1=2) LOWRISKDRINK =1.
EXECUTE.
IF (mame_037 = 9 | mame_037 = 7) LOWRISKDRINK = 9 .
IF (mexe_05 = 9) LOWRISKDRINK = 9 .
IF (alcedwky = 999) LOWRISKDRINK = 9 .
IF (mame_037 = 1) LOWRISKDRINK = 3 .
IF (mexe_05 = 1) LOWRISKDRINK = 3 .
IF (dhhe_age) <19 LOWRISKDRINK = 6.
EXECUTE .
FORMAT LOWRISKDRINK (f1.0).
VARIABLE LABEL LOWRISKDRINK 'Low Risk Drinking Guidelines'.
VALUE LABEL LOWRISKDRINK 1 "Low Risk" 2 "High Risk" 9 "Not Stated" 6 "Not Applicable" 3 "Pregnant or Lactating".
EXECUTE.
** CCHS 2007-2008
IF (dhh_sex = 1 & alwdwky <= 14 & alw_2a1 <=2 & alw_2a2 <=2 & alw_2a3 <=2 & alw_2a4 <=2 & alw_2a5 <=2 & alw_2a6 <=2 & alw_2a7 <=2) LOWRISKDRINK = 1 .
IF (dhh_sex = 2 & alwdwky<= 9 & alw_2a1 <=2 & alw_2a2 <=2 & alw_2a3 <=2 & alw_2a4 <=2 & alw_2a5 <=2 & alw_2a6 <=2 & alw_2a7 <=2) LOWRISKDRINK = 1 .
IF (dhh_sex = 1 & (alwdwky> 14 | alw_2a1 >2 | alw_2a2 >2 | alw_2a3 >2 | alw_2a4 >2 | alw_2a5 >2 |alw_2a6 >2 | alw_2a7 >2)) LOWRISKDRINK = 2.
IF (dhh_sex = 2 & (alwdwky> 9 | alw_2a1 >2 | alw_2a2 >2 | alw_2a3 >2 | alw_2a4 >2 | alw_2a5 >2 |alw_2a6 >2 | alw_2a7 >2)) LOWRISKDRINK = 2 .
EXECUTE.
IF (alwdwky=0) LOWRISKDRINK =1.
IF (alc_1=2) LOWRISKDRINK =1.
EXECUTE.
IF (mam_037 = 9 | mam_037 = 7) LOWRISKDRINK = 9 .
IF (mex_05 = 9) LOWRISKDRINK = 9 .
IF (alwdwky= 999) LOWRISKDRINK = 9 .
IF (mam_037 = 1) LOWRISKDRINK = 3 .
IF (mex_05 = 1) LOWRISKDRINK = 3 .
IF (dhh_age) <19 LOWRISKDRINK = 6.
EXECUTE .
FORMAT LOWRISKDRINK (f1.0).
VARIABLE LABEL LOWRISKDRINK 'Low Risk Drinking Guidelines'.
VALUE LABEL LOWRISKDRINK 1 "Low Risk" 2 "High Risk" 9 "Not Stated" 6 "Not Applicable" 3 "Pregnant or Lactating".
EXECUTE.
* This syntax file replaces a previous low risk drinking syntax file posted on the APHEO website. These are the differences between the two files:
* The old syntax file made an error by coding those people who normally drink but who did not drink in the past week as high risk drinkers.
* Those aged 12-18 are now categorized as 6 = "not applicable", whereas previously they would have been coded the same way as everyone else.
* Women currently pregnant are now categorized as 3 = "Pregnant or Lactating" whereas they were previously categorized as low risk if
* they had 0 drinks in the past week and as high risk if they had any drinks in the past week.
* Women currently breastfeeding are now categorized as 3 = "Pregnant or Lactating" whereas previously they would have been coded the same way as everyone else.