API tools faq
paste
Advertisement
Guest User

.do file

a guest
May 3rd, 2014
200
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.66 KB | None | 0 0
raw download clone embed print report diff
  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 `"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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!