* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
*  Title: Create a derived variable for sedentary activities in CCHS 2003 (Cycle 2.1)
* Variable name: SACDTER-Total number of hours per week spent in sedentary activities (excluding reading)
* Based on : SAC_1, SAC_2, SAC_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: 
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 

*1. Recode SACC_1, SACC_2 and SACC_3 to midpoint of response ranges-Temporay reformats

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


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

IF (SACC_3=1) SACCT3=0.
IF (SACC_3=2) SACCT3=0.5.
IF (SACC_3=3) SACCT3=1.5.
IF (SACC_3=4) SACCT3=4.
IF (SACC_3=5) SACCT3=8.
IF (SACC_3=6) SACCT3=12.5.
IF (SACC_3=7) SACCT3=17.5.
IF (SACC_3=8) SACCT3=20.
EXECUTE.

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

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

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

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

IF  (SACC_1=97 | SACC_1=98 | SACC_1=99 | SACC_2=97 | SACC_2=98 | SACC_2=99  | SACC_3=97 | SACC_3=98 | SACC_3=99) SAC=99.
EXECUTE.

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

IF  (SACCT1 >= 0 &  SACCT1 <= 20 & SACCT2 >= 0 & SACCT2 <= 20 &  SACCT3 >= 0 & SACCT3 <= 20) 
    SAC=SACCT1 + SACCT2+SACCT3.
EXECUTE.


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

IF  (SACCT1 >= 0 & SACCT1 <= 20 & SACC_2 = 96 & SACCT3 >= 0 & SACCT3 <= 20) 
    SAC=SACCT1 + SACCT3.
EXECUTE.


* 3. Use total from SAC to assign value to categorical variable SACDTER

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'.