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