*major recode.

*STEP 1 -- fix out of range bad data.  
recode v1 to v25 v45 v50 v51 v52 v54 v56 (0, 6 thru 8=9)(else=copy)/
v26 (42 thru 89=99)(else=copy) /
v27 (11 thru 90=99)(else=copy) /
v28 (40 thru 91=9)(else=copy) /
v29 (0, 23 thru 90=9)(else=copy) /
v30 (90=99)(else=copy) /
v31 (22 thru 71=9)(else=copy) /
v33 (40 thru 94=9)(else=copy) /
v34 (0=99)(else=copy)/
v35 (79 thru 98=9)(else=copy) /
v36 (25 thru 92=9)(else=copy) /
v37 (31 thru 97=9)(else=copy) /
v38 to v44 (0,8=9)(else=copy)/
v46 (0,4=9)(else=copy)/
v47 (3,4,5=9)(else=copy)/
v55 (0 thru 12, 80, 91=99)(else=copy)/
v57 (9.31=9.99)(else=copy).
execute.

*NOTE:  v32  and some others  need no recode. 
********  and the above syntax did as intended.  

*STEP 2 -- collapse interval/ratio and rate questions.  
recode v26 (1 thru 10=1)(11 thru 20=2)(21 thru 40=3)(else=copy) into hrswrk/
v27 (0=1)(3,4=2)(5 thru 11=3)(else=copy) into hrstdy/
v28 (2=1)(3,4,5=2)(6 thru 9=3)(10 thru 31=4)(else=copy) into drinks/
v29 (1 thru 12=1)(13,14,15=2)(16 thru 21=3)(else=copy) into credit/
v30 (2 thru 5=1)(6 thru 10=2)(11 thru 70=3)(else=copy) into watchtv/
v31 (2,3=1)(4 thru 71=2)(else=copy) into complabs/
v32 (0=999)(1 thru 200=1)(201 thru 400=2)(401 thru 990=3)(else=copy) into books/
v33 (2,3=1)(4 thru 9=2)(10 thru 39=3)(else=copy) into nitesdrk/
v34 (1 thru 10=1)(11 thru 15=2)(17 thru 90=3)(else=copy) into minutes/
v35 (0=99)(1 thru 10=1)(11 thru 20=2)(21 thru 70=3)(else=copy) into email/
v36 (1 thru 5=1)(6 thru 20=2)(else=copy) into athevent/
v37 (1 thru 5=1)(6 thru 15=2)(16 thru 30=3)(else=copy) into rec_cntr/
v38 (2,3=1)(5,6=7)(else=copy) into rateduc/
v39 (2,3=1)(5,6=7)(else=copy) into ratewar/
v40 (2,3=1)(5,6=7)(else=copy) into ratebus/
v41 (2,3=1)(5,6=7)(else=copy) into ratesafe/
v42 (2,3=1)(5,6=7)(else=copy) into rateprog /
v43 (2,3=1)(5,6=7)(else=copy) into ratepark/
v44 (2,3=1)(5,6=7)(else=copy) into ratefind/
v55 (18,19,20=1)(21 thru 62=2)(99=9)(else=copy) into age /
v57 (0 thru 2.50=1)(2.51 thru 3.25=2)(3.26 thru 3.75=3)(3.76 thru 4.00=4)(9.99=9)(else=copy) into gpa .
execute.

variable labels 
hrswrk new collapsed hours worked 
hrstdy new collapsed hours study
drinks new collapsed drinks for night out
credit new collapsed credit hours taking
watchtv new collapsed hours of TV per week
complabs visit computer labs per week
books money spent on books
nitesdrk new collapsed nights out drinking in a month 
minutes time spent getting to class
email times checking email per week
athevent athletic events per semester
rec_cntr visits to the rec center per month
rateduc rate education
ratewar rate war on terror
ratebus rate promptness of buses
ratesafe rate safety on campus 
rateprog rate your program
ratepark rate WMU parking situation
ratefind rate difficulty finding classes
age new collapsed age
gpa  new collapsed gpa. 
execute.

value labels
hrswrk
0 none
1 1 thru 10
2 11 thru 20
3 21 thru 40/
hrstdy 
1 one
2 2, 3 or 4
3 5 to 11 / 
drinks
 0 zero
 1 1 or 2 
 2 3 to 5  
 3 6 thru 9  
 4 10 thru 31/
credit 
  1 6 to 12               
 2 13,14,15  
 3 16 thru 21/
watchtv 
0 zero
1 2 thru 5    
2 6 thru 10     
3 11 thru 70 /
complabs 
1 1, 2 or 3
2 4 thru 71/
books 
1 1 thru 200
2 201 thru 400
3 401 thru 990/
nitesdrk 
0 none
1 2 or 3
2 4 thru 9
3 10 thru 39/
minutes
1  1 thru 10
2 11 thru 15
3 17 thru 90/
email 
1 1 thru 10
2 11 thru 20
3 21 thru 70/
athevent 
0 none
1 1 thru 5
2 6 thru 20/
rec_cntr 
0 none
1  1 thru 5
2  6 thru 15
3  16 thru 30/
rateduc ratewar ratebus rateprog  ratepark 
  1 poor
  7 excellent /
ratesafe 
 1 not at all safe
 7 completely safe / 
ratefind 
 1 easy 
 7 hard /
age  
1 18,19,20 
2 21 thru 62 /
gpa    
1 0 thru 2.50
2 2.51 thru 3.25
3 3.26 thru 3.75
4 3.76 thru 4.00.
execute. 

*formats and missing are working as expected.  
formats hrswrk hrstdy drinks credit watchtv complabs books nitesdrk
  minutes email athevent rec_cntr rateduc ratewar ratebus ratesafe rateprog
  ratepark ratefind age gpa (F1.0).

missing values
hrswrk hrstdy drinks credit watchtv complabs nitesdrk
  minutes email athevent rec_cntr (99)/ rateduc ratewar ratebus ratesafe rateprog
  ratepark ratefind age gpa (9)/ books (999).
execute.