Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • STATA code on counting the number of hours poor people spend on each activity

    Hi everyone,

    I have 24 variables representing 24 hours and 7 categories household spend their time in. The categories are as follows:

    1 = Unskilled Employment
    2 = Skilled Employment
    3 = Caregiving // Household Chores
    4 = Social Integration
    5 = Personal Care
    6 = Leisure
    7 = Other

    Households were asked to describe a typical day of their lives on a hour-by-hour basis and their responses were clubbed into 7 aforementioned categories. I'd like to know how much time households spent on each activity but have no clue how to go about this? Would really appreciate if someone can provide me a STATA code for that.

    My data is in wide format at the moment and i'd like to have 7 variables (one for each category) representing hours spent on each category for every household.

    Thanks.



    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input long idno byte(treatment qn6_9_1 qn6_9_2 qn6_9_3 qn6_9_4 qn6_9_5 qn6_9_6 qn6_9_7 qn6_9_8 qn6_9_9 qn6_9_10 qn6_9_11 qn6_9_12 qn6_9_13 qn6_9_14 qn6_9_15 qn6_9_16 qn6_9_17 qn6_9_18 qn6_9_19 qn6_9_20 qn6_9_21 qn6_9_22 qn6_9_23 qn6_9_24)
      2 2 5 5 5 1 1 1 1 1 1 1 6 6 6 6 5 5 6 6 5 5 5 5 5 5
     20 1 5 5 3 1 1 1 1 1 3 1 5 1 1 1 1 3 3 5 5 5 5 5 5 5
     25 1 5 5 1 1 1 1 1 1 3 3 5 3 6 6 6 6 6 5 5 5 5 5 5 5
     26 1 5 5 5 1 1 1 1 1 1 3 3 5 . . . . . 5 5 5 5 5 5 5
     30 1 5 5 5 5 1 1 1 1 3 5 6 6 6 6 6 6 5 5 5 5 5 5 5 5
     31 1 5 5 5 1 1 1 5 1 1 1 5 1 1 1 1 1 4 5 5 5 5 5 5 5
     35 2 5 5 5 5 1 1 1 1 1 1 1 5 6 . 1 1 1 5 5 . 5 5 5 5
     37 1 5 5 5 4 4 4 4 4 4 5 4 4 4 4 6 6 5 5 5 5 5 5 5 5
     39 1 5 5 5 5 1 1 1 1 6 6 5 1 1 6 6 5 5 5 5 5 5 5 5 5
     40 1 5 5 5 5 1 1 1 1 1 4 5 5 5 5 6 6 5 5 5 5 5 5 5 5
     50 1 5 5 6 5 4 1 1 1 1 5 6 1 1 1 1 5 6 5 5 . 5 5 5 5
     57 1 5 5 1 5 1 1 1 1 1 1 3 5 1 1 6 6 6 5 5 5 5 5 5 5
     64 2 5 6 5 5 4 1 1 1 1 5 6 6 6 6 3 5 6 5 5 5 5 5 5 5
     65 1 5 5 5 4 1 1 1 3 3 5 3 6 3 6 6 5 5 5 5 5 5 5 5 5
     70 1 5 5 1 1 1 1 1 1 1 1 5 1 1 3 5 6 6 6 5 5 5 5 5 5
     83 1 5 5 5 1 1 1 3 3 6 5 3 6 6 6 3 6 5 5 5 5 5 5 5 5
     85 2 5 5 5 4 1 1 1 1 4 6 5 4 6 6 5 6 6 5 5 5 5 5 5 5
     93 2 5 5 5 5 1 1 1 1 1 1 5 5 6 6 6 5 5 5 5 5 5 5 5 5
     94 2 5 5 5 1 1 1 1 1 1 1 5 1 1 1 1 5 5 5 5 5 5 5 5 5
    101 2 5 5 3 1 1 1 1 1 5 5 6 5 5 5 3 3 6 5 5 5 5 5 5 5
    105 1 5 5 5 3 3 3 3 6 6 6 3 3 6 6 3 3 3 5 5 5 5 5 5 5
    107 1 5 3 3 1 1 1 1 1 1 6 6 6 6 1 . 6 6 5 5 5 5 5 5 5
    108 1 5 5 3 1 1 1 1 1 1 3 . 1 1 1 1 3 5 5 5 5 5 5 5 5
    110 1 5 5 5 6 1 1 3 3 3 5 1 6 3 3 3 5 5 5 5 5 5 5 5 5
    115 1 5 3 3 1 1 1 1 1 1 3 3 6 1 1 3 3 3 5 5 5 5 5 5 5
    119 1 5 5 5 3 1 1 6 3 5 3 6 1 1 6 6 5 5 5 5 5 5 5 5 5
    122 1 5 5 3 1 1 1 1 1 3 3 5 3 1 1 1 5 3 5 5 5 5 5 5 5
    126 1 5 5 5 1 1 1 1 1 1 3 1 1 1 1 6 6 6 . 5 5 5 5 5 5
    130 1 5 5 1 1 1 1 1 1 1 5 5 6 1 1 6 6 6 5 5 5 5 5 5 5
    131 2 5 5 3 5 3 3 3 3 5 6 6 6 3 3 6 5 5 5 5 5 5 5 5 5
    133 1 5 1 1 1 1 1 6 6 6 6 6 6 1 1 6 . 6 3 5 5 5 5 5 5
    134 1 5 5 3 1 1 1 1 6 3 5 1 1 3 5 3 5 5 5 5 5 5 5 5 5
    162 2 5 5 5 5 1 1 1 1 1 1 3 3 3 5 6 6 5 5 5 5 5 5 5 5
    176 0 5 5 5 5 1 1 4 3 3 3 5 6 4 3 5 5 6 5 5 5 5 5 5 5
    187 0 5 5 5 5 1 1 1 1 1 4 5 4 1 1 1 1 5 5 5 5 5 5 5 5
    188 0 5 5 5 5 4 1 1 1 1 3 3 5 3 3 6 6 5 5 5 5 5 5 5 5
    189 0 5 5 4 1 1 1 5 . 4 6 1 1 3 3 3 5 . 5 5 5 5 5 5 5
    193 0 5 5 4 1 1 1 1 4 3 3 3 5 5 6 6 6 5 5 5 5 5 5 5 5
    195 0 5 5 5 1 1 1 1 1 1 5 1 1 1 1 5 6 6 5 5 5 5 5 5 5
    212 0 5 5 5 1 1 1 5 3 3 6 6 5 6 3 3 5 5 5 5 5 5 5 5 5
    214 2 5 5 5 3 5 1 1 1 1 1 1 5 5 6 6 6 5 5 5 5 5 5 5 5
    220 0 5 5 5 5 5 1 1 4 3 3 5 6 3 3 3 5 5 5 5 5 5 5 5 5
    221 0 5 5 5 5 6 6 6 6 4 . 5 4 4 4 5 1 3 5 5 5 5 5 5 5
    222 0 5 5 5 3 4 1 1 1 1 1 5 5 6 6 6 3 4 5 5 5 5 5 5 5
    223 2 5 5 . 1 1 1 1 1 1 5 5 6 6 4 6 5 5 5 5 5 5 5 5 5
    224 0 5 5 5 5 4 1 1 1 1 4 5 6 1 3 5 3 5 5 5 5 5 5 5 5
    225 0 5 5 3 1 1 1 1 1 3 3 5 6 5 4 3 3 5 5 5 5 5 5 5 5
    228 0 . 5 5 4 4 4 5 4 4 5 4 4 4 5 6 6 5 5 5 5 5 5 5 5
    229 2 5 5 5 4 1 1 1 1 1 5 1 1 1 1 1 1 4 5 5 5 5 5 5 5
    237 1 5 5 5 3 4 1 1 1 4 3 5 6 1 1 5 1 1 1 1 5 5 5 5 5
    245 1 5 5 5 3 1 1 1 1 5 3 5 6 1 1 1 5 4 5 5 5 5 5 5 5
    250 1 5 5 5 3 1 1 1 1 1 1 1 5 5 6 6 6 6 6 5 5 5 5 5 5
    255 1 5 5 5 5 5 1 1 1 1 1 5 1 1 1 5 6 6 5 5 5 5 5 5 5
    259 1 5 5 5 3 4 1 1 1 1 5 6 1 1 4 5 6 6 5 5 5 5 5 5 5
    262 1 5 5 5 1 1 1 1 3 5 1 1 1 3 5 6 6 5 5 5 5 5 5 5 5
    265 1 5 5 5 4 1 1 5 1 1 1 1 5 1 1 1 5 6 6 5 5 5 5 5 5
    266 1 5 5 5 5 1 1 1 1 6 3 5 1 1 5 4 4 6 5 5 5 5 5 5 5
    268 0 5 5 5 5 5 6 3 3 6 6 6 6 6 6 6 6 6 5 5 5 5 5 5 5
    271 2 5 5 5 3 5 3 3 5 5 3 5 6 6 6 3 5 6 5 5 5 5 5 5 5
    281 1 5 5 1 1 1 3 5 3 3 3 3 5 6 6 6 5 5 5 5 5 5 5 5 5
    284 1 5 5 5 4 4 4 5 4 4 5 4 4 4 6 5 6 6 5 5 5 5 5 5 5
    286 1 5 5 5 5 3 3 5 1 1 3 3 5 6 6 6 6 5 5 5 5 5 5 5 5
    288 1 5 5 5 5 4 1 1 1 1 5 1 1 1 4 5 5 5 5 5 5 5 5 5 5
    289 1 5 5 5 5 4 4 4 5 4 5 4 4 4 . 3 5 5 5 5 5 5 5 5 5
    297 1 5 5 5 4 1 1 5 1 1 1 5 1 4 6 3 5 6 5 5 5 5 5 5 5
    298 2 5 5 5 3 5 3 3 3 6 3 5 6 6 3 3 5 5 5 5 5 5 5 5 5
    300 1 5 5 3 1 1 1 1 1 3 5 5 3 3 5 5 3 5 5 5 5 5 5 5 5
    301 1 5 5 5 3 3 3 3 3 5 1 3 6 6 6 6 6 3 5 5 5 5 5 5 5
    303 1 5 5 1 1 1 1 1 1 1 5 1 1 1 3 6 6 6 5 5 5 5 5 5 5
    305 1 5 5 3 1 1 1 1 5 5 1 1 1 1 1 1 3 5 5 5 5 5 5 5 5
    309 2 4 5 5 5 5 5 5 4 . . . . . . . . . . . . . . . .
    310 1 5 5 . . 4 4 5 4 4 5 4 4 4 . . 6 . . 5 5 5 5 5 5
    312 1 5 5 6 1 1 1 1 1 1 1 5 1 1 1 6 6 5 5 5 5 5 5 5 5
    316 2 5 5 5 5 5 4 5 5 5 6 6 6 4 5 5 5 5 5 5 5 5 5 5 5
    319 1 5 5 1 1 1 1 1 1 1 1 5 1 5 6 6 6 5 5 5 5 5 5 5 5
    322 1 5 5 1 1 1 1 3 3 3 5 6 6 3 3 3 5 5 5 5 5 5 5 5 5
    324 1 5 5 3 3 3 3 3 3 1 3 5 1 1 3 1 3 5 5 5 5 5 5 5 5
    325 1 1 5 1 1 1 1 1 3 6 6 5 6 6 6 5 5 6 5 5 5 5 5 5 5
    331 1 5 5 3 4 5 5 4 4 4 4 3 3 5 3 6 6 5 5 3 5 5 5 5 5
    332 1 5 5 5 1 1 1 5 3 3 3 5 5 3 6 1 6 5 5 5 5 5 5 5 5
    334 2 5 5 5 1 1 5 1 1 1 5 6 1 1 5 1 3 5 5 5 5 5 5 5 5
    338 1 5 5 1 1 5 1 1 1 1 1 1 5 5 1 6 6 5 5 5 5 5 5 5 5
    340 1 5 5 3 4 3 3 3 5 3 5 5 4 6 6 3 5 5 5 5 5 5 5 5 5
    341 1 5 5 3 3 5 3 3 3 3 3 3 5 . . . 4 3 5 5 5 5 5 5 5
    342 1 5 5 5 4 4 4 4 4 4 4 5 4 4 . 4 6 6 5 5 5 5 5 5 5
    343 2 5 5 5 1 1 1 1 3 5 6 3 6 6 3 3 3 5 5 5 5 5 5 5 5
    345 1 5 3 3 1 1 1 1 1 3 3 5 1 1 1 3 5 5 5 5 5 5 5 5 5
    347 1 5 5 5 . 4 4 4 4 4 5 4 4 4 . 3 3 5 5 5 5 5 5 5 5
    348 1 5 5 5 1 1 1 1 5 5 6 6 3 3 6 6 6 5 5 5 5 5 5 5 5
    350 1 . 5 4 1 1 1 1 1 1 1 1 1 1 1 4 3 3 5 5 5 5 5 5 5
    353 2 . 5 5 1 1 1 1 3 3 3 5 3 6 3 5 3 5 5 5 5 5 5 5 5
    355 1 . 5 1 1 1 1 1 3 3 5 6 1 3 3 5 5 5 5 5 5 5 5 5 5
    359 1 5 5 5 . 4 4 4 4 4 5 4 4 4 . 5 6 5 5 5 5 5 5 5 5
    360 1 . 6 1 1 1 1 1 5 6 5 6 6 3 3 6 6 6 5 5 5 5 5 5 5
    407 1 5 5 5 1 1 1 1 1 3 5 6 1 1 3 3 6 5 5 5 5 5 5 5 5
    410 1 5 5 5 1 1 1 1 1 1 5 1 1 1 1 6 6 5 5 5 5 5 5 5 5
    412 1 5 5 5 5 1 1 1 1 1 3 3 6 6 3 3 5 5 5 5 5 5 5 5 5
    413 1 5 5 1 1 1 1 1 1 1 5 5 1 1 1 1 5 5 5 5 5 5 5 5 5
    415 1 5 5 5 1 1 3 3 1 1 1 1 1 5 5 6 6 6 6 5 5 5 5 5 5
    417 1 5 5 5 1 1 1 1 1 1 3 3 5 1 1 5 6 5 5 5 5 5 5 5 5
    end
    label values treatment treatment
    label def treatment 0 "Control", modify
    label def treatment 1 "Treatment", modify
    label def treatment 2 "Rich", modify
    label values qn6_9_1 time
    label values qn6_9_2 time
    label values qn6_9_3 time
    label values qn6_9_4 time
    label values qn6_9_5 time
    label values qn6_9_6 time
    label values qn6_9_7 time
    label values qn6_9_8 time
    label values qn6_9_9 time
    label values qn6_9_10 time
    label values qn6_9_11 time
    label values qn6_9_12 time
    label values qn6_9_13 time
    label values qn6_9_14 time
    label values qn6_9_15 time
    label values qn6_9_16 time
    label values qn6_9_17 time
    label values qn6_9_18 time
    label values qn6_9_19 time
    label values qn6_9_20 time
    label values qn6_9_21 time
    label values qn6_9_22 time
    label values qn6_9_23 time
    label values qn6_9_24 time
    label def time 1 "Unskilled Emp", modify
    label def time 4 "Social Integration", modify
    label def time 5 "Personal Care", modify
    label def time 3 "Caregiving / HHchores", modify
    label def time 6 "Leisure", modify

  • #2
    You have been using Stata for >3 years and you don't think of collapse and reshape? Time to skim the commands in the Data Management manual.

    Thanks for data example.

    On Stata not STATA see FAQ Advice #18.

    Here's sample code and some results. Your code for your full dataset will need some small fixes for activities not sampled here.


    Code:
    * Example generated by -dataex-. To install: ssc install dataex
    clear
    input long idno byte(treatment qn6_9_1 qn6_9_2 qn6_9_3 qn6_9_4 qn6_9_5 qn6_9_6 qn6_9_7 qn6_9_8 qn6_9_9 qn6_9_10 qn6_9_11 qn6_9_12 qn6_9_13 qn6_9_14 qn6_9_15 qn6_9_16 qn6_9_17 qn6_9_18 qn6_9_19 qn6_9_20 qn6_9_21 qn6_9_22 qn6_9_23 qn6_9_24)
      2 2 5 5 5 1 1 1 1 1 1 1 6 6 6 6 5 5 6 6 5 5 5 5 5 5
     20 1 5 5 3 1 1 1 1 1 3 1 5 1 1 1 1 3 3 5 5 5 5 5 5 5
     25 1 5 5 1 1 1 1 1 1 3 3 5 3 6 6 6 6 6 5 5 5 5 5 5 5
     26 1 5 5 5 1 1 1 1 1 1 3 3 5 . . . . . 5 5 5 5 5 5 5
     30 1 5 5 5 5 1 1 1 1 3 5 6 6 6 6 6 6 5 5 5 5 5 5 5 5
     31 1 5 5 5 1 1 1 5 1 1 1 5 1 1 1 1 1 4 5 5 5 5 5 5 5
     35 2 5 5 5 5 1 1 1 1 1 1 1 5 6 . 1 1 1 5 5 . 5 5 5 5
     37 1 5 5 5 4 4 4 4 4 4 5 4 4 4 4 6 6 5 5 5 5 5 5 5 5
     39 1 5 5 5 5 1 1 1 1 6 6 5 1 1 6 6 5 5 5 5 5 5 5 5 5
     40 1 5 5 5 5 1 1 1 1 1 4 5 5 5 5 6 6 5 5 5 5 5 5 5 5
     50 1 5 5 6 5 4 1 1 1 1 5 6 1 1 1 1 5 6 5 5 . 5 5 5 5
     57 1 5 5 1 5 1 1 1 1 1 1 3 5 1 1 6 6 6 5 5 5 5 5 5 5
     64 2 5 6 5 5 4 1 1 1 1 5 6 6 6 6 3 5 6 5 5 5 5 5 5 5
     65 1 5 5 5 4 1 1 1 3 3 5 3 6 3 6 6 5 5 5 5 5 5 5 5 5
     70 1 5 5 1 1 1 1 1 1 1 1 5 1 1 3 5 6 6 6 5 5 5 5 5 5
     83 1 5 5 5 1 1 1 3 3 6 5 3 6 6 6 3 6 5 5 5 5 5 5 5 5
     85 2 5 5 5 4 1 1 1 1 4 6 5 4 6 6 5 6 6 5 5 5 5 5 5 5
     93 2 5 5 5 5 1 1 1 1 1 1 5 5 6 6 6 5 5 5 5 5 5 5 5 5
     94 2 5 5 5 1 1 1 1 1 1 1 5 1 1 1 1 5 5 5 5 5 5 5 5 5
    101 2 5 5 3 1 1 1 1 1 5 5 6 5 5 5 3 3 6 5 5 5 5 5 5 5
    105 1 5 5 5 3 3 3 3 6 6 6 3 3 6 6 3 3 3 5 5 5 5 5 5 5
    107 1 5 3 3 1 1 1 1 1 1 6 6 6 6 1 . 6 6 5 5 5 5 5 5 5
    108 1 5 5 3 1 1 1 1 1 1 3 . 1 1 1 1 3 5 5 5 5 5 5 5 5
    110 1 5 5 5 6 1 1 3 3 3 5 1 6 3 3 3 5 5 5 5 5 5 5 5 5
    115 1 5 3 3 1 1 1 1 1 1 3 3 6 1 1 3 3 3 5 5 5 5 5 5 5
    119 1 5 5 5 3 1 1 6 3 5 3 6 1 1 6 6 5 5 5 5 5 5 5 5 5
    122 1 5 5 3 1 1 1 1 1 3 3 5 3 1 1 1 5 3 5 5 5 5 5 5 5
    126 1 5 5 5 1 1 1 1 1 1 3 1 1 1 1 6 6 6 . 5 5 5 5 5 5
    130 1 5 5 1 1 1 1 1 1 1 5 5 6 1 1 6 6 6 5 5 5 5 5 5 5
    131 2 5 5 3 5 3 3 3 3 5 6 6 6 3 3 6 5 5 5 5 5 5 5 5 5
    133 1 5 1 1 1 1 1 6 6 6 6 6 6 1 1 6 . 6 3 5 5 5 5 5 5
    134 1 5 5 3 1 1 1 1 6 3 5 1 1 3 5 3 5 5 5 5 5 5 5 5 5
    162 2 5 5 5 5 1 1 1 1 1 1 3 3 3 5 6 6 5 5 5 5 5 5 5 5
    176 0 5 5 5 5 1 1 4 3 3 3 5 6 4 3 5 5 6 5 5 5 5 5 5 5
    187 0 5 5 5 5 1 1 1 1 1 4 5 4 1 1 1 1 5 5 5 5 5 5 5 5
    188 0 5 5 5 5 4 1 1 1 1 3 3 5 3 3 6 6 5 5 5 5 5 5 5 5
    189 0 5 5 4 1 1 1 5 . 4 6 1 1 3 3 3 5 . 5 5 5 5 5 5 5
    193 0 5 5 4 1 1 1 1 4 3 3 3 5 5 6 6 6 5 5 5 5 5 5 5 5
    195 0 5 5 5 1 1 1 1 1 1 5 1 1 1 1 5 6 6 5 5 5 5 5 5 5
    212 0 5 5 5 1 1 1 5 3 3 6 6 5 6 3 3 5 5 5 5 5 5 5 5 5
    214 2 5 5 5 3 5 1 1 1 1 1 1 5 5 6 6 6 5 5 5 5 5 5 5 5
    220 0 5 5 5 5 5 1 1 4 3 3 5 6 3 3 3 5 5 5 5 5 5 5 5 5
    221 0 5 5 5 5 6 6 6 6 4 . 5 4 4 4 5 1 3 5 5 5 5 5 5 5
    222 0 5 5 5 3 4 1 1 1 1 1 5 5 6 6 6 3 4 5 5 5 5 5 5 5
    223 2 5 5 . 1 1 1 1 1 1 5 5 6 6 4 6 5 5 5 5 5 5 5 5 5
    224 0 5 5 5 5 4 1 1 1 1 4 5 6 1 3 5 3 5 5 5 5 5 5 5 5
    225 0 5 5 3 1 1 1 1 1 3 3 5 6 5 4 3 3 5 5 5 5 5 5 5 5
    228 0 . 5 5 4 4 4 5 4 4 5 4 4 4 5 6 6 5 5 5 5 5 5 5 5
    229 2 5 5 5 4 1 1 1 1 1 5 1 1 1 1 1 1 4 5 5 5 5 5 5 5
    237 1 5 5 5 3 4 1 1 1 4 3 5 6 1 1 5 1 1 1 1 5 5 5 5 5
    245 1 5 5 5 3 1 1 1 1 5 3 5 6 1 1 1 5 4 5 5 5 5 5 5 5
    250 1 5 5 5 3 1 1 1 1 1 1 1 5 5 6 6 6 6 6 5 5 5 5 5 5
    255 1 5 5 5 5 5 1 1 1 1 1 5 1 1 1 5 6 6 5 5 5 5 5 5 5
    259 1 5 5 5 3 4 1 1 1 1 5 6 1 1 4 5 6 6 5 5 5 5 5 5 5
    262 1 5 5 5 1 1 1 1 3 5 1 1 1 3 5 6 6 5 5 5 5 5 5 5 5
    265 1 5 5 5 4 1 1 5 1 1 1 1 5 1 1 1 5 6 6 5 5 5 5 5 5
    266 1 5 5 5 5 1 1 1 1 6 3 5 1 1 5 4 4 6 5 5 5 5 5 5 5
    268 0 5 5 5 5 5 6 3 3 6 6 6 6 6 6 6 6 6 5 5 5 5 5 5 5
    271 2 5 5 5 3 5 3 3 5 5 3 5 6 6 6 3 5 6 5 5 5 5 5 5 5
    281 1 5 5 1 1 1 3 5 3 3 3 3 5 6 6 6 5 5 5 5 5 5 5 5 5
    284 1 5 5 5 4 4 4 5 4 4 5 4 4 4 6 5 6 6 5 5 5 5 5 5 5
    286 1 5 5 5 5 3 3 5 1 1 3 3 5 6 6 6 6 5 5 5 5 5 5 5 5
    288 1 5 5 5 5 4 1 1 1 1 5 1 1 1 4 5 5 5 5 5 5 5 5 5 5
    289 1 5 5 5 5 4 4 4 5 4 5 4 4 4 . 3 5 5 5 5 5 5 5 5 5
    297 1 5 5 5 4 1 1 5 1 1 1 5 1 4 6 3 5 6 5 5 5 5 5 5 5
    298 2 5 5 5 3 5 3 3 3 6 3 5 6 6 3 3 5 5 5 5 5 5 5 5 5
    300 1 5 5 3 1 1 1 1 1 3 5 5 3 3 5 5 3 5 5 5 5 5 5 5 5
    301 1 5 5 5 3 3 3 3 3 5 1 3 6 6 6 6 6 3 5 5 5 5 5 5 5
    303 1 5 5 1 1 1 1 1 1 1 5 1 1 1 3 6 6 6 5 5 5 5 5 5 5
    305 1 5 5 3 1 1 1 1 5 5 1 1 1 1 1 1 3 5 5 5 5 5 5 5 5
    309 2 4 5 5 5 5 5 5 4 . . . . . . . . . . . . . . . .
    310 1 5 5 . . 4 4 5 4 4 5 4 4 4 . . 6 . . 5 5 5 5 5 5
    312 1 5 5 6 1 1 1 1 1 1 1 5 1 1 1 6 6 5 5 5 5 5 5 5 5
    316 2 5 5 5 5 5 4 5 5 5 6 6 6 4 5 5 5 5 5 5 5 5 5 5 5
    319 1 5 5 1 1 1 1 1 1 1 1 5 1 5 6 6 6 5 5 5 5 5 5 5 5
    322 1 5 5 1 1 1 1 3 3 3 5 6 6 3 3 3 5 5 5 5 5 5 5 5 5
    324 1 5 5 3 3 3 3 3 3 1 3 5 1 1 3 1 3 5 5 5 5 5 5 5 5
    325 1 1 5 1 1 1 1 1 3 6 6 5 6 6 6 5 5 6 5 5 5 5 5 5 5
    331 1 5 5 3 4 5 5 4 4 4 4 3 3 5 3 6 6 5 5 3 5 5 5 5 5
    332 1 5 5 5 1 1 1 5 3 3 3 5 5 3 6 1 6 5 5 5 5 5 5 5 5
    334 2 5 5 5 1 1 5 1 1 1 5 6 1 1 5 1 3 5 5 5 5 5 5 5 5
    338 1 5 5 1 1 5 1 1 1 1 1 1 5 5 1 6 6 5 5 5 5 5 5 5 5
    340 1 5 5 3 4 3 3 3 5 3 5 5 4 6 6 3 5 5 5 5 5 5 5 5 5
    341 1 5 5 3 3 5 3 3 3 3 3 3 5 . . . 4 3 5 5 5 5 5 5 5
    342 1 5 5 5 4 4 4 4 4 4 4 5 4 4 . 4 6 6 5 5 5 5 5 5 5
    343 2 5 5 5 1 1 1 1 3 5 6 3 6 6 3 3 3 5 5 5 5 5 5 5 5
    345 1 5 3 3 1 1 1 1 1 3 3 5 1 1 1 3 5 5 5 5 5 5 5 5 5
    347 1 5 5 5 . 4 4 4 4 4 5 4 4 4 . 3 3 5 5 5 5 5 5 5 5
    348 1 5 5 5 1 1 1 1 5 5 6 6 3 3 6 6 6 5 5 5 5 5 5 5 5
    350 1 . 5 4 1 1 1 1 1 1 1 1 1 1 1 4 3 3 5 5 5 5 5 5 5
    353 2 . 5 5 1 1 1 1 3 3 3 5 3 6 3 5 3 5 5 5 5 5 5 5 5
    355 1 . 5 1 1 1 1 1 3 3 5 6 1 3 3 5 5 5 5 5 5 5 5 5 5
    359 1 5 5 5 . 4 4 4 4 4 5 4 4 4 . 5 6 5 5 5 5 5 5 5 5
    360 1 . 6 1 1 1 1 1 5 6 5 6 6 3 3 6 6 6 5 5 5 5 5 5 5
    407 1 5 5 5 1 1 1 1 1 3 5 6 1 1 3 3 6 5 5 5 5 5 5 5 5
    410 1 5 5 5 1 1 1 1 1 1 5 1 1 1 1 6 6 5 5 5 5 5 5 5 5
    412 1 5 5 5 5 1 1 1 1 1 3 3 6 6 3 3 5 5 5 5 5 5 5 5 5
    413 1 5 5 1 1 1 1 1 1 1 5 5 1 1 1 1 5 5 5 5 5 5 5 5 5
    415 1 5 5 5 1 1 3 3 1 1 1 1 1 5 5 6 6 6 6 5 5 5 5 5 5
    417 1 5 5 5 1 1 1 1 1 1 3 3 5 1 1 5 6 5 5 5 5 5 5 5 5
    end
    label values treatment treatment
    label def treatment 0 "Control", modify
    label def treatment 1 "Treatment", modify
    label def treatment 2 "Rich", modify
    label values qn6_9_1 time
    label values qn6_9_2 time
    label values qn6_9_3 time
    label values qn6_9_4 time
    label values qn6_9_5 time
    label values qn6_9_6 time
    label values qn6_9_7 time
    label values qn6_9_8 time
    label values qn6_9_9 time
    label values qn6_9_10 time
    label values qn6_9_11 time
    label values qn6_9_12 time
    label values qn6_9_13 time
    label values qn6_9_14 time
    label values qn6_9_15 time
    label values qn6_9_16 time
    label values qn6_9_17 time
    label values qn6_9_18 time
    label values qn6_9_19 time
    label values qn6_9_20 time
    label values qn6_9_21 time
    label values qn6_9_22 time
    label values qn6_9_23 time
    label values qn6_9_24 time
    label def time 1 "Unskilled Emp", modify
    label def time 4 "Social Integration", modify
    label def time 5 "Personal Care", modify
    label def time 3 "Caregiving / HHchores", modify
    label def time 6 "Leisure", modify
    
    * NJC code starts here 
    
    * idno=2 for later check
    * 5 5 5 1 1 1 1 1 1 1 6 6 6 6 5 5 6 6 5 5 5 5 5 5
    * #5 11 #1 7 #6 6 
    
    reshape long qn6_9_, i(idno) j(hour) 
    collapse (count) hour, by(idno treatment qn6_9_) 
    drop if missing(qn6_9_) 
    reshape wide hour, i(idno) j(qn6_9_) 
    
    label var hour1 "Unskilled Emp"
    label var hour3 "Caregiving / HHchores"
    label var hour4 "Social Integration"
    label var hour5 "Personal Care"
    label var hour6 "Leisure"           
    mvencode hour*, mv(0) 
    
    list 
    
    
         +----------------------------------------------------------+
         | idno   hour1   hour3   hour4   hour5   hour6   treatment |
         |----------------------------------------------------------|
      1. |    2       7       0       0      11       6        Rich |
      2. |   20      10       4       0      10       0   Treatment |
      3. |   25       6       3       0      10       5   Treatment |
      4. |   26       6       2       0      11       0   Treatment |
      5. |   30       4       1       0      13       6   Treatment |
         |----------------------------------------------------------|
      6. |   31      11       0       1      12       0   Treatment |
      7. |   35      10       0       0      11       1        Rich |
      8. |   37       0       0      10      12       2   Treatment |
      9. |   39       6       0       0      14       4   Treatment |
     10. |   40       5       0       1      16       2   Treatment |
         |----------------------------------------------------------|
     11. |   50       8       0       1      11       3   Treatment |
     12. |   57       9       1       0      11       3   Treatment |
     13. |   64       4       1       1      12       6        Rich |
     14. |   65       3       4       1      13       3   Treatment |
     15. |   70      10       1       0      10       3   Treatment |
         |----------------------------------------------------------|
     16. |   83       3       4       0      12       5   Treatment |
     17. |   85       4       0       3      12       5        Rich |
     18. |   93       6       0       0      15       3        Rich |
     19. |   94      11       0       0      13       0        Rich |
     20. |  101       5       3       0      14       2        Rich |
         |----------------------------------------------------------|
     21. |  105       0       9       0      10       5   Treatment |
     22. |  107       7       2       0       8       6   Treatment |
     23. |  108      10       3       0      10       0   Treatment |
     24. |  110       3       6       0      13       2   Treatment |
     25. |  115       8       7       0       8       1   Treatment |
         |----------------------------------------------------------|
     26. |  119       4       3       0      13       4   Treatment |
     27. |  122       8       5       0      11       0   Treatment |
     28. |  126      10       1       0       9       3   Treatment |
     29. |  130       9       0       0      11       4   Treatment |
     30. |  131       0       7       0      13       4        Rich |
         |----------------------------------------------------------|
     31. |  133       7       1       0       7       8   Treatment |
     32. |  134       6       4       0      13       1   Treatment |
     33. |  162       6       3       0      13       2        Rich |
     34. |  176       2       4       2      14       2     Control |
     35. |  187       9       0       2      13       0     Control |
         |----------------------------------------------------------|
     36. |  188       4       4       1      13       2     Control |
     37. |  189       5       3       2      11       1     Control |
     38. |  193       4       3       2      12       3     Control |
     39. |  195      10       0       0      12       2     Control |
     40. |  212       3       4       0      14       3     Control |
         |----------------------------------------------------------|
     41. |  214       6       1       0      14       3        Rich |
     42. |  220       2       5       1      15       1     Control |
     43. |  221       1       1       4      13       4     Control |
     44. |  222       5       2       2      12       3     Control |
     45. |  223       6       0       1      13       3        Rich |
         |----------------------------------------------------------|
     46. |  224       5       2       2      14       1     Control |
     47. |  225       5       5       1      12       1     Control |
     48. |  228       0       0       8      13       2     Control |
     49. |  229      11       0       2      11       0        Rich |
     50. |  237       9       2       2      10       1   Treatment |
         |----------------------------------------------------------|
     51. |  245       7       2       1      13       1   Treatment |
     52. |  250       7       1       0      11       5   Treatment |
     53. |  255       8       0       0      14       2   Treatment |
     54. |  259       6       1       2      12       3   Treatment |
     55. |  262       7       2       0      13       2   Treatment |
         |----------------------------------------------------------|
     56. |  265       9       0       1      12       2   Treatment |
     57. |  266       6       1       2      13       2   Treatment |
     58. |  268       0       2       0      12      10     Control |
     59. |  271       0       5       0      15       4        Rich |
     60. |  281       3       5       0      13       3   Treatment |
         |----------------------------------------------------------|
     61. |  284       0       0       8      13       3   Treatment |
     62. |  286       2       4       0      14       4   Treatment |
     63. |  288       7       0       2      15       0   Treatment |
     64. |  289       0       1       7      15       0   Treatment |
     65. |  297       6       1       2      13       2   Treatment |
         |----------------------------------------------------------|
     66. |  298       0       7       0      14       3        Rich |
     67. |  300       5       5       0      14       0   Treatment |
     68. |  301       1       7       0      11       5   Treatment |
     69. |  303      10       1       0      10       3   Treatment |
     70. |  305      10       2       0      12       0   Treatment |
         |----------------------------------------------------------|
     71. |  309       0       0       2       6       0        Rich |
     72. |  310       0       0       7      10       1   Treatment |
     73. |  312      10       0       0      11       3   Treatment |
     74. |  316       0       0       2      19       3        Rich |
     75. |  319       9       0       0      12       3   Treatment |
         |----------------------------------------------------------|
     76. |  322       4       6       0      12       2   Treatment |
     77. |  324       4       9       0      11       0   Treatment |
     78. |  325       6       1       0      11       6   Treatment |
     79. |  331       0       5       5      12       2   Treatment |
     80. |  332       4       4       0      14       2   Treatment |
         |----------------------------------------------------------|
     81. |  334       8       1       0      14       1        Rich |
     82. |  338       9       0       0      13       2   Treatment |
     83. |  340       0       6       2      14       2   Treatment |
     84. |  341       0       9       1      11       0   Treatment |
     85. |  342       0       0      10      11       2   Treatment |
         |----------------------------------------------------------|
     86. |  343       4       5       0      12       3        Rich |
     87. |  345       8       5       0      11       0   Treatment |
     88. |  347       0       2       8      12       0   Treatment |
     89. |  348       4       2       0      13       5   Treatment |
     90. |  350      11       2       2       8       0   Treatment |
         |----------------------------------------------------------|
     91. |  353       4       6       0      12       1        Rich |
     92. |  355       6       4       0      12       1   Treatment |
     93. |  359       0       0       8      13       1   Treatment |
     94. |  360       5       2       0       9       7   Treatment |
     95. |  407       7       3       0      12       2   Treatment |
         |----------------------------------------------------------|
     96. |  410      10       0       0      12       2   Treatment |
     97. |  412       5       4       0      13       2   Treatment |
     98. |  413      11       0       0      13       0   Treatment |
     99. |  415       7       2       0      11       4   Treatment |
    100. |  417       8       2       0      13       1   Treatment |
         +----------------------------------------------------------+

    Comment


    • #3
      Thanks a lot Nick. This works like a charm.

      FAQ advice #18 - will make sure not to repeat that.

      Comment


      • #4
        Hi Nick Cox

        I understand that my initial question was answered and that this additional query is just for my own learning. Just so that I can analyze my data in different ways, is there a way to keep the data in the long format having one variable for all activities? something like below

        ID Activity Time Spent

        1 Unskilled Emp 12
        1 Personal Care 8
        1 Leisure 4
        2 .. .
        2 . .
        2 .. .


        I've been trying to play with collapse and reshape for quite some time but for some reason not getting rid of the 24 obs (representing 24 hours) per individual.

        Thanks.

        Comment


        • #5
          Stopping after the drop command in #2 does precisely that. Naturally you can drop treatment too if you wish.

          Comment


          • #6
            I just figured that. Apologies for asking something so simple and thanks for always being so helpful.

            Comment

            Working...
            X