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 |