!!! ALPHA environmental Questionnaire !!!

!!! Step 1. Checking typos and missing values !!!

FREQUENCIES
  VARIABLES=alpha_1a alpha_1b alpha_1c alpha_2a alpha_2b alpha_2c alpha_2d alpha_2e
  alpha_2f alpha_2g alpha_2h alpha_3a alpha_3b alpha_3c alpha_3d alpha_4a alpha_4b
  alpha_4c alpha_5a alpha_5b alpha_5c alpha_5d alpha_5e alpha_5f alpha_6a alpha_6b
  alpha_6c alpha_6d alpha_7a alpha_7b alpha_7c alpha_7d alpha_8a alpha_8b alpha_8c
  alpha_8d alpha_8e alpha_8f alpha_9Aa alpha_9Ab alpha_9Ac alpha_9Ba alpha_9Bb
  alpha_9Bc alpha_9Bd alpha_9Be alpha_9Bf alpha_9Bg alpha_9Bh alpha_9Bi alpha_9Bj
  /ORDER=  ANALYSIS .

!!! If needed: input missing values !!!


!!! Step 2. Recode negative items !!!

RECODE
  alpha_5a
  (1=4)  (2=3)  (3=2)  (4=1) (ELSE=Copy)  INTO  alpha_r5a .
RECODE
  alpha_5b
  (1=4)  (2=3)  (3=2)  (4=1) (ELSE=Copy)  INTO  alpha_r5b .
RECODE
  alpha_5c
  (1=4)  (2=3)  (3=2) (4=1)  (ELSE=Copy)  INTO  alpha_r5c .
RECODE
  alpha_5d
  (1=4)  (2=3)  (3=2) (4=1) (ELSE=Copy)  INTO  alpha_r5d .
RECODE
  alpha_5e
  (1=4)  (2=3)  (3=2) (4=1) (ELSE=Copy)  INTO  alpha_r5e .
RECODE
  alpha_5f
  (1=4)  (2=3)  (3=2) (4=1) (ELSE=Copy)  INTO  alpha_r5f .
EXECUTE .


RECODE
  alpha_6b
  (1=4)  (2=3)  (3=2) (4=1) (ELSE=Copy)  INTO  alpha_r6b.
RECODE
  alpha_6d
  (1=4)  (2=3)  (3=2) (4=1) (ELSE=Copy)  INTO  alpha_r6d.
EXECUTE .

RECODE
  alpha_8e
  (0=1)  (1=0)  (ELSE=Copy)  INTO  alpha_r8e.
EXECUTE .


RECODE
  alpha_9Ba
  (0=1)  (1=0)  (ELSE=Copy)  INTO  alpha_r9Ba.
RECODE
  alpha_9Bf
  (0=1)  (1=0)  (ELSE=Copy)  INTO  alpha_r9Bf.
EXECUTE .

!!! Step 3: check answercategories not applicable theme 4 !!!

!!! Sept 4 Summations !!!

COMPUTE densityscore = alpha_1a  + (alpha_1b * 12) + (alpha_1c * 50) .
EXECUTE .

COMPUTE distancescore = alpha_2a + alpha_2b + alpha_2c + alpha_2d + alpha_2e +
  alpha_2f + alpha_2g + alpha_2h .
EXECUTE .


COMPUTE avail_sidew = alpha_3a + alpha_3b .
EXECUTE .

COMPUTE avail_bikelanes = alpha_3c + alpha_3d .
EXECUTE .

COMPUTE avail_infrastr = alpha_3a + alpha_3b + alpha_3c + alpha_3d .
EXECUTE .



COMPUTE Maintenance = alpha_4a + alpha_4b + alpha_4c .
EXECUTE .



COMPUTE Total_safety = alpha_r5a + alpha_r5b + alpha_r5c + alpha_r5d + alpha_r5e +
  alpha_r5f .
EXECUTE .

COMPUTE Safety_crime = alpha_r5a + alpha_r5e + alpha_r5f .
EXECUTE .

COMPUTE Safety_traffic = alpha_r5b + alpha_r5c + alpha_r5d .
EXECUTE .




COMPUTE Pleasure = alpha_6a+ alpha_r6b + alpha_6c + alpha_r6d .
EXECUTE .

COMPUTE Aesthetics = alpha_r6b + alpha_6c + alpha_r6d .
EXECUTE .



COMPUTE Network = alpha_7a + alpha_7b + alpha_7c + alpha_7d.
EXECUTE .

COMPUTE Connectivity = alpha_7a + alpha_7c + alpha_7d.
EXECUTE .
.



COMPUTE Home = alpha_8a + alpha_8b + alpha_8c + alpha_8d + alpha_r8e + alpha_8f.
EXECUTE .

COMPUTE Work_study = alpha_r9Ba + alpha_9Bb +alpha_9Bc + alpha_9Bd + alpha_9Be + alpha_r9Bf + alpha_9Bg +alpha_9Bh +alpha_9Bi + alpha_9Bj.
EXECUTE .