* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
*  Title: Create a derived variable for sedentary activities in CCHS 2001 (Cycle 1.1)
* Variable name: SACDTER-Total number of hours per week spent in sedentary activities (excluding reading)
* Based on : SACA_1, SACA_2, SACA_3 
* Definition: This variable estimates the total number of hours the respondent spent in a typical week in the past three months in sedentary
                    *activities including using a computer (including playing computer games), using the Internet, playing video games and 
                     *watching television or videos. For all activities, the time spent at school or work is excluded. Time spent in reading is not included.

*  Authors: Fangli Xie
*  Creation Date: June 14 2011
*  Revision Date: 
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 

*Recode SACA_1, SACA_2 and SACA_3 to midpoint of response ranges-Temporay reformats

IF (SACA_1=1) SACAT1=0.
IF (SACA_1=2) SACAT1=0.5.
IF (SACA_1=3) SACAT1=1.5.
IF (SACA_1=4) SACAT1=4.
IF (SACA_1=5) SACAT1=8.
IF (SACA_1=6) SACAT1=12.5.
IF (SACA_1=7) SACAT1=17.5.
IF (SACA_1=8) SACAT1=20.


IF (SACA_2=1) SACAT2=0.
IF (SACA_2=2) SACAT2=0.5.
IF (SACA_2=3) SACAT2=1.5.
IF (SACA_2=4) SACAT2=4.
IF (SACA_2=5) SACAT2=8.
IF (SACA_2=6) SACAT2=12.5.
IF (SACA_2=7) SACAT2=17.5.
IF (SACA_2=8) SACAT2=20.

IF (SACA_3=1) SACAT3=0.
IF (SACA_3=2) SACAT3=0.5.
IF (SACA_3=3) SACAT3=1.5.
IF (SACA_3=4) SACAT3=4.
IF (SACA_3=5) SACAT3=8.
IF (SACA_3=6) SACAT3=12.5.
IF (SACA_3=7) SACAT3=17.5.
IF (SACA_3=8) SACAT3=20.


* Number of hours per week spent in sedentary activities excluding reading-Temporay continious variable

   * Code don’t know, refusal, not stated and not applicable 

IF  (SACAFOPT=2) SAC=96.
EXECUTE.

IF  (ADMA_PRX=1) SAC=99.
EXECUTE.

IF  (SACA_1=97 | SACA_1=98 | SACA_1=99 | SACA_2=97 | SACA_2=98 | SACA_2=99  | SACA_3=97 | SACA_3=98 | SACA_3=99) SAC=99.
EXECUTE.

    * Total number of hours spent in sedentary activities where the respondent is aged < 20

IF  (SACAT1 >= 0 &  SACAT1 <= 20 & SACAT2 >= 0 & SACAT2 <= 20 &  SACAT3 >= 0 & SACAT3 <= 20) 
    SAC=SACAT1 + SACAT2+SACAT3.
EXECUTE.



  * Total number of hours spent in sedentary activities where respondent is aged >=20

IF  (SACAT1 >= 0 & SACAT1 <= 20 & SACA_2 = 96 & SACAT3 >= 0 & SACAT3 <= 20) 
    SAC=SACAT1 + SACAT3.
EXECUTE.


* Use total from SAC to assign value to categorical variable SACTOT

IF (SAC=96) SACDTER=96.
IF (SAC=99) SACDTER=99.
IF (0 <= SAC & SAC< 5) SACDTER=1.
IF (5 <= SAC & SAC< 10) SACDTER=2.
IF (10 <= SAC & SAC< 15) SACDTER=3.
IF (15 <= SAC & SAC< 20) SACDTER=4.
IF (20 <= SAC & SAC< 25) SACDTER=5.
IF (25 <= SAC & SAC< 30) SACDTER=6.
IF (30 <= SAC & SAC< 35) SACDTER=7.
IF (35 <= SAC & SAC< 40) SACDTER=8.
IF (40 <= SAC & SAC< 45) SACDTER=9.
IF (45 <= SAC & SAC< 96) SACDTER=10.

* Variable label

VARIABLE LABELS SACDTER  ' Total number of hours spending on sedentary activity excluding reading'.
 VALUE LABELS SACDTER
 1 '<5 hours'
 2  '5 - 9 hours'
 3 '10 -14 hours'
 4 '15 -19 hours'
 5 '20- 24 hours'
 6 '25 - 29 hours'
 7 '30 - 34 hours'
 8 '35 - 39 hours'
 9 '40 - 44 hours'
 10 '45 hours or more'
 96 'Not applicable'
 99 'Not stated'.