******************************************************************************************************************************
* 1. Meets/Exceeds Guideline 1
* Please note: in this calculation, the analysis excludes anyone with any missing data on the
* parameters used to collect compliance: days drinking, number of drinks per week, etc. *Guideline 1: To reduce long-term health risks (chronic disease)
*Males: 0 - 3 standard* drinks per day AND No more than 15 standard *drinks per week
*Females: 0 - 2 standard*drinks per day AND No more than 10 standard* drinks per week, AND
* For both sex: Always have some non-drinking days per week to minimize tolerance and habit formation
******************************************************************************************************************************
*1.1 Those who exceed Guideline 1
********************************************
*Number of days of the week respondents drank
RECODE alw_2a1 (0=0) (996=0) (1 thru 99=1) (997 thru Highest=sysmis) INTO Sunday .
RECODE alw_2a2 (0=0) (996=0) (1 thru 99=1) (997 thru Highest=sysmis) INTO Monday .
RECODE alw_2a3 (0=0) (996=0) (1 thru 99=1) (997 thru Highest=sysmis) INTO Tuesday .
RECODE alw_2a4 (0=0) (996=0) (1 thru 99=1) (997 thru Highest=sysmis) INTO Wednesday .
RECODE alw_2a5 (0=0) (996=0)(1 thru 99=1) (997 thru Highest=sysmis) INTO Thursday .
RECODE alw_2a6 (0=0) (996=0) (1 thru 99=1) (997 thru Highest=sysmis) INTO Friday .
RECODE alw_2a7 (0=0) (996=0) (1 thru 99=1) (997 thru Highest=sysmis) INTO Saturday .
EXECUTE .
COMPUTE drinkingdays=Sunday+Monday+Tuesday+Wednesday+Thursday+Friday+Saturday .
EXECUTE . IF (dhh_sex = 1 & ( (alwdwky > 15 & alwdwky <996) | (alw_2a1 >3 & alw_2a1<996) | (alw_2a2 >3 & alw_2a2<996)
| (alw_2a3 >3 & alw_2a3<996) | (alw_2a4 >3 & alw_2a4<996) | (alw_2a5 >3 & alw_2a5<996) | (alw_2a6 >3 & alw_2a6<996)
| (alw_2a7 >3 & alw_2a7<996) | drinkingdays >5 )) Guideline1=2.
IF (dhh_sex = 2 & ( (alwdwky > 10 & alwdwky <996) | (alw_2a1 >2 & alw_2a1<996) | (alw_2a2 >2 & alw_2a2<996)
| (alw_2a3 >2 & alw_2a3<996) | (alw_2a4 >2 & alw_2a4<996) | (alw_2a5 >2 & alw_2a5<996) | (alw_2a6 >2 & alw_2a6<996)
| (alw_2a7 >2 & alw_2a7<996) | drinkingdays >5 )) Guideline1=2.
EXECUTE . *1.2 Those in compliance with Guideline 1
*************************************************** IF (dhh_sex = 1 & alwdwky <= 15 & alw_2a1 <=3 & alw_2a2 <=3 & alw_2a3 <=3 & alw_2a4 <=3 & alw_2a5 <=3 & alw_2a6 <=3
& alw_2a7 <=3 & drinkingdays<=5 ) Guideline1 = 1.
IF (dhh_sex = 2 & alwdwky <= 10 & alw_2a1 <=2 & alw_2a2 <=2 & alw_2a3 <=2 & alw_2a4 <=2 & alw_2a5 <=2 & alw_2a6 <=2
& alw_2a7 <=2 & drinkingdays<=5) Guideline1= 1 .
IF (alc_1=2 | alw_1=2) Guideline1 =1 .
EXECUTE . ******Exclusions*****
*Those under 19 years of age- NA
*Those pregnant or breastfeeding -NA
*Those who answered DK/Ref/Not Stated for alc_1-Don't know, not stated,
*Those who do not have a weekly total-Don't know, not stated, IF (dhh_age<19 ) Guideline1 = 98 .
IF (mam_037 = 1 | mex_05 = 1 ) Guideline1 = 98 .
IF ((mam_037 >= 7 & mam_037<=9) | (mex_05>=7 &mex_05<=9 )) Guideline1 = 99 .
IF ((alc_1 >= 7 & alc_1 <=9) | alwdwky = 999) Guideline1 = 99 .
EXECUTE .
FORMATS Guideline1 (f1.0) .
VARIABLE LABELS Guideline1 '2011 Canadian LRADG Guideline 1' .
VALUE LABELS Guideline1
1 "Complies"
2 "Exceeds"
98 "Not Applicable"
99 "Not Stated, Dont Know or Refusal" .
EXECUTE .
************************************************************************************************************
* 2. Meets/Exceeds Guideline 2
* Please note: in this calculation, the analysis excludes anyone with any missing data on the
* parameters used to collect compliance: days drinking, number of drinks per week, etc.
* Guideline 2: Maximum special occasion alcohol consumption to reduce short-term risks
*(injury or acute effects associated with excess alcohol consumption)
*Males: 4 standard* drinks in one day in any 3 hour period
* Females: 3 standard* drinks in one day in any 3 hour period * Guideline 2 is accessed by frequency of having 5 or more drinks on one occasion for both sex
* Complies: Never; Exceeds: at least once
************************************************************************************************************
IF (alc_3=1 | alc_1=2 ) Guideline2=1.
IF (alc_3>=2 & alc_3<=6) Guideline2=2.
IF (dhh_age<19 ) Guideline2 = 98 .
IF (mam_037 = 1 | mex_05 = 1 ) Guideline2 = 98.
IF ((mam_037 >= 7 & mam_037<=9) | (mex_05>=7 &mex_05<=9 )) Guideline2 = 99 .
IF (alc_3 >=97 & alc_3 <=99 ) Guideline2 = 99 .
EXECUTE .
FORMATS Guideline2 (f1.0) .
VARIABLE LABELS Guideline2 '2011 Canadian LRADG Guideline 2' .
VALUE LABELS Guideline2
1 "Complies"
2 "Exceeds"
98 "Not Applicable"
99 "Not Stated, Dont Know or Refusal" .
EXECUTE .
********************************************************************************************************
* 3. Meets both Guideline 1 and 2 OR Exceeds Guideline 1 or 2- Method 1
********************************************************************************************************
* Number of drinking days in the past week (drinkingdays) created in Guideline 1 *Create Guidelineboth variable IF (dhh_sex = 1 & ( (alwdwky > 15 & alwdwky <996) | (alw_2a1 >3 & alw_2a1<996) | (alw_2a2 >3 & alw_2a2<996)
| (alw_2a3 >3 & alw_2a3<996) | (alw_2a4 >3 & alw_2a4<996) | (alw_2a5 >3 & alw_2a5<996) | (alw_2a6 >3 & alw_2a6<996)
| (alw_2a7 >3 & alw_2a7<996) | drinkingdays >5 | (alc_3>=2 & alc_3<=6))) Guidelineboth=2.
IF (dhh_sex = 2 & ( (alwdwky > 10 & alwdwky <996) | (alw_2a1 >2 & alw_2a1<996) | (alw_2a2 >2 & alw_2a2<996)
| (alw_2a3 >2 & alw_2a3<996) | (alw_2a4 >2 & alw_2a4<996) | (alw_2a5 >2 & alw_2a5<996) | (alw_2a6 >2 & alw_2a6<996)
| (alw_2a7 >2 & alw_2a7<996) | drinkingdays >5 | (alc_3>=2 & alc_3<=6))) Guidelineboth=2.
EXECUTE .
IF (dhh_sex = 1 & alwdwky <= 15 & alw_2a1 <=3 & alw_2a2 <=3 & alw_2a3 <=3 & alw_2a4 <=3 & alw_2a5 <=3 & alw_2a6 <=3
& alw_2a7 <=3 & drinkingdays<=5 & alc_3=1 ) Guidelineboth = 1.
IF (dhh_sex = 2 & alwdwky <= 10 & alw_2a1 <=2 & alw_2a2 <=2 & alw_2a3 <=2 & alw_2a4 <=2 & alw_2a5 <=2 & alw_2a6 <=2
& alw_2a7 <=2 & drinkingdays<= 5 & alc_3=1) Guidelineboth= 1 .
IF (alc_1=2 | (alw_1=2 & alc_3=1)) Guidelineboth =1 .
EXECUTE .
IF (dhh_age<19 ) Guidelineboth = 98 .
IF (mam_037 = 1 | mex_05 = 1 ) Guidelineboth = 98.
IF ((mam_037 >= 7 & mam_037<=9) | (mex_05>=7 &mex_05<=9) | alwdwky=999 ) Guidelineboth = 99 .
IF ((alc_1 >=7 & alc_1 <=9) | ( alw_1>=7 &alw_1<=9 ) | ( alc_3>=97 & alc_3<=99 ) ) Guidelineboth = 99 .
EXECUTE .
FORMATS Guidelineboth (f1.0) .
VARIABLE LABELS Guidelineboth '2011 Canadian LRADG Guideline 1 and 2' .
VALUE LABELS Guidelineboth
1 "Complies"
2 "Exceeds"
98 "Not Applicable"
99 "Not Stated, Dont Know or Refusal"
EXECUTE .
********************************************************
********************************************************
**** 4. Run frequency (weighted rates)
*********************************************************
********************************************************
* For those wishing to include 98 "Not Applicable" 99 "Not Stated, Don't Know or Refusal" FILTER OFF.
USE ALL.
EXECUTE. WEIGHT BY WTS_S.
FREQUENCIES VARIABLES=Guideline1 Guideline2 Guidelineboth
/ORDER=ANALYSIS. * For those wishing to exclude 98 "Not Applicable" 99 "Not Stated, Don't Know or Refusal" MISSING VALUES Guideline1(98,99).
MISSING VALUES Guideline2(98,99).
MISSING VALUES Guidelineboth(98,99).
FILTER OFF.
USE ALL.
EXECUTE.
WEIGHT BY WTS_S. FREQUENCIES VARIABLES=Guideline1 Guideline2 Guidelineboth
/ORDER=ANALYSIS. | 
