*Update 27 March 2018.
****NEW SCALES**** 

****WATER (W)****.
COMPUTE WATa=MEAN(SD1_Wa,WD1_Wa).
COMPUTE WATb=MEAN(SD1_Wb,WD1_Wb).
EXECUTE.

****SSB (sugar sweetened beverages)****.
COMPUTE SUM_SSBSCHOOLDAYa=SUM(SD2_Ja,SD3_Sa,SD4_Ea).
COMPUTE SUM_SSBWEEKENDDAYa=SUM(WD2_Ja,WD3_Sa,WD4_Ea).
COMPUTE SSBa=MEAN(SUM_SSBSCHOOLDAYa,SUM_SSBWEEKENDDAYa).
EXECUTE.


COMPUTE SUM_SSBSCHOOLDAYb=SUM(SD2_Jb,SD3_Sb,SD4_Eb).
COMPUTE SUM_SSBWEEKENDDAYb=SUM(WD2_Jb,WD3_Sb,WD4_Eb).
COMPUTE SSBb=MEAN(SUM_SSBSCHOOLDAYb,SUM_SSBWEEKENDDAYb).
EXECUTE.

COMPUTE SQRTSSBa=SQRT(SSBa).
COMPUTE SQRTSSBb=SQRT(SSBb).
EXECUTE.

****BEHAVIORAL INTENTION Water en SSB****. 
COMPUTE BI_WATa=MEAN(BI_W1a,BI_W2a,BI_W3a).  
COMPUTE BI_WATb=MEAN(BI_W1b,BI_W2b,BI_W3b).
COMPUTE BI_SSBa=MEAN(BI_SSB1a,BI_SSB2a,BI_SSB3a).
COMPUTE BI_SSBb=MEAN(BI_SSB1b,BI_SSB2b,BI_SSB3b).
EXECUTE.

*_______________****Reliability*****__________________.
RELIABILITY
  /VARIABLES=SD1_Wa WD1_Wa
  /SCALE('Reliability Water Pre') ALL
  /MODEL=SPLIT.

RELIABILITY
  /VARIABLES=SD1_Wb WD1_Wb
  /SCALE('Reliability Water Post') ALL
  /MODEL=SPLIT.

RELIABILITY
  /VARIABLES=SD2_Ja SD3_Sa SD4_Ea WD2_Ja WD3_Sa WD4_Ea
  /SCALE('SSB_pre') ALL
  /MODEL=ALPHA.

RELIABILITY
  /VARIABLES=SD2_Jb SD3_Sb SD4_Eb WD2_Jb WD3_Sb WD4_Eb
  /SCALE('SSB_post') ALL
  /MODEL=ALPHA.

****Reliability BEHAVIORAL INTENTION SCALE PRE & POST--WATER***** .
RELIABILITY
  /VARIABLES=BI_W1a BI_W2a BI_W3a
  /SCALE('BI_W_pre') ALL
  /MODEL=ALPHA.

RELIABILITY
  /VARIABLES=BI_W1b BI_W2b BI_W3b
  /SCALE('BI_W_post') ALL
  /MODEL=ALPHA.

****Reliability INTENTION SCALE PRE & POST--SSB*****.
RELIABILITY
  /VARIABLES=BI_SSB1a BI_SSB2a BI_SSB3a
  /SCALE('BI_SSB_pre') ALL
  /MODEL=ALPHA.

RELIABILITY
  /VARIABLES=BI_SSB1b BI_SSB2b BI_SSB3b
  /SCALE('BI_SSB_post') ALL
  /MODEL=ALPHA.

***_________NORMALITY of DISTRIBUTION___________***.
FREQUENCIES VARIABLES=WATa SSBa BI_WATa BI_SSBa WATb SSBb BI_WATb BI_SSBb
  /STATISTICS=STDDEV VARIANCE RANGE MINIMUM MAXIMUM SEMEAN MEAN MEDIAN 
SKEWNESS SESKEW KURTOSIS 
    SEKURT
  /HISTOGRAM NORMAL
  /ORDER=ANALYSIS.

COMPUTE SQRT_K_BI_WATERa=SQRT(5-BI_WATa).
EXECUTE.
COMPUTE SQRT_K_BI_WATERb=SQRT(5-BI_WATb).
EXECUTE.
COMPUTE SQRTSSBa=SQRT(SSBa).
EXECUTE.
COMPUTE SQRTSSBb=SQRT(SSBb).
EXECUTE.

FREQUENCIES VARIABLES= SQRTSSBa SQRTSSBb SQRT_K_BI_WATERa 
SQRT_K_BI_WATERb
  /STATISTICS=STDDEV VARIANCE RANGE MINIMUM MAXIMUM SEMEAN MEAN MEDIAN 
SKEWNESS SESKEW KURTOSIS 
    SEKURT
  /HISTOGRAM NORMAL
  /ORDER=ANALYSIS.

****RANDOMIZATION CHECK**** 
****AGE****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=DEM2_Age
  /CRITERIA=CI(.95).

****SEX****.
CROSSTABS
  /TABLES=DEM1_Sex BY TRGR
  /FORMAT=AVALUE TABLES
  /STATISTICS=CHISQ 
  /CELLS=COUNT
  /COUNT ROUND CELL.

****THIRST****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=TLa
  /CRITERIA=CI(.95).

****WATER consumption****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=WATa
  /CRITERIA=CI(.95).

****SSB consumption****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=SSBa
  /CRITERIA=CI(.95).
*untransformed variable; to see the raw means.

****INTENTION Water****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=BI_WATa
  /CRITERIA=CI(.95).

****INTENTION SSB****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=BI_SSBa
  /CRITERIA=CI(.95).

****PDNW (perceived descriptive norm water)****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=DNWfriA
  /CRITERIA=CI(.95).

****PINW (perceived injunctive norm water)*****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=INWfriA
  /CRITERIA=CI(.95).

****PDNS (perceived descriptive norm SSB)*****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=DNssbFa
  /CRITERIA=CI(.95).

****PINS (perceived descriptive norm SSB)*****.
T-TEST GROUPS=TRGR(0 1)
  /MISSING=ANALYSIS
  /VARIABLES=INssbFa
  /CRITERIA=CI(.95).

SORT CASES  BY TRGR.
SPLIT FILE SEPARATE BY TRGR.

FREQUENCIES VARIABLES=DEM2_Age TLa WATa SSBa BI_WATa BI_SSBa INWFRIa 
DNWFRIa INssbFa DNssbFa
  /FORMAT=NOTABLE
  /STATISTICS=MINIMUM MAXIMUM MEAN
  /ORDER=ANALYSIS.

SPLIT FILE OFF. 

*****_________________PEARSON'S CORRELATIONS________________*****.
CORRELATIONS
  /VARIABLES=DEM1_sex DEM2_age WATa WATb SQRTSSBa SQRTSSBb BI_WATa BI_WATb 
BI_SSBa BI_SSBb 
DNWfria DNWfrib DNssbFa DNssbFb INWfria INWfrib INssbFa INssbFb TLa TLb 
  /PRINT=TWOTAIL NOSIG
  /MISSING=PAIRWISE.

***STANDARDIZATION of WATa, DNWFRIa, INWFRIa***.
DESCRIPTIVES VARIABLES=WATa, DNWFRIa, INWFRIa
  /STATISTICS=MEAN STDDEV MIN MAX.

compute WATaC = (WATa - 4.5253)/1.90018.
compute DNWFRIaC = (DNWFRIa - 2.70)/0.741.
compute INWFRIaC = (INWFRIa - 2.52)/0.994.
execute.

FREQUENCIES VARIABLES=WATaC, DNWFRIaC, INWFRIaC
  /FORMAT=NOTABLE
  /NTILES=3
  /STATISTICS=STDDEV MEAN
  /ORDER=ANALYSIS.


***********_______________MAIN ANALYSES--Hayes PROCESS 
macro___________________********
*The analyses were performed with PROCESS SPSS Version 2.16.3.
*The "paste button" for syntax creation can not be used.
*The following 'point & click' activities were performed.  

***WATER CONSUMPTION + IN and DN***
Model Number: 2
Bootstrap samples: 1000
Bootstrap CI method: Percentile
Confidence Level: 95%
Covariates in models of both M and Y 
Options: click the first four
Multicatigorical: neither
Y: WATb
X: TRGR
M: INWfriaC
Covariates: WATaC
TLa
TLb
DEM1_Sex
DEM2_Age
W: DNWfriaC.

*A significant interaction effect was found for water consumption and IN; data is 
interpreted further and the interaction is plotted: 
WATER CONSUMPTION + IN
Model Number: 1
Bootstrap samples: 1000
Bootstrap CI method: Percentile
Confidence Level: 95%
Covariates in models of both M and Y 
Options: click the first four
Multicatigorical: X variable coding method indicator
Y: WATb
X: TRGR
M: INWfriaC
Covariates: WATaC
TLa
TLb
DEM1_Sex
DEM2_Age


Data for visualizing conditional effect of X on Y 
Paste text below into a SPSS syntax window and execute to produce plot. 
 
DATA LIST FREE/TRGR INWFRIaC WATb. 
BEGIN DATA. 
 
      .0000     -.9965     4.5243 
     1.0000     -.9965     4.3391 
      .0000      .9965     4.3146 
     1.0000      .9965     4.8053 
 
END DATA. 
GRAPH/SCATTERPLOT=INWFRIaC WITH WATb BY TRGR.

****SSB CONSUMPTION + IN and DN****
Model Number: 2
Bootstrap samples: 1000
Bootstrap CI method: Percentile
Confidence Level: 95%
Covariates in models of both M and Y 
Options: click the first four
Multicatigorical: neither
Y: SQRTSSBb
X: TRGR
M: INssbFa
Covariates: SQRTSSBa
TLa
TLb
DEM1_Sex
DEM2_Age
W: DNssbFa.

****BEHAVIORAL INTENTION WATER + IN and DN****
Model Number: 2
Bootstrap samples: 1000
Bootstrap CI method: Percentile
Confidence Level: 95%
Covariates in models of both M and Y 
Options: click the first four
Multicatigorical: neither
Y: BI_WATb
X: TRGR
M: INWfriaC
Covariates: BI_WATa
TLa
TLb
DEM1_Sex
DEM2_Age
W: DNWfriaC.

****BEHAVIORAL INTENTION SSB + IN and DN****
Model Number: 2
Bootstrap samples: 1000
Bootstrap CI method: Percentile
Confidence Level: 95%
Covariates in models of both M and Y 
Options: click the first four
Multicatigorical: neither
Y: BI_SSBb
X: TRGR
M: INssbFa
Covariates: BI_SSBa
TLa
TLb
DEM1_Sex
DEM2_Age
W: DNssbFa.


***______ADDITIONAL ANALYSES--PEER INFLUENCERS --T-TEST______***. 
USE ALL.
COMPUTE filter_$=(PI = 1).
VARIABLE LABELS filter_$ 'PI = 1 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.

*PAIRED SAMPLES T-TEST. 
T-TEST PAIRS=WATa SQRTSSBa SSBa BI_WATa BI_SSBa WITH WATb SQRTSSBb SSBb 
BI_WATb BI_SSBb (PAIRED)
  /CRITERIA=CI(.9500)
  /MISSING=ANALYSIS.

FILTER OFF.
USE ALL.
EXECUTE.

***_____ UNITS and/or SCORES____***.
SORT CASES  BY TRGR.
SPLIT FILE SEPARATE BY TRGR.

FREQUENCIES VARIABLES= WATb  SSBb BI_WATb BI_SSBb
   /FORMAT=NOTABLE 
   /STATISTICS=STDDEV MINIMUM MAXIMUM MEAN
  /ORDER=ANALYSIS.

SPLIT FILE OFF.

***_____________Paper-Abstract data_________***.
FREQUENCIES VARIABLES=TRGR DEM1_Sex DEM2_Age
  /STATISTICS=STDDEV MINIMUM MAXIMUM MEAN
  /ORDER=ANALYSIS.

*To describe the figures for the interaction effect found for water consumption and PINW, 
the analysis was rerun with water consumption
at pre-intervention as the dependent variable. 
*WATER CONSUMPTION + IN
Model Number: 1
Bootstrap samples: 1000
Bootstrap CI method: Percentile
Confidence Level: 95%
Covariates in models of both M and Y 
Options: click the first four
Multicatigorical: X variable coding method indicator
Y: WATa
X: TRGR
M: INWfriaC
Covariates: 
TLa
TLb
DEM1_Sex
DEM2_Age

-------END-------