View difference between Paste ID: zQE540sQ and VWKuhZ4x
SHOW: | | - or go back to the newest paste.
1
* NOTE: You need to set the Stata working directory to the path
2
* where the data file is located.
3
4
set more off
5
6
clear
7
quietly infix              ///
8
  int     year      1-4    ///
9
  long    serial    5-9    ///
10
  float   hwtsupp   10-19  ///
11
  byte    month     20-21  ///
12
  byte    pernum    22-23  ///
13
  float   wtsupp    24-33  ///
14
  byte    nchlt5    34-34  ///
15
  byte    age       35-36  ///
16
  byte    sex       37-37  ///
17
  int     race      38-40  ///
18
  byte    marst     41-41  ///
19
  int     educ      42-44  ///
20
  byte    schlcoll  45-45  ///
21
  byte    labforce  46-46  ///
22
  int     occ       47-50  ///
23
  int     ind       51-54  ///
24
  byte    union     55-55  ///
25
  long    incwelfr  56-60  ///
26
  byte    vetstat   61-61  ///
27
  byte    disabwrk  62-62  ///
28
  byte    health    63-63  ///
29-
  using `"/Users/esoltas93/Desktop/Schoolwork/Princeton 2014-2013/Spring Term/ECO 313 Econometric Applications/CPS/cps_00006.dat"'
29+
  using `"cps_00006.dat"'
30
31
replace hwtsupp  = hwtsupp  / 10000
32
replace wtsupp   = wtsupp   / 10000
33
34
format hwtsupp  %10.4f
35
format wtsupp   %10.4f
36
37
label var year     `"Survey year"'
38
label var serial   `"Household serial number"'
39
label var hwtsupp  `"Household weight, Supplement"'
40
label var month    `"Month"'
41
label var pernum   `"Person number in sample unit"'
42
label var wtsupp   `"Supplement Weight"'
43
label var nchlt5   `"Number of own children under age 5 in hh"'
44
label var age      `"Age"'
45
label var sex      `"Sex"'
46
label var race     `"Race"'
47
label var marst    `"Marital status"'
48
label var educ     `"Educational attainment recode"'
49
label var schlcoll `"School or college attendance"'
50
label var labforce `"Labor force status"'
51
label var occ      `"Occupation"'
52
label var ind      `"Industry"'
53
label var union    `"Union membership"'
54
label var incwelfr `"Welfare (public assistance) income"'
55
label var vetstat  `"Veteran status"'
56
label var disabwrk `"Work disability"'
57
label var health   `"Health status"'
58
59
label define hwtsupp_lbl 0000000000 `"0000000000"'
60
label values hwtsupp hwtsupp_lbl
61
62
label define month_lbl 01 `"January"'
63
label define month_lbl 02 `"February"', add
64
label define month_lbl 03 `"March"', add
65
label define month_lbl 04 `"April"', add
66
label define month_lbl 05 `"May"', add
67
label define month_lbl 06 `"June"', add
68
label define month_lbl 07 `"July"', add
69
label define month_lbl 08 `"August"', add
70
label define month_lbl 09 `"September"', add
71
label define month_lbl 10 `"October"', add
72
label define month_lbl 11 `"November"', add
73
label define month_lbl 12 `"December"', add
74
label values month month_lbl
75
76
label define nchlt5_lbl 0 `"No children under age 5"'
77
label define nchlt5_lbl 1 `"1 child under age 5"', add
78
label define nchlt5_lbl 2 `"2"', add
79
label define nchlt5_lbl 3 `"3"', add
80
label define nchlt5_lbl 4 `"4"', add
81
label define nchlt5_lbl 5 `"5"', add
82
label define nchlt5_lbl 6 `"6"', add
83
label define nchlt5_lbl 7 `"7"', add
84
label define nchlt5_lbl 8 `"8"', add
85
label define nchlt5_lbl 9 `"9+"', add
86
label values nchlt5 nchlt5_lbl
87
88
label define age_lbl 00 `"Under 1 year"'
89
label define age_lbl 01 `"1"', add
90
label define age_lbl 02 `"2"', add
91
label define age_lbl 03 `"3"', add
92
label define age_lbl 04 `"4"', add
93
label define age_lbl 05 `"5"', add
94
label define age_lbl 06 `"6"', add
95
label define age_lbl 07 `"7"', add
96
label define age_lbl 08 `"8"', add
97
label define age_lbl 09 `"9"', add
98
label define age_lbl 10 `"10"', add
99
label define age_lbl 11 `"11"', add
100
label define age_lbl 12 `"12"', add
101
label define age_lbl 13 `"13"', add
102
label define age_lbl 14 `"14"', add
103
label define age_lbl 15 `"15"', add
104
label define age_lbl 16 `"16"', add
105
label define age_lbl 17 `"17"', add
106
label define age_lbl 18 `"18"', add
107
label define age_lbl 19 `"19"', add
108
label define age_lbl 20 `"20"', add
109
label define age_lbl 21 `"21"', add
110
label define age_lbl 22 `"22"', add
111
label define age_lbl 23 `"23"', add
112
label define age_lbl 24 `"24"', add
113
label define age_lbl 25 `"25"', add
114
label define age_lbl 26 `"26"', add
115
label define age_lbl 27 `"27"', add
116
label define age_lbl 28 `"28"', add
117
label define age_lbl 29 `"29"', add
118
label define age_lbl 30 `"30"', add
119
label define age_lbl 31 `"31"', add
120
label define age_lbl 32 `"32"', add
121
label define age_lbl 33 `"33"', add
122
label define age_lbl 34 `"34"', add
123
label define age_lbl 35 `"35"', add
124
label define age_lbl 36 `"36"', add
125
label define age_lbl 37 `"37"', add
126
label define age_lbl 38 `"38"', add
127
label define age_lbl 39 `"39"', add
128
label define age_lbl 40 `"40"', add
129
label define age_lbl 41 `"41"', add
130
label define age_lbl 42 `"42"', add
131
label define age_lbl 43 `"43"', add
132
label define age_lbl 44 `"44"', add
133
label define age_lbl 45 `"45"', add
134
label define age_lbl 46 `"46"', add
135
label define age_lbl 47 `"47"', add
136
label define age_lbl 48 `"48"', add
137
label define age_lbl 49 `"49"', add
138
label define age_lbl 50 `"50"', add
139
label define age_lbl 51 `"51"', add
140
label define age_lbl 52 `"52"', add
141
label define age_lbl 53 `"53"', add
142
label define age_lbl 54 `"54"', add
143
label define age_lbl 55 `"55"', add
144
label define age_lbl 56 `"56"', add
145
label define age_lbl 57 `"57"', add
146
label define age_lbl 58 `"58"', add
147
label define age_lbl 59 `"59"', add
148
label define age_lbl 60 `"60"', add
149
label define age_lbl 61 `"61"', add
150
label define age_lbl 62 `"62"', add
151
label define age_lbl 63 `"63"', add
152
label define age_lbl 64 `"64"', add
153
label define age_lbl 65 `"65"', add
154
label define age_lbl 66 `"66"', add
155
label define age_lbl 67 `"67"', add
156
label define age_lbl 68 `"68"', add
157
label define age_lbl 69 `"69"', add
158
label define age_lbl 70 `"70"', add
159
label define age_lbl 71 `"71"', add
160
label define age_lbl 72 `"72"', add
161
label define age_lbl 73 `"73"', add
162
label define age_lbl 74 `"74"', add
163
label define age_lbl 75 `"75"', add
164
label define age_lbl 76 `"76"', add
165
label define age_lbl 77 `"77"', add
166
label define age_lbl 78 `"78"', add
167
label define age_lbl 79 `"79"', add
168
label define age_lbl 80 `"80"', add
169
label define age_lbl 81 `"81"', add
170
label define age_lbl 82 `"82"', add
171
label define age_lbl 83 `"83"', add
172
label define age_lbl 84 `"84"', add
173
label define age_lbl 85 `"85"', add
174
label define age_lbl 86 `"86"', add
175
label define age_lbl 87 `"87"', add
176
label define age_lbl 88 `"88"', add
177
label define age_lbl 89 `"89"', add
178
label define age_lbl 90 `"90 (90+, 1988-2002)"', add
179
label define age_lbl 91 `"91"', add
180
label define age_lbl 92 `"92"', add
181
label define age_lbl 93 `"93"', add
182
label define age_lbl 94 `"94"', add
183
label define age_lbl 95 `"95"', add
184
label define age_lbl 96 `"96"', add
185
label define age_lbl 97 `"97"', add
186
label define age_lbl 98 `"98"', add
187
label define age_lbl 99 `"99+"', add
188
label values age age_lbl
189
190
label define sex_lbl 1 `"Male"'
191
label define sex_lbl 2 `"Female"', add
192
label define sex_lbl 9 `"NIU"', add
193
label values sex sex_lbl
194
195
label define race_lbl 100 `"White"'
196
label define race_lbl 200 `"Black/Negro"', add
197
label define race_lbl 300 `"American Indian/Aleut/Eskimo"', add
198
label define race_lbl 650 `"Asian or Pacific Islander"', add
199
label define race_lbl 651 `"Asian only"', add
200
label define race_lbl 652 `"Hawaiian/Pacific Islander only"', add
201
label define race_lbl 700 `"Other (single) race, n.e.c."', add
202
label define race_lbl 801 `"White-Black"', add
203
label define race_lbl 802 `"White-American Indian"', add
204
label define race_lbl 803 `"White-Asian"', add
205
label define race_lbl 804 `"White-Hawaiian/Pacific Islander"', add
206
label define race_lbl 805 `"Black-American Indian"', add
207
label define race_lbl 806 `"Black-Asian"', add
208
label define race_lbl 807 `"Black-Hawaiian/Pacific Islander"', add
209
label define race_lbl 808 `"American Indian-Asian"', add
210
label define race_lbl 809 `"Asian-Hawaiian/Pacific Islander"', add
211
label define race_lbl 810 `"White-Black-American Indian"', add
212
label define race_lbl 811 `"White-Black-Asian"', add
213
label define race_lbl 812 `"White-American Indian-Asian"', add
214
label define race_lbl 813 `"White-Asian-Hawaiian/Pacific Islander"', add
215
label define race_lbl 814 `"White-Black-American Indian-Asian"', add
216
label define race_lbl 815 `"American Indian-Hawaiian/Pacific Islander"', add
217
label define race_lbl 816 `"White-Black--Hawaiian/Pacific Islander"', add
218
label define race_lbl 817 `"White-American Indian-Hawaiian/Pacific Islander"', add
219
label define race_lbl 818 `"Black-American Indian-Asian"', add
220
label define race_lbl 819 `"White-American Indian-Asian-Hawaiian/Pacific Islander"', add
221
label define race_lbl 820 `"Two or three races, unspecified"', add
222
label define race_lbl 830 `"Four or five races, unspecified"', add
223
label define race_lbl 999 `"NIU"', add
224
label values race race_lbl
225
226
label define marst_lbl 1 `"Married, spouse present"'
227
label define marst_lbl 2 `"Married, spouse absent"', add
228
label define marst_lbl 3 `"Separated"', add
229
label define marst_lbl 4 `"Divorced"', add
230
label define marst_lbl 5 `"Widowed"', add
231
label define marst_lbl 6 `"Never married/single"', add
232
label define marst_lbl 9 `"Unknown"', add
233
label values marst marst_lbl
234
235
label define educ_lbl 000 `"NIU or no schooling"'
236
label define educ_lbl 001 `"NIU"', add
237
label define educ_lbl 002 `"None or preschool"', add
238
label define educ_lbl 010 `"Grades 1, 2, 3, or 4"', add
239
label define educ_lbl 011 `"Grade 1"', add
240
label define educ_lbl 012 `"Grade 2"', add
241
label define educ_lbl 013 `"Grade 3"', add
242
label define educ_lbl 014 `"Grade 4"', add
243
label define educ_lbl 020 `"Grades 5 or 6"', add
244
label define educ_lbl 021 `"Grade 5"', add
245
label define educ_lbl 022 `"Grade 6"', add
246
label define educ_lbl 030 `"Grades 7 or 8"', add
247
label define educ_lbl 031 `"Grade 7"', add
248
label define educ_lbl 032 `"Grade 8"', add
249
label define educ_lbl 040 `"Grade 9"', add
250
label define educ_lbl 050 `"Grade 10"', add
251
label define educ_lbl 060 `"Grade 11"', add
252
label define educ_lbl 070 `"Grade 12"', add
253
label define educ_lbl 071 `"12th grade, no diploma"', add
254
label define educ_lbl 072 `"12th grade, diploma unclear"', add
255
label define educ_lbl 073 `"High school diploma or equivalent"', add
256
label define educ_lbl 080 `"1 year of college"', add
257
label define educ_lbl 081 `"Some college but no degree"', add
258
label define educ_lbl 090 `"2 years of college"', add
259
label define educ_lbl 091 `"Associate's degree, occupational/vocational program"', add
260
label define educ_lbl 092 `"Associate's degree, academic program"', add
261
label define educ_lbl 100 `"3 years of college"', add
262
label define educ_lbl 110 `"4 years of college"', add
263
label define educ_lbl 111 `"Bachelor's degree"', add
264
label define educ_lbl 120 `"5+ years of college"', add
265
label define educ_lbl 121 `"5 years of college"', add
266
label define educ_lbl 122 `"6+ years of college"', add
267
label define educ_lbl 123 `"Master's degree"', add
268
label define educ_lbl 124 `"Professional school degree"', add
269
label define educ_lbl 125 `"Doctorate degree"', add
270
label define educ_lbl 999 `"Missing/Unknown"', add
271
label values educ educ_lbl
272
273
label define schlcoll_lbl 0 `"NIU"'
274
label define schlcoll_lbl 1 `"High school full time"', add
275
label define schlcoll_lbl 2 `"High school part time"', add
276
label define schlcoll_lbl 3 `"College or university full time"', add
277
label define schlcoll_lbl 4 `"College or university part time"', add
278
label define schlcoll_lbl 5 `"Does not attend school, college or university"', add
279
label values schlcoll schlcoll_lbl
280
281
label define labforce_lbl 0 `"NIU"'
282
label define labforce_lbl 1 `"No, not in the labor force"', add
283
label define labforce_lbl 2 `"Yes, in the labor force"', add
284
label values labforce labforce_lbl
285
286
label define occ_lbl 0000 `"0"'
287
label define occ_lbl 0001 `"1"', add
288
label define occ_lbl 0002 `"2"', add
289
label define occ_lbl 0003 `"3"', add
290
label define occ_lbl 0004 `"4"', add
291
label define occ_lbl 0005 `"5"', add
292
label define occ_lbl 0006 `"6"', add
293
label define occ_lbl 0007 `"7"', add
294
label define occ_lbl 0008 `"8"', add
295
label define occ_lbl 0009 `"9"', add
296
label define occ_lbl 0010 `"10"', add
297
label define occ_lbl 0011 `"11"', add
298
label define occ_lbl 0012 `"12"', add
299
label define occ_lbl 0013 `"13"', add
300
label define occ_lbl 0014 `"14"', add
301
label define occ_lbl 0015 `"15"', add
302
label define occ_lbl 0016 `"16"', add
303
label define occ_lbl 0017 `"17"', add
304
label define occ_lbl 0018 `"18"', add
305
label define occ_lbl 0019 `"19"', add
306
label define occ_lbl 0020 `"20"', add
307
label define occ_lbl 0021 `"21"', add
308
label define occ_lbl 0022 `"22"', add
309
label define occ_lbl 0023 `"23"', add
310
label define occ_lbl 0024 `"24"', add
311
label define occ_lbl 0025 `"25"', add
312
label define occ_lbl 0026 `"26"', add
313
label define occ_lbl 0027 `"27"', add
314
label define occ_lbl 0028 `"28"', add
315
label define occ_lbl 0029 `"29"', add
316
label define occ_lbl 0030 `"30"', add
317
label define occ_lbl 0031 `"31"', add
318
label define occ_lbl 0032 `"32"', add
319
label define occ_lbl 0033 `"33"', add
320
label define occ_lbl 0034 `"34"', add
321
label define occ_lbl 0035 `"35"', add
322
label define occ_lbl 0036 `"36"', add
323
label define occ_lbl 0037 `"37"', add
324
label define occ_lbl 0099 `"99"', add
325
label values occ occ_lbl
326
327
label define ind_lbl 0000 `"0"'
328
label values ind ind_lbl
329
330
label define union_lbl 0 `"NIU"'
331
label define union_lbl 1 `"No union coverage"', add
332
label define union_lbl 2 `"Member of labor union"', add
333
label define union_lbl 3 `"Covered by union but not a member"', add
334
label values union union_lbl
335
336
label define vetstat_lbl 0 `"NIU"'
337
label define vetstat_lbl 1 `"No service"', add
338
label define vetstat_lbl 2 `"Yes"', add
339
label define vetstat_lbl 9 `"Unknown"', add
340
label values vetstat vetstat_lbl
341
342
label define disabwrk_lbl 0 `"NIU"'
343
label define disabwrk_lbl 1 `"No disability that affects work"', add
344
label define disabwrk_lbl 2 `"Disability limits or prevents work"', add
345
label values disabwrk disabwrk_lbl
346
347
label define health_lbl 1 `"Excellent"'
348
label define health_lbl 2 `"Very good"', add
349
label define health_lbl 3 `"Good"', add
350
label define health_lbl 4 `"Fair"', add
351
label define health_lbl 5 `"Poor"', add
352
label values health health_lbl
353
354
355
356
------
357
358
do "cps_00006.do"
359
360
drop month
361
362
drop if age < 16
363
gen agesq = age * age
364
label variable agesq "square of age"
365
366
gen edcat =.
367
la var edcat "education categories"
368
replace edcat = 1 if educ <= 72
369
replace edcat =. if educ <= 1
370
replace edcat = 2 if educ == 73
371
replace edcat = 3 if educ > 73 & educ < 111
372
replace edcat = 4 if educ == 111
373
replace edcat = 5 if educ > 111
374
drop educ
375
376
gen umem =.
377
la var umem "=1 if union member"
378
replace umem = 1 if union == 2
379
replace umem = 0 if union != 2
380
drop union
381
382
gen vet =.
383
la var vet "=1 if vet"
384
replace vet = 1 if vetstat == 2
385
replace vet = 0 if vetstat != 2
386
drop vetstat
387
388
replace health = health - 1
389
390
replace disabwrk = disabwrk - 1
391
rename disabwrk disabled
392
la var disabled "=1 if work disability"
393
394
gen welfare = 0
395
la var welfare "=1 if on welfare"
396
replace welfare = 1 if incwelfr > 0
397
drop incwelfr
398
399
gen inschool = 0
400
la var inschool "=1 if in school"
401
replace inschool = 1 if schlcoll > 0 & schlcoll < 5
402
drop schl
403
404
replace sex = sex - 1
405
la var sex "=1 if female"
406
rename sex female
407
408
gen racecat =.
409
replace racecat = 0 if race == 100
410
replace racecat = 1 if race == 200
411
replace racecat = 2 if race == 651
412
replace racecat = 3 if racecat ==.
413
drop race
414
415
gen children = 0
416
replace children = 1 if nchlt > 0
417
drop nchlt
418
label variable children "=1 if children < 5"
419
420
gen y2007 = 1
421
label variable y2007 "=1 in 2007"
422
replace y2007 = 0 if year == 2013
423
424
gen married = 0
425
label variable married "=1 if married"
426
replace married = 1 if marst == 1 | marst == 2
427
gen marrfe = married * female
428
drop marst
429
430
tab edcat, gen(edcat)
431
tab racecat, gen(racecat)
432
tab health, gen(health)
433
434
gen lf = 0
435
replace lf = 1 if labforce == 2
436
drop labforce
437
438
oaxaca lf age agesq female married marrfe disabled children inschool health2-health5 edcat2-edcat5 vet welfare racecat2-racecat4 [pw=wtsupp], by(y2007) relax weight(1) noisily probit r