------------------------------------------------------------------------------- name: log: /disk/data3/morg/sources/annual2020.log log type: text opened on: 12 May 2021, 06:30:42 . set more 1 . * run raw/extract_morg before this program . *primary family and child variables added 2000-04-20 by Jean Roth, jroth@nber > .org . *Y2K compliance by Jean Roth, jroth@nber.org, 2001-01-15 . *Imputed highest grade completed, ihigrdc, added by Jean Roth, jroth@nber.org > , 2003-01-20 . *Stata 8 compliance by Jean Roth, jroth@nber.org, 2003-02-28 . *matching variables added by Jean Roth, jroth@nber.org, 2003-02-12 . * run with nohup stata -b do annual2002 & to run in batch mode . do rw . . program rw 1. * grab the annual file . * keep data from the relevant month . * sort by revised weight merge variables . * merge using the revised weight monthly file, 'rwmonyy.dta' . * save the merged file as 'mon' . use /homes/data/morg/annual/rw/annual 2. keep if intmonth==`3' 3. quietly describe 4. display "`3' `2' obs " r(N) 5. local rwlist qstnum intmonth year occurnum 6. sort `rwlist' 7. merge `rwlist' using /homes/data/morg/annual/rw/rw`2'`1' 8. drop if _merge == 2 9. save /homes/data/morg/annual/rw/`2', replace 10. end . end of do-file . ! /bin/rm -f /tmp/aef.raw aef.dct dcthead . capture erase /tmp/aef.raw . capture erase aef.dct . capture erase dcthead . ! echo >dcthead dictionary using /tmp/aef.raw . program define aef2 1. local dct_name "aef`3'.dbd" 2. local raw_name "../raw/morg`2'" 3. display "dct_name `dct_name' raw_name=`raw_name'" 4. if `1' <= 1993 { 5. *!zcat /homes/data/cps-basic/cpsb`2'??.Z |tr "\-A" " " >/tmp/aef.raw . !zcat /homes/data/morg/raw/morg`2'.Z |tr "\-A" " " >/tmp/morg`2'.raw 6. } 7. *if `1' == 1993 { . * *!zcat /homes/data/cps-basic/cpsb`2'??.Z |tr "\-A" " " >/tmp/aef.raw . * !zcat /homes/data/morg/raw/morg`2'.oldweights.Z |tr "\-A" " " >/tmp/ae > f.raw . *} . if `1' >= 1994 & `1'<=2010 { 8. *!zcat /homes/data/cps-basic/cpsb`2'??.Z >/tmp/aef.raw . !zcat /homes/data/morg/raw/morg`2'.Z >/tmp/aef.raw 9. } 10. if `1' >=2011 & `1'<=2012 { 11. !bzcat /homes/data/morg/raw/morg`2'.bz2 >/tmp/aef.raw 12. } 13. *quietly infile using "`dct_name'" if age>15&age!=. , using("`raw_name'") > clear . *quietly infile using "`dct_name'" if age>15&age!=. in 1/100 , using("`raw_na > me'") clear . *! cat /home/data/morg/sources/dcthead /home/data/morg/sources/aef`3'.dbd >./ > aef.dct . ! cat /home/data/morg/sources/aef`3'.dbd >./aef.dct 14. *quietly infile using aef.dct if age>15&age!=. , using("/tmp/aef.raw") cle > ar . *quietly infile using aef.dct , using("/tmp/aef.raw") clear . quietly infile using aef.dct , using("/homes/data/morg/raw/morg`2'.raw") clea > r 15. *quietly infile using aef.dct , using("/homes/data/morg/raw/morg`2'.raw") > clear . keep if minsamp==4 | minsamp==8 16. gen recnum=_n 17. label variable recnum "Unique record ID number. It's sequence in the orig > inal file." 18. quietly describe 19. display "obs " r(N) 20. quietly count if age<=15 21. display "# of persons with age<=15 `r(N)'" 22. quietly count if age==. 23. display "# of non-interview records `r(N)'" 24. tab age , missing 25. tab age if age==. , missing 26. tab age if age<=15 27. keep if age>15 28. keep if age!=. 29. quietly describe 30. display "obs " r(N) " after keeping age>15&age!=. " 31. display "infile successful" 32. #delimit cr delimiter now cr . generate int year = `1' 33. *summarize . tab intmonth if `1'==2005 34. ** Revised Census 2000-based Weights. Impact employment and union variabl > es . if inlist( `1', 2000 , 2001 , 2002 ) { 35. gen id = _n 36. local rwlist qstnum intmonth year occurnum 37. sort `rwlist' 38. quietly describe 39. display "total obs pre-revise `1' " r(N) 40. saveold /homes/data/morg/annual/rw/annual, version(11) replace 41. clear 42. rw `2' jan 1 43. rw `2' feb 2 44. rw `2' mar 3 45. rw `2' apr 4 46. rw `2' may 5 47. rw `2' jun 6 48. rw `2' jul 7 49. rw `2' aug 8 50. rw `2' sep 9 51. rw `2' oct 10 52. rw `2' nov 11 53. rw `2' dec 12 54. local monlist feb mar apr may jun jul aug sep oct nov dec 55. clear 56. display "using jan" 57. use /homes/data/morg/annual/rw/jan 58. foreach mon in `monlist' { 59. append using /home/data/morg/annual/rw/`mon' 60. } 61. quietly describe 62. display "total obs post-revise" r(N) 63. display "start renaming" 64. rename neio1icd ind02 65. rename ntio1ocd occ00 66. replace occ00 = . if occ00 < 0 67. rename class94 class94p 68. replace class94p = . if class94p<0 69. . rename neio1cow class94 70. rename earnwt earnwtp 71. rename nworwgt earnwt 72. rename weight weightp 73. rename nwsswgt weight 74. display "done renaming" 75. display "drop 2000" 76. if `1' == 2000 { 77. drop neerncov neernlab 78. } 79. display "rename 2001-2002" 80. if inlist( `1' , 2001 , 2002 ) { 81. rename unioncov unioncop 82. replace unioncop = . if unioncop < 0 83. rename neerncov unioncov 84. rename unionmme unionmep 85. replace unionmep = . if unionmep < 0 86. rename neernlab unionmme 87. } 88. sort id 89. drop id _merge 90. } 91. . * Miscellaneous (record keeping) variables . if `1' == 1994 { 92. replace hhid = hhid94 93. drop hhid94 94. } 95. if `1'== 1995 { 96. replace hhid = hhid94 if intmonth<9 97. drop hhid94 98. } 99. if inlist( `1', 1996 , 1997 ) { 100. drop hhid94 101. } 102. replace hurespli =. if hurespli <0 103. if `1'>=2003 & `1'<=2006 { 104. drop linedad 105. drop linemom 106. } 107. if `1'>=2007 { 108. replace linedad=. if linedad<0 109. replace linemom=. if linemom<0 110. } 111. if ( inlist(`1',2003,2004) | `1'>=2007 ) { 112. drop hurhhscrn 113. drop purkat1 114. drop purkat2 115. } 116. if `1'==2005 { 117. replace hurhhscrn=. if intmonth<=10 | hurhhscrn<0 118. replace purkat1=. if intmonth<=10 | purkat1<0 119. replace purkat2=. if intmonth<=10 | purkat2<0 120. } 121. if `1'==2006 { 122. replace hurhhscrn=. if hurhhscrn<0 123. replace purkat1=. if purkat2<0 124. replace purkat2=. if purkat2<0 125. . } 126. ************************************************** . ** Creating time-series month/year from the first month-in-sample . generate ym_file = ym(year,intmonth) 127. label variable ym_file "time series month from original data" 128. generate ym = ym_file 129. label variable ym "time series month of first month-in-sample" 130. replace ym = ym - 1 if minsamp == 2 131. replace ym = ym - 2 if minsamp == 3 132. replace ym = ym - 3 if minsamp == 4 133. replace ym = ym - 12 if minsamp == 5 134. replace ym = ym - 13 if minsamp == 6 135. replace ym = ym - 14 if minsamp == 7 136. replace ym = ym - 15 if minsamp == 8 137. ************************************************** . * Geography . display "Geography" 138. if `1'==2004 { 139. display "replace serial" 140. replace serial = serial04 if intmonth >= 5 141. replace hrsample = "" if intmonth >= 5 142. replace hhnum = hhnum04 if intmonth >= 5 143. display "replace cmsacode" 144. replace cmsacode = . if intmonth >= 5 145. display "replace msafips" 146. replace msafips = . if intmonth >= 5 147. display "replace smsa93" 148. replace smsa93 = . if smsa93<2 & intmonth<=4 149. replace smsa93 = . if intmonth >= 5 150. display "replacing smsa04 in May 2004 and later" 151. replace smsa04 = . if smsa04<2 & intmonth >= 5 152. } 153. if `1' == 2005 { 154. replace serial = serial04 155. replace hrsample ="" 156. replace smsa04 = . if smsa04<2 & intmonth >= 5 157. } 158. if `1' >= 2005 { 159. replace hhnum = hhnum04 160. display "dropping cmsacode msafips smsa93" 161. drop cmsacode msafips smsa93 162. } 163. if `1' == 2003 { 164. display "dropping non-2003 variables" 165. drop cbsafips smsa04 serial04 hhnum04 hrhhid2 166. } 167. if `1'==2004 { 168. display "replacing pre-May 2004 variables" 169. replace cbsafips = . if intmonth <=4 170. replace smsa04 = . if intmonth <=4 171. replace hrhhid2 ="" if intmonth <=4 172. } 173. if `1' >= 2004 { 174. drop serial04 hhnum04 175. } 176. if `1' >= 1996 & `1' <= 2003 { 177. replace smsa93 = . if smsa93<2 178. } 179. display "smsasize = . if smsasize <=0" 180. capture replace smsasize = . if smsasize <=0 181. if `1' == 1995 { 182. replace smsastat = smsa995 if intmonth>8 183. replace icntcity = icntct94 if intmonth<9 184. replace centcity = centcitx if intmonth<9 185. replace smsa93 = . if intmonth>=9 & smsa93<2 186. replace smsa93 = . if intmonth<9 187. drop pmsarank 188. dis "gen smsa80" 189. generate smsa80 = smsasize 190. dis "rep smsa80" 191. replace smsa80 = . if intmonth >= 10 192. dis "replace county" 193. replace county = . if county < 0 194. dis "drop county" 195. if intmonth<9 { 196. drop county 197. } 198. } 199. if `1' >= 2014 { 200. replace state = . if intmonth > 3 201. } 202. if `1' >= 2015 { 203. cap drop state 204. } 205. display "inlisting 96 97" 206. if inlist( `1', 1996 , 1997 ) { 207. replace smsastat = smsa995 208. } 209. display "replace smsastat = . if smsastat==3 | smsastat<0" 210. replace smsastat = . if smsastat==3 | smsastat<0 211. if `1' == 1994 { 212. drop smsa93 213. drop county 214. replace centcity = centcitx 215. replace icntcity = icntct94 216. replace pmsarank = . if intmonth > 3 217. replace pmsarank = . if pmsarank <= 0 218. replace cmsarank = . if intmonth > 3 219. } 220. if inlist( `1', 1996 , 1997 ) { 221. drop pmsarank 222. } 223. if `1' >= 1994 & `1' <= 1997 { 224. drop centcitx icntct94 smsa995 225. } 226. if `1' >= 1994 { 227. replace peinusyr = . if peinusyr < 0 228. } 229. display "replace centcity = . if centcity==4 | centcity<=0" 230. replace centcity = . if centcity==4 | centcity<=0 231. if `1' >= 1986 & `1' < 1994 { 232. replace pmsarank = . if pmsarank<=0 233. } 234. if `1' >= 1995 & `1' <= 1997 { 235. drop cmsarank 236. } 237. if `1' >= 1986 { 238. replace icntcity = . if icntcity<=0 239. } 240. if `1' > 1984 & `1' < 1995 { 241. replace cmsarank = . if cmsarank<=0 242. } 243. if `1' >= 1989 & `1' <= 2004 { 244. replace msafips = . if msafips <=0 245. replace cmsacode = . if cmsacode<=0 246. } 247. ** 1970 occupation variables are not correct on morg83.raw . if `1' == 1983 { 248. drop docc70 occ70 249. } 250. if `1' == 1985 { 251. replace smsarank = . if intmonth > 9 252. } 253. if `1' == 1984 { 254. display "drop icntcity pmsarank cmsarank" 255. drop icntcity pmsarank cmsarank 256. } 257. if `1' == 1985 & intmonth < 10 { 258. drop icntcity pmsarank cmsarank 259. } 260. if `1' == 1994 { 261. replace cmsarank = . if intmonth>3 262. } 263. display "replace smsasize=. if smsasize<=0" 264. **should line below be commented out??? . capture replace smsasize=. if smsasize<=0 265. if `1' < 1985 { 266. display "generate byte smsa70 = smsasize" 267. generate byte smsa70 = smsasize 268. } 269. if `1' > 1985 & `1' < 1995 { 270. generate byte smsa80 = smsasize 271. } 272. if `1' == 1985 { 273. generate byte smsa70 = smsasize if intmonth<10 274. } 275. if `1' == 1985 { 276. generate byte smsa80 = smsasize if intmonth>9 277. } 278. display "drop smsasize" 279. capture drop smsasize 280. if `1' > 1985 & `1' < 1989 { 281. drop smsarank 282. } 283. if `1' < 1983 { 284. display "drop unioncov unionmme occ80 ind80" 285. drop unioncov unionmme occ80 ind80 286. } 287. . * Demography . display "Demography" 288. if `1' > 1983 & `1' < 1994 { 289. replace ownchild = . if ownchild ==0 290. replace ownchild = ownchild - 1 291. generate int ch613=chldpres 292. generate int ch1417=chldpres 293. } 294. if `1' >= 1984 { 295. replace spouse = . if spouse < 0 296. } 297. display "if `1' > 1983 & `1' < 1989 {" 298. if `1' > 1983 & `1' < 1989 { 299. generate int ch05= chldpres 300. recode ch05 (4 6/8 = 1) (0/3 5 = 0) 301. recode ch613 (3 5 7/8 = 1) (0/2 4 6 = 0) 302. recode ch1417 (2 5/6 8 =1) (0/1 3/4 7 = 0) 303. } 304. if `1' > 1988 & `1' < 1994 { 305. display "if `1' > 1988 & `1' < 1994 {" 306. generate int ch02 = chldpres 307. generate int ch35 = chldpres 308. recode ch02 (2 6/8 12/14 16 = 1) (0/1 3/5 9/11 15 = 0) 309. recode ch35 (3 6 9/10 12/13 15/16 = 1) (0/2 4/5 7/8 11 14 = 0) 310. recode ch613 (4 7 9 11/12 14/16 = 1) (0/3 5/6 8 10 13 = 0) 311. recode ch1417 (5 8 10/11 13/16 = 1) (0/4 6/7 9 12 = 0 ) 312. generate int ch05 = ch02 313. replace ch05 = ch35 if ch35 == 1 314. label variable ch02 "Children 0-2" 315. label variable ch35 "Children 3-5" 316. } 317. if `1' > 1983 & `1' < 1994 { 318. display "if `1' > 1983 & `1' < 1994 {" 319. label variable ch05 "Children 0-5" 320. label variable ch613 "Children 6-13" 321. label variable ch1417 "Children 6-17" 322. } 323. if `1' >= 1994 & `1' <= 1996 { 324. drop prpertyp 325. } 326. if `1' >= 1997 { 327. replace prpertyp=. if prpertyp<0 328. } 329. if `1' == 1998 { 330. drop ownchild chldpres 331. } 332. if `1' >= 1999 { 333. replace ownchild = . if ownchild < 0 334. replace chldpres = . if chldpres < 0 335. generate int ch02 = chldpres 336. generate int ch35 = chldpres 337. generate int ch613 = chldpres 338. generate int ch1417 = chldpres 339. recode ch02 (1 5/7 11/13 15 = 1) (0 2/4 8/10 14 = 0) 340. recode ch35 (2 5 8/9 11/12 14/15 = 1) (0/1 3/4 6/7 10 13 =0) 341. recode ch613 (3 6 8 10/11 13/15 = 1) (0/2 4/5 7 9 12 = 0) 342. recode ch1417 (4 7 9/10 12/15 = 1) (0/3 5/6 8 11 = 0) 343. generate int ch05 = ch02 344. replace ch05 = ch35 if ch35 == 1 345. } 346. . if `1' == 1999 { 347. replace ownchild = . if intmonth < 10 348. replace chldpres = . if intmonth < 10 349. replace ch613 = . if intmonth < 10 350. replace ch1417 = . if intmonth < 10 351. replace ch05 = . if intmonth < 10 352. replace ch02 = . if intmonth < 10 353. replace ch35 = . if intmonth < 10 354. } 355. if `1' > 1988 & `1' < 1992 { 356. drop grade92 357. } 358. if `1' < 1989 { 359. replace gradeat = gradeat - 1 360. replace marital = 7 if marital==5 361. } 362. if `1' > 1991 { 363. replace grade92 = . if grade92 < 0 364. } 365. if `1' >= 1998 { 366. replace ged = . if ged < 0 367. replace gedhigr = . if gedhigr < 0 368. replace yrcoll = . if yrcoll < 0 369. replace grprof = . if grprof < 0 370. replace gr6cor = . if gr6cor < 0 371. replace ms123 = . if ms123 < 0 372. generate double ihigrdc = . 373. ** Jaeger . label var ihigrdc "Imputed highest grade completed" 374. replace ihigrdc = 0 if grade92==31 375. replace ihigrdc = 2.5 if grade92==32 376. replace ihigrdc = 5.5 if grade92==33 377. replace ihigrdc = 7.5 if grade92==34 378. replace ihigrdc = 9 if grade92==35 379. replace ihigrdc =10 if grade92==36 380. replace ihigrdc =11 if grade92==37 381. replace ihigrdc =12 if grade92==38 382. replace ihigrdc = 0 if grade92==39 & ged==2 & gedhigr==1 383. replace ihigrdc = 2.5 if grade92==39 & ged==2 & gedhigr==2 384. replace ihigrdc = 5.5 if grade92==39 & ged==2 & gedhigr==3 385. replace ihigrdc = 7.5 if grade92==39 & ged==2 & gedhigr==4 386. replace ihigrdc = 9 if grade92==39 & ged==2 & gedhigr==5 387. replace ihigrdc = 10 if grade92==39 & ged==2 & gedhigr==6 388. replace ihigrdc = 11 if grade92==39 & ged==2 & gedhigr==7 389. replace ihigrdc = 12 if grade92==39 & ged==2 & gedhigr==8 390. replace ihigrdc = 12 if ged==1 391. replace ihigrdc = 12 if grade92>=40 & grade92<=42 & yrcoll==1 392. replace ihigrdc = 13 if grade92>=40 & grade92<=42 & yrcoll==2 393. replace ihigrdc = 14 if grade92>=40 & grade92<=42 & yrcoll==3 394. replace ihigrdc = 15 if grade92>=40 & grade92<=42 & yrcoll==4 395. replace ihigrdc = 16 if grade92>=40 & grade92<=42 & yrcoll==5 396. replace ihigrdc = 16 if grade92==43 & grprof==2 397. replace ihigrdc = 17 if grade92==43 & gr6cor==2 398. replace ihigrdc = 18 if grade92==43 & gr6cor==1 399. replace ihigrdc = 17 if grade92==44 & ms123==1 400. replace ihigrdc = 18 if grade92==44 & ms123>=2 & ms123<. 401. replace ihigrdc = 18 if grade92==45 | grade92==46 402. } 403. if inlist( `1', 1992 , 1993 ) { 404. drop gradecp gradeat 405. } 406. if `1' == 1995 { 407. replace relref94 = . if intmonth > 2 408. replace relref95 = . if intmonth < 3 409. } 410. if inlist( `1', 1996 , 1997 ) { 411. drop relref94 412. } 413. if `1' == 1994 { 414. drop relref95 415. } 416. if `1' >= 1994 { 417. replace ernpdh2 = . if ernpdh2 < 0 418. replace prunedur = . if prunedur < 0 419. replace penatvty = . if penatvty < 0 420. replace pemntvty = . if pemntvty < 0 421. replace pefntvty = . if pefntvty < 0 422. replace prcitshp = . if prcitshp < 0 423. replace prcitflg = . if prcitflg < 0 424. } 425. if `1' > 1989 { 426. replace ethnic = . if ethnic < 0 427. replace ethnic = . if ethnic >= 10 428. } 429. if `1' >= 1994 & `1' <= 2004 { 430. replace veteran = . if veteran < 0 431. } 432. if `1' >= 2003 & `1' <= 2004 { 433. drop vet1-vet4 434. } 435. if `1' == 2005 { 436. display "replacing veteran Jan-July 2005" 437. replace veteran = . if veteran < 0 & intmonth <= 7 438. display "replacing vet1-vet4 if intmonth <= 7 " 439. replace vet1 = . if intmonth <= 7 440. replace vet2 = . if intmonth <= 7 441. replace vet3 = . if intmonth <= 7 442. replace vet4 = . if intmonth <= 7 443. } 444. if `1' == 2005 { 445. replace veteran = . if intmonth >= 8 446. replace vet1 = . if vet1 < 0 & intmonth >= 8 447. replace vet2 = . if vet2 < 0 & intmonth >= 8 448. replace vet3 = . if vet3 < 0 & intmonth >= 8 449. replace vet4 = . if vet4 < 0 & intmonth >= 8 450. } 451. if `1' >= 2006 { 452. drop veteran 453. replace vet1=. if vet1<0 454. replace vet2=. if vet2<0 455. replace vet3=. if vet3<0 456. replace vet4=. if vet4<0 457. } 458. * Employment . display "Employment" 459. if `1' >= 1994 { 460. replace selfproxy = . if selfproxy<0 461. replace dwrsn = . if dwrsn<0 462. replace otc = . if otc<0 463. } 464. if `1' >= 1994 & `1' <= 2002 { 465. replace occ80 = . if occ80 <0 466. replace ind80 = . if ind80 < 10 467. replace class94 = . if class94<0 468. } 469. if `1' >= 2000 & `1' <=2010 { 470. replace occ00 = . if occ00 <0 471. replace ind02 = . if ind02 < 10 472. replace class94 = . if class94<0 473. } 474. if ( `1' == 2011 ) { 475. rename occ00 occ2011 476. lab var occ2011 "occupation code" 477. replace occ2011 = . if occ2011 <0 478. replace ind02 = . if ind02 < 10 479. replace class94 = . if class94<0 480. } 481. if ( `1' == 2012 ) { 482. di "Race 2003-April 2012 21 Categories" 483. di "Race May 2012 on 26 Categories" 484. gen race21 = race 485. replace race21 = . if intmonth >=5 486. gen race26 = race 487. replace race26 = . if intmonth <=4 488. di "2012 Occupation" 489. rename occ00 occ2011 490. gen occ2012 = occ2011 491. lab var occ2012 "occupation code" 492. replace occ2011 = . if occ2011 <0 | intmonth >=5 493. replace occ2012 = . if occ2012 <0 | intmonth <=4 494. replace ind02 = . if ind02 < 10 495. replace class94 = . if class94<0 496. } 497. if ( `1' >= 2013 ) { 498. rename occ00 occ2012 499. lab var occ2012 "occupation code" 500. replace occ2012 = . if occ2012 <0 501. replace ind02 = . if ind02 < 10 502. replace class94 = . if class94<0 503. } 504. #delimit ; delimiter now ; . ; . display "docc80" ; 505. if `1' >= 1983 & `1' <= 2002 { > display "generate int docc80=occ80;"; 506. generate int docc80=occ80; 507. display "recode docc80"; 508. recode docc80 (1/6=1) (7/22=2) (23/37=3) (44/59=4) (64/68=5) (69/83=6 > ) (84/89=7) > (95/106=8) (113/154=9) (155/159=10) (178/179=11) (43 63 163/177 183/199=1 > 2) > (203/208=13) (213/225=14) (226/235=15) (243=16) (253/257=17) (258/259=18) > (263/278=19) (283/285=20) (303/307=21) (308/309=22) (313/315=23) (337/344 > =24) > (354/357=25) (316/336 345/353 359/389=26) (403/407=27) (413/427=28) > (433/444=29) (445/447=30) (448/455=31) (456/469=32) (503/549=33) (553/599 > =34) > (613/699=35) (703/779=36) (783/799=37) (803/814=38) (823/859=39) (869=40) > (875/883=41) (863/868 873 874 885/889=42) (473/476=43) (477/489=44) (494/ > 499=45) > (905=46); 509. } ; 510. display "** The renaming is part of the Census reweighting ; " ; 511. if inlist( `1', 2000 , 2001 , 2002 ) { > *display "renaming docc80 docc80p " ; 512. *rename docc80 docc80p ; . } ; 513. display "docc00" ; 514. di "553" ; 515. if `1' >= 2000 & `1'<=2010 { ; 516. di "556" ; 517. display "generate int docc00=occ00;"; 518. generate int docc00=occ00; 519. display "recode docc00 2000-2010"; 520. recode docc00 (10/430=1) (500/950=2) (1000/1240=3) (1300/1560=4) (160 > 0/1960=5) > (2000/2060=6) (2100/2150=7) (2200/2550=8) (2600/2960=9) (3000/3540=10) (3 > 600/3650=11) > (3700/3950=12) (4000/4160=13) (4200/4250=14) (4300/4650=15) (4700/4960=16 > ) > (5000/5930=17) (6000/6130=18) (6200/6940=19) (7000/7620=20) (7700/8960=21 > ) > (9000/9750=22) (9840=23); 521. } ; 522. if `1' >= 2011 { ; 523. display "generate int docc00=occ2011;"; 524. di "568"; 525. if `1' == 2011 { ; 526. generate int docc00=occ2011 ; 527. } ; 528. di "572"; 529. if `1' == 2012 { ; 530. generate int docc00=occ2011 ; 531. replace docc00 = occ2012 if docc00 == . ; 532. } ; 533. di "577"; 534. if `1' >= 2013 { ; 535. generate int docc00=occ2012 ; 536. } ; 537. di "581"; 538. display "recode docc00 2011"; 539. recode docc00 (10/430=1) (500/950=2) (1000/1240=3) (1300/1560=4) (160 > 0/1965=5) > (2000/2060=6) (2100/2160=7) (2200/2550=8) (2600/2960=9) (3000/3540=10) (3 > 600/3655=11) > (3700/3955=12) (4000/4160=13) (4200/4250=14) (4300/4650=15) (4700/4965=16 > ) > (5000/5940=17) (6005/6130=18) (6200/6940=19) (7000/7630=20) (7700/8965=21 > ) > (9000/9750=22) (9840=23); 540. } ; 541. display "dind"; 542. if `1'<= 1982 { > display "`1' <= 1982: creating dind from ind70"; 543. gen dind=ind70 ; 544. recode dind (18/19=1) (17=2) (47/57=3) (67/77=4) (107/109=5) (118=6) ( > 119/138=7) > (139/149=8) (157/168 258=9) (169=10) (177/198=11) (199/209=12) (219 =13) > (227=14) (228/238=15) (239/257=16) (259=18) (268/298=19) (299=20) > (307/318=21) (319/327=22) (328/337=23) (338/339=24) (347/369=25) > (377/378=26) (379/387=27) (388/398=28) (407/429=29) (447/449=30) (467/479 > =31) > (507/588=32) (607/698=33) (707/709=34) (717/718=35) > (769=36) (727/748=37) (749/759=38) (777/798=39) (807/809=40) (838=41) > (828/837 839/848=42) (877/879=44) (857/868=43) (849 869 887/897= 45) > (027 028 = 46) (907/937=52) ; 545. } ; 546. if `1' <=1991 & `1' >=1983 { > display "replacing dind for `1': `1' <=1991 & `1' >=1983"; 547. gen dind=ind80; 548. recode > dind (12/29=1) (10/11=2) (40/50=3) (60=4) (230/241=5) (242=6) (250/262=7) > (270/280=8) (281/300=9) (301=10) (310/332=11) (340/350=12) > (351=13) (352=14) (360/370=15) (371/382=16) (390=17) (391/392=18) > (100/122=19) (130=20) (132/150=21) (151/152=22) (160/162=23) (171/172=24) > (180/192=25) (200/201=26) (210/212=27) (220/222=28) > (400/432=29) (440/442=30) (450/472=31) (500/571=32) (580/691=33) (700/710 > =34) > (711/712=35) (761=36) (721/750=37) (751/760=38) (762/791=39) (800/810=40) > (831=41) (812/830 832/840=42) (842/860=43) (861/871=44) (841 872/893=45) > (30/32=46) (900/932=52) (991=51); 549. } ; 550. if `1' >= 1992 & `1' <= 2002 { > display "replacing dind for `1': `1' >= 1992 & `1' <= 2002 "; 551. gen dind=ind80; 552. recode > dind (12/30=1) (10/11=2) (40/50=3) (60=4) (230/241=5) (242=6) (250/262=7) > (270/280=8) (281/300=9) (301=10) (310/332=11) (340/350=12) > (351=13) (352=14) (360/370=15) (371/382=16) (390=17) (391/392=18) > (100/122=19) (130=20) (132/150=21) (151/152=22) (160/162=23) (171/172=24) > (180/192=25) (200/201=26) (210/212=27) (220/222=28) > (400/432=29) (440/442=30) (450/472=31) (500/571=32) (580/691=33) > (700/710=34) (711/712=35) (761=36) (721/750=37) (751/760=38) (762/791=39) > (800/810=40) (831=41) (812/830 832/840=42) (842/860=43) > (861/871=44) (841 872/893 =45) > (032 031 =46) > (910 922 932 900 901 921 930 931 =52) > (991=51) ; 553. }; 554. if `1' >= 2000 { > display "replacing dind for `1' >= 2000 " ; 555. gen dind02 = ind02; 556. recode > dind02 (170/180 290=1) (190/280=2) (370/490=3) (770=4) (2470/2590=5) > (2670/2990=6) (3070/3290=7) (3360/3390=8) (3470 3490=9) (3570/3690=10) > (3770/3870=11) (3890=12) (3960/3990=13) (1070/1290=14) (1370 1390=15) > (1470/1790=16) (1870/1990=17) (2070 2090=18) (2170/2290=19) (2370/2390=20 > ) > (4070/4590=21) (4670/5790=22) (6070/6390=23) (570/690=24) (6470/6490=25) > (6570 6590=26) (6670=27) (6672/6675=28) (6680 6690=29) (6692 6695=30) > (6770 6780=31) (6870/6970=32) (6990=33) (7070=34) (7080/7190=35) > (7270/7490=36) (7570=37) (7580/7780=38) (7790=39) (7860/7890=40) > (8190=41) (7970/8180 8270 8290=42) (8370/8470=43) (8560/8590=44) (8660 86 > 70=45) > (8680 8690=46) (8770/8890=47) (8970/9090=48) (9160/9190=49) (9290=50) > (9370/9590=51) (9890=52) ; 557. } ; 558. #delimit cr delimiter now cr . **Wages (If earnings are 0, then wage rate is missing, not zero). . display "Wages" 559. replace paidhr = . if paidhr <=0 560. replace paidhre = . if paidhre <=0 561. replace earnhr = . if earnhr <=0 562. replace earnhre = . if earnhre <=0 563. replace earnwke = . if earnwke < 0 564. if `1' < 1989 { 565. replace eligible = 2 if eligible == . 566. } 567. if `1' >= 1989 { 568. replace eligible = 2 if eligible <= 0 569. replace agri = 0 if agri==2 570. replace agri = . if agri< 0 571. replace untype = . if untype<0 572. } 573. if `1' < 1989 { 574. replace I25a = 0 if I25a ==. 575. replace I25b = 0 if I25b ==. 576. replace I25c = 0 if I25c ==. 577. replace I25d = 0 if I25d ==. 578. replace agri = . if agri< 0 579. } 580. if `1' >= 1994 { 581. replace I25a = 0 if I25a <= 3 582. replace I25b = 0 if I25b <= 3 583. *replace I25a = . if I25a < 0 . *replace I25b = . if I25b < 0 . replace earnhre = . if earnhre ==1 584. *replace uhourse = . if lfsr94 >2 | lfsr94 <1 . ** -4 Hours vary . replace uhourse = . if lfsr94 >2 585. replace lfsr94 = . if lfsr94 < 0 586. replace laydur = . if laydur < 0 587. } 588. if `1' >= 1996 { 589. replace I25c = . if I25c < 0 590. replace I25d = . if I25d < 0 591. } 592. if `1' == 1995 { 593. replace I25c = . if I25c < 0 594. replace I25d = . if I25d < 0 595. replace I25c = . if intmonth < 9 596. replace I25d = . if intmonth < 9 597. } 598. if `1' == 1994 { 599. drop I25c I25d 600. } 601. ** Hours, Unions . display "Hours, Unions" 602. if `1' >= 1994 { 603. replace reason94 = . if reason94< 0 604. replace absent94 = . if absent94< 0 605. replace studftpt = . if studftpt< 0 606. replace schenr = . if schenr < 0 607. replace schlvl = . if schlvl < 0 608. replace ftpt94 = . if ftpt94 < 0 609. replace hourslw = . if hourslw < 0 610. replace hourslw = 99 if hourslw >99 & hourslw != . 611. ** -4 hours vary . *replace uhourse = . if uhourse < 0 . replace why3594 = . if why3594 < 0 612. replace unionmme = . if unionmme< 0 613. replace unioncov = . if unioncov< 0 614. } 615. . ** Save and exit . compress 616. do /homes/data/morg/sources/labels/labels`4' 617. saveold /homes/data/morg/annual/morg`2', version(11) replace 618. summarize 619. clear 620. capture ! /usr/bin/rm -f aef.dct /tmp/aef.raw 621. capture ! /bin/rm -f aef.dct /tmp/aef.raw 622. capture ! /usr/bin/chmod a+r /home/data/morg/annual/morg`2'.dta 623. capture ! /bin/chmod a+r /home/data/morg/annual/morg`2'.dta 624. capture ! /usr/bin/chmod g+w /home/data/morg/annual/morg`2'.dta 625. capture ! /bin/chmod g+w /home/data/morg/annual/morg`2'.dta 626. capture ! /usr/bin/chgrp web /home/data/morg/annual/morg`2'.dta 627. capture ! /bin/chgrp web /home/data/morg/annual/morg`2'.dta 628. end . . *Each block of commands does one year of the data. The data must be . *decompressed, and possibly have dashes converted to blanks. . *Then a dictionary for the particular year is prepared by . *concatenating a one line header (with the file name) to a generic . *dictionary body that covers several years of data that used the . *same format. . *Lastly, the data is read, modified, summarized and saved. . /* > aef2 1979 79 79_83 79_82 > aef2 1980 80 79_83 79_82 > aef2 1981 81 79_83 79_82 > aef2 1982 82 79_83 79_82 > aef2 1983 83 79_83 83 > aef2 1984 84 84_88 84 > aef2 1985 85 84_88 85 > aef2 1986 86 84_88 86_88 > aef2 1987 87 84_88 86_88 > aef2 1988 88 84_88 86_88 > aef2 1989 89 89_93 89_91 > aef2 1990 90 89_93 89_91 > aef2 1991 91 89_93 89_91 > aef2 1992 92 89_93 92_93 > aef2 1993 93 89_93 92_93 > aef2 1994 94 94_97 94 > aef2 1995 95 94_97 95 > aef2 1996 96 94_97 96_97 > aef2 1997 97 94_97 96_97 > aef2 1998 98 98_02 98 > aef2 1999 99 98_02 99 > aef2 2000 00 98_02 00 > aef2 2001 01 98_02 01 > aef2 2002 02 98_02 02 > aef2 2003 03 03 03 > aef2 2004 04 03 04 > aef2 2005 05 03 05 > aef2 2006 06 03 06 > aef2 2007 07 03 07 > aef2 2008 08 03 08 > aef2 2009 09 03 09 > aef2 2010 10 03 10 > aef2 2011 11 03 11 > aef2 2012 12 03 11 > aef2 2013 13 03 13 > aef2 2014 14 03 13 > aef2 2015 15 03 13 > aef2 2016 16 03 13 > aef2 2017 17 03 13 > aef2 2018 18 03 13 > aef2 2019 19 03 13 > */ . aef2 2020 20 03 13 dct_name aef03.dbd raw_name=../raw/morg20 (1,173,068 observations deleted) obs 401156 # of persons with age<=15 129905 # of non-interview records 0 Age | Freq. Percent Cum. ------------+----------------------------------- -1 | 66,756 16.64 16.64 0 | 2,740 0.68 17.32 1 | 3,343 0.83 18.16 2 | 3,616 0.90 19.06 3 | 3,703 0.92 19.98 4 | 4,017 1.00 20.98 5 | 3,934 0.98 21.96 6 | 3,972 0.99 22.95 7 | 4,039 1.01 23.96 8 | 4,133 1.03 24.99 9 | 4,033 1.01 26.00 10 | 4,194 1.05 27.04 11 | 4,220 1.05 28.09 12 | 4,344 1.08 29.18 13 | 4,307 1.07 30.25 14 | 4,321 1.08 31.33 15 | 4,233 1.06 32.38 16 | 4,263 1.06 33.45 17 | 4,306 1.07 34.52 18 | 3,908 0.97 35.49 19 | 3,641 0.91 36.40 20 | 3,639 0.91 37.31 21 | 3,556 0.89 38.19 22 | 3,710 0.92 39.12 23 | 3,573 0.89 40.01 24 | 3,533 0.88 40.89 25 | 3,780 0.94 41.83 26 | 3,823 0.95 42.79 27 | 3,893 0.97 43.76 28 | 4,049 1.01 44.77 29 | 4,096 1.02 45.79 30 | 4,385 1.09 46.88 31 | 4,178 1.04 47.92 32 | 4,309 1.07 49.00 33 | 4,257 1.06 50.06 34 | 4,301 1.07 51.13 35 | 4,458 1.11 52.24 36 | 4,349 1.08 53.32 37 | 4,355 1.09 54.41 38 | 4,294 1.07 55.48 39 | 4,319 1.08 56.56 40 | 4,385 1.09 57.65 41 | 4,116 1.03 58.68 42 | 4,053 1.01 59.69 43 | 3,943 0.98 60.67 44 | 4,029 1.00 61.67 45 | 4,041 1.01 62.68 46 | 3,830 0.95 63.64 47 | 3,953 0.99 64.62 48 | 4,035 1.01 65.63 49 | 4,168 1.04 66.67 50 | 4,367 1.09 67.75 51 | 4,283 1.07 68.82 52 | 4,122 1.03 69.85 53 | 4,079 1.02 70.87 54 | 4,228 1.05 71.92 55 | 4,598 1.15 73.07 56 | 4,532 1.13 74.20 57 | 4,676 1.17 75.36 58 | 4,592 1.14 76.51 59 | 4,812 1.20 77.71 60 | 4,872 1.21 78.92 61 | 4,731 1.18 80.10 62 | 4,758 1.19 81.29 63 | 4,757 1.19 82.47 64 | 4,577 1.14 83.61 65 | 4,599 1.15 84.76 66 | 4,278 1.07 85.83 67 | 4,274 1.07 86.89 68 | 4,086 1.02 87.91 69 | 3,883 0.97 88.88 70 | 3,887 0.97 89.85 71 | 3,699 0.92 90.77 72 | 3,788 0.94 91.71 73 | 3,653 0.91 92.62 74 | 2,918 0.73 93.35 75 | 2,699 0.67 94.02 76 | 2,639 0.66 94.68 77 | 2,444 0.61 95.29 78 | 2,213 0.55 95.84 79 | 2,042 0.51 96.35 80 | 7,640 1.90 98.26 85 | 6,997 1.74 100.00 ------------+----------------------------------- Total | 401,156 100.00 no observations Age | Freq. Percent Cum. ------------+----------------------------------- -1 | 66,756 51.39 51.39 0 | 2,740 2.11 53.50 1 | 3,343 2.57 56.07 2 | 3,616 2.78 58.85 3 | 3,703 2.85 61.71 4 | 4,017 3.09 64.80 5 | 3,934 3.03 67.83 6 | 3,972 3.06 70.88 7 | 4,039 3.11 73.99 8 | 4,133 3.18 77.17 9 | 4,033 3.10 80.28 10 | 4,194 3.23 83.51 11 | 4,220 3.25 86.76 12 | 4,344 3.34 90.10 13 | 4,307 3.32 93.42 14 | 4,321 3.33 96.74 15 | 4,233 3.26 100.00 ------------+----------------------------------- Total | 129,905 100.00 (129,905 observations deleted) (0 observations deleted) obs 271251 after keeping age>15&age!=. infile successful no observations (26 real changes made, 26 to missing) (234,456 real changes made, 234,456 to missing) (244,021 real changes made, 244,021 to missing) (0 real changes made) (0 real changes made) (131,107 real changes made) (0 real changes made) (0 real changes made) (0 real changes made) (140,144 real changes made) Geography (102,212 real changes made) dropping cmsacode msafips smsa93 smsasize = . if smsasize <=0 (200,529 real changes made, 200,529 to missing) inlisting 96 97 replace smsastat = . if smsastat==3 | smsastat<0 (2,719 real changes made, 2,719 to missing) (0 real changes made) replace centcity = . if centcity==4 | centcity<=0 (47,248 real changes made, 47,248 to missing) (237,240 real changes made, 237,240 to missing) replace smsasize=. if smsasize<=0 drop smsasize Demography (131,059 real changes made, 131,059 to missing) if 2020 > 1983 & 2020 < 1989 { (0 real changes made) (0 real changes made) (0 real changes made) (ch02: 57190 changes made) (ch35: 63522 changes made) (ch613: 63522 changes made) (ch1417: 63522 changes made) (11,944 real changes made) (0 real changes made) (194,918 real changes made, 194,918 to missing) (264,556 real changes made, 264,556 to missing) (198,371 real changes made, 198,371 to missing) (271,251 real changes made, 271,251 to missing) (271,251 real changes made, 271,251 to missing) (271,251 real changes made, 271,251 to missing) (271,251 missing values generated) (700 real changes made) (1,252 real changes made) (2,534 real changes made) (3,420 real changes made) (4,346 real changes made) (6,865 real changes made) (8,262 real changes made) (3,816 real changes made) (39 real changes made) (132 real changes made) (53 real changes made) (355 real changes made) (707 real changes made) (1,528 real changes made) (2,202 real changes made) (1,679 real changes made) (69,638 real changes made) (6,870 real changes made) (16,931 real changes made) (36,299 real changes made) (7,836 real changes made) (4,944 real changes made) (0 real changes made) (0 real changes made) (0 real changes made) (0 real changes made) (0 real changes made) (8,900 real changes made) (192,493 real changes made, 192,493 to missing) (259,252 real changes made, 259,252 to missing) (0 real changes made) (0 real changes made) (0 real changes made) (0 real changes made) (0 real changes made) (236,381 real changes made, 236,381 to missing) (0 real changes made) (250,746 real changes made, 250,746 to missing) (267,121 real changes made, 267,121 to missing) (270,315 real changes made, 270,315 to missing) (271,133 real changes made, 271,133 to missing) Employment (3,395 real changes made, 3,395 to missing) (265,686 real changes made, 265,686 to missing) (137,580 real changes made, 137,580 to missing) (100,017 real changes made, 100,017 to missing) (100,017 real changes made, 100,017 to missing) (100,017 real changes made, 100,017 to missing) docc80 ** The renaming is part of the Census reweighting ; docc00 553 generate int docc00=occ2011; 568 572 577 (100,017 missing values generated) 581 recode docc00 2011 (docc00: 161089 changes made) dind (100,017 missing values generated) (dind02: 155525 changes made) Wages (137,580 real changes made, 137,580 to missing) (0 real changes made) (197,185 real changes made, 197,185 to missing) (0 real changes made) (0 real changes made) (137,580 real changes made) (167,817 real changes made) (100,017 real changes made, 100,017 to missing) (259,252 real changes made, 259,252 to missing) (120,572 real changes made) (137,580 real changes made) (0 real changes made) (119,444 real changes made, 119,444 to missing) (1,128 real changes made, 1,128 to missing) (265,250 real changes made, 265,250 to missing) (197,150 real changes made, 197,150 to missing) (137,580 real changes made, 137,580 to missing) Hours, Unions (257,930 real changes made, 257,930 to missing) (264,394 real changes made, 264,394 to missing) (248,056 real changes made, 248,056 to missing) (113,761 real changes made, 113,761 to missing) (248,056 real changes made, 248,056 to missing) (1,128 real changes made, 1,128 to missing) (127,429 real changes made, 127,429 to missing) (86 real changes made) (234,717 real changes made, 234,717 to missing) (137,580 real changes made, 137,580 to missing) (151,702 real changes made, 151,702 to missing) variable spouse was int now byte variable hourslw was int now byte variable laydur was int now byte variable ym_file was float now int variable ym was float now int variable ch02 was int now byte variable ch35 was int now byte variable ch613 was int now byte variable ch1417 was int now byte variable ch05 was int now byte variable dind02 was float now int (3,797,514 bytes saved) . *by Jean Roth Thu Mar 17 2005 14:38:42 . *Please report errors to jroth@nber.org . . * Note: Variable names in Stata are case-sensitive . #delimit ; delimiter now ; . ; . * minsamp: 1979-; . label values minsamp P2L; . label define P2L > 4 "MIS 4" > 8 "MIS 8" > ; . * hrlonglk: 1994-; . label values hrlonglk P3L; . label define P3L > 0 "MIS 1 Or Replacement HH (no" > 2 "MIS 2-4 Or MIS 6-8 (link To" > ; . * intmonth: 1979-; . label values intmonth P4L; . label define P4L > 1 "January" > 2 "February" > 3 "March" > 4 "April" > 5 "May" > 6 "June" > 7 "July" > 8 "August" > 9 "September" > 10 "October" > 11 "November" > 12 "December" > ; . * stfips: 1989-; . label values stfips stfips; . label define stfips > 1 "AL" > 2 "AK" > 4 "AZ" > 5 "AR" > 6 "CA" > 8 "CO" > 9 "CT" > 10 "DE" > 11 "DC" > 12 "FL" > 13 "GA" > 15 "HI" > 16 "ID" > 17 "IL" > 18 "IN" > 19 "IA" > 20 "KS" > 21 "KY" > 22 "LA" > 23 "ME" > 24 "MD" > 25 "MA" > 26 "MI" > 27 "MN" > 28 "MS" > 29 "MO" > 30 "MT" > 31 "NE" > 32 "NV" > 33 "NH" > 34 "NJ" > 35 "NM" > 36 "NY" > 37 "NC" > 38 "ND" > 39 "OH" > 40 "OK" > 41 "OR" > 42 "PA" > 44 "RI" > 45 "SC" > 46 "SD" > 47 "TN" > 48 "TX" > 49 "UT" > 50 "VT" > 51 "VA" > 53 "WA" > 54 "WV" > 55 "WI" > 56 "WY" > ; . * state: 1979- April 2014 ; . cap label values state P27L; . cap label define P27L > 11 "ME" > 12 "NH" > 13 "VT" > 14 "MA" > 15 "RI" > 16 "CT" > 21 "NY" > 22 "NJ" > 23 "PA" > 31 "OH" > 32 "IN" > 33 "IL" > 34 "MI" > 35 "WI" > 41 "MN" > 42 "IA" > 43 "MO" > 44 "ND" > 45 "SD" > ; . * penatvty: 2007-; . label values penatvty penatvty; . label define penatvty > 57 "United States" > 60 "American Samoa" > 66 "Guam" > 73 "Puerto Rico" > 78 "U.S. Virgin Islands" > 96 "U.S. Outlying Area" > 100 "Albania" > 102 "Austria" > 103 "Belgium" > 104 "Bulgaria" > 105 "Czechoslovakia" > 106 "Denmark" > 108 "Finland" > 109 "France" > 110 "Germany" > 116 "Greece" > 117 "Hungary" > 119 "Ireland/Eire" > 120 "Italy" > 126 "Holland/Netherlands" > 127 "Norway" > 128 "Poland" > 129 "Portugal" > 130 "Azores" > 132 "Romania" > 134 "Spain" > 136 "Sweden" > 137 "Switzerland" > 138 "United Kingdom/Great Britain" > 139 "England" > 140 "Scotland" > 141 "Wales" > 142 "Northern Ireland" > 147 "Yugoslavia" > 148 "Czech Republic" > 149 "Slovakia" > 150 "Bosnia & Herzegovina" > 151 "Croatia" > 152 "Macedonia" > 154 "Serbia" > 156 "Latvia" > 157 "Lithuania" > 158 "Armenia" > 159 "Azerbaijan" > 160 "Belarus" > 161 "Georgia" > 162 "Moldova" > 163 "Russia" > 164 "Ukraine" > 165 "USSR" > 166 "Europe, not specified" > 167 "Kosovo" > 200 "Afghanistan" > 202 "Bangladesh" > 205 "Myanmar (Burma)" > 206 "Cambodia" > 207 "China" > 208 "Cyprus" > 209 "Hong Kong" > 210 "India" > 211 "Indonesia" > 212 "Iran" > 213 "Iraq" > 214 "Israel" > 215 "Japan" > 216 "Jordan" > 217 "Korea" > 220 "South Korea" > 222 "Kuwait" > 223 "Laos" > 224 "Lebanon" > 226 "Malaysia" > 229 "Nepal" > 231 "Pakistan" > 233 "Philippines" > 235 "Saudi Arabia" > 236 "Singapore" > 238 "Sri Lanka" > 239 "Syria" > 240 "Taiwan" > 242 "Thailand" > 243 "Turkey" > 246 "Uzbekistan" > 247 "Vietnam" > 248 "Yemen" > 249 "Asia, not specified" > 300 "Bermuda" > 301 "Canada" > 303 "Mexico" > 310 "Belize" > 311 "Costa Rica" > 312 "El Salvador" > 313 "Guatemala" > 314 "Honduras" > 315 "Nicaragua" > 316 "Panama" > 318 "Central America" > 321 "Antigua and Barbuda" > 323 "Bahamas" > 324 "Barbados" > 327 "Cuba" > 328 "Dominica" > 329 "Dominican Republic" > 330 "Grenada" > 332 "Haiti" > 333 "Jamaica" > 338 "St. Kitts-Nevis" > 339 "St. Lucia" > 340 "St. Vincent and the Grenadines" > 341 "Trinidad and Tobago" > 343 "West Indes, not specified" > 360 "Argentina" > 361 "Bolivia" > 362 "Brazil" > 363 "Chile" > 364 "Colombia" > 365 "Ecuador" > 368 "Guyana" > 369 "Paraguay" > 370 "Peru" > 372 "Uruguay" > 373 "Venezuela" > 374 "South America, not specified" > 399 "Americas, not specified" > 400 "Algeria" > 407 "Cameroon" > 408 "Cape Verde" > 414 "Egypt" > 416 "Ethiopia" > 417 "Eritrea" > 421 "Ghana" > 427 "Kenya" > 429 "Liberia" > 436 "Morocco" > 440 "Nigeria" > 444 "Senegal" > 447 "Sierra Leone" > 448 "Somalia" > 449 "South Africa" > 451 "Sudan" > 453 "Tanzania" > 457 "Uganda" > 461 "Zimbabwe" > 462 "Africa, not specified" > 501 "Australia" > 508 "Fiji" > 515 "New Zealand" > 523 "Tonga" > 527 "Samoa" > 528 "Oceania, not specified" > 555 "Elsewhere" > ; . * pemntvty: 2007-; . label values pemntvty penatvty; . * pefntvty: 2007-; . label values pefntvty penatvty; . * prcitshp: 1994-; . label values prcitshp P16L; . label define P16L > 1 "Native, Born In US" > 2 "Native, Born in PR or US Outlying Area" > 3 "Native, Born Abroad Of US Parent(s)" > 4 "Foreign Born, US Cit By Naturalization" > 5 "Foreign Born, Not a US Citizen" > ; . * prcitflg: 1994-; . label values prcitflg P34L; . label define P34L > 0 "Value - No Change" > 1 "Blank - No Change" > 2 "Don't Know - No Change" > 3 "Refused - No Change" > 10 "Value To Value" > 11 "Blank To Value" > 12 "Don't Know To Value" > 13 "Refused To Value" > 20 "Value To Longitudinal Value" > 21 "Blank To Longitudinal Value" > 22 "Don't Know To Longitudinal Value" > 23 "Refused To Longitudinal Value" > 30 "Value to Allocated Value Long." > 31 "Blank to Allocated Value Long." > 32 "Don't Know to Allocated Value Long." > 33 "Refused to Allocated Value Long." > 40 "Value To Allocated Value" > 41 "Blank To Allocated Value" > 42 "Don't Know To Allocated Value" > 43 "Refused To Allocated Value" > 50 "Value To Blank" > 52 "Don't Know To Blank" > 53 "Refused To Blank" > ; . * meanings of last few codes of peinusyr change every year!!!; . * peinusyr: 2003-; . label values peinusyr P17L; . label define P17L > -1 "Not In Universe (Born In U.S.)" > 0 "Not Foreign Born" > 1 "Before 1950" > 2 "1950-1959" > 3 "1960-1964" > 4 "1965-1969" > 5 "1970-1974" > 6 "1975-1979" > 7 "1980-1981" > 8 "1982-1983" > 9 "1984-1985" > 10 "1986-1987" > 11 "1988-1989" > 12 "1990-1991" > 13 "1992-1995" > 14 "1994-1995" > 15 "1996-1997" > 16 "1998-1999" > 17 "2000-2001" > 18 "2002-2003" > 19 "2004-2005" > 20 "2006-2007" > 21 "2008-2009" > 22 "2010-2012" > ; . * paidhre: 1979-; . label values paidhre P18L; . label define P18L > 1 "Yes" > 2 "No" > ; . * I25a: 1979-; . label values I25a P28L; . label define P28L > 0 "Value - No Change" > 1 "Blank - No Change" > 2 "Don't Know - No Change" > 3 "Refused - No Change" > 10 "Value To Value" > 11 "Blank To Value" > 12 "Don't Know To Value" > 13 "Refused To Value" > 20 "Value To Longitudinal Value" > 21 "Blank To Longitudinal Value" > 22 "Don't Know To Longitudinal Value" > 23 "Refused To Longitudinal Value" > 30 "Value to Allocated Value Long." > 31 "Blank to Allocated Value Long." > 32 "Don't Know to Allocated Value Long." > 33 "Refused to Allocated Value Long." > 40 "Value To Allocated Value" > 41 "Blank To Allocated Value" > 42 "Don't Know To Allocated Value" > 43 "Refused To Allocated Value" > 50 "Value To Blank" > 52 "Don't Know To Blank" > 53 "Refused To Blank" > ; . * I25b: 1979-; . label values I25b P29L; . label define P29L > 0 "Value - No Change" > 1 "Blank - No Change" > 2 "Don't Know - No Change" > 3 "Refused - No Change" > 10 "Value To Value" > 11 "Blank To Value" > 12 "Don't Know To Value" > 13 "Refused To Value" > 20 "Value To Longitudinal Value" > 21 "Blank To Longitudinal Value" > 22 "Don't Know To Longitudinal Value" > 23 "Refused To Longitudinal Value" > 30 "Value to Allocated Value Long." > 31 "Blank to Allocated Value Long." > 32 "Don't Know to Allocated Value Long." > 33 "Refused to Allocated Value Long." > 40 "Value To Allocated Value" > 41 "Blank To Allocated Value" > 42 "Don't Know To Allocated Value" > 43 "Refused To Allocated Value" > 50 "Value To Blank" > 52 "Don't Know To Blank" > 53 "Refused To Blank" > ; . * I25c: 1996-; . label values I25c I25c; . label define I25c > 0 "No Components Allocated" > 1 "1 or more components Allocated" > ; . * I25d: 1996-; . label values I25d I25d; . label define I25d > 0 "No Components Allocated" > 1 "1 or more components Allocated" > ; . * class94: 1994-; . label values class94 P19L; . label define P19L > 1 "Government - Federal" > 2 "Government - State" > 3 "Government - Local" > 4 "Private, For Profit" > 5 "Private, Nonprofit" > 6 "Self-Employed, Incorporated" > 7 "Self-Employed, Unincorporated" > 8 "Without Pay" > ; . * lfsr94: 1994-; . label values lfsr94 P20L; . label define P20L > 1 "Employed-At Work" > 2 "Employed-Absent" > 3 "Unemployed-On Layoff" > 4 "Unemployed-Looking" > 5 "Retired-Not In Labor Force" > 6 "Disabled-Not In Labor Force" > 7 "Other-Not In Labor Force" > ; . * ind02: 2000-; . label values ind02 ind02; . label define ind02 > 170 "Crop production (111)" > 180 "Animal production (112)" > 190 "Forestry except logging (1131, 1132)" > 270 "Logging (1133)" > 280 "Fishing, hunting, and trapping (114)" > 290 "Support activities for agriculture and forestry (115)" > 370 "Oil and gas extraction (211)" > 380 "Coal mining (2121)" > 390 "Metal ore mining (2122)" > 470 "Nonmetallic mineral mining and quarrying (2123)" > 480 "Not specified type of mining (Part of 21)" > 490 "Support activities for mining (213)" > 570 "Electric power generation, transmission and distribution > (Pt. 2211)" > 580 "Natural gas distribution (Pt.s2212)" > 590 "Electric and gas, and other combinations (Pts. 2211, 221 > 2)" > 670 "Water, steam, air-conditioning, and irrigation systems ( > 22131, 22133)" > 680 "Sewage treatment facilities (22132)" > 690 "Not specified utilities (Part of 22)" > 770 "** Construction (23)" > 1070 "Animal food, grain and oilseed milling (3111, 3112)" > 1080 "Sugar and confectionery products (3113)" > 1090 "Fruit and vegetable preserving and specialty food manufa > cturing (3114)" > 1170 "Dairy product manufacturing (3115)" > 1180 "Animal slaughtering and processing (3116)" > 1190 "Retail bakeries (311811)" > 1270 "Bakeries, except retail (3118 exc. 311811)" > 1280 "Seafood and other miscellaneous foods, n.e.c. (3117, 311 > 9)" > 1290 "Not specified food industries (Part of 311)" > 1370 "Beverage manufacturing (3121)" > 1390 "Tobacco manufacturing (3122)" > 1470 "Fiber, yarn, and thread mills (3131)" > 1480 "Fabric mills, except knitting (3132 exc. 31324)" > 1490 "Textile and fabric finishing and coating mills (3133)" > 1570 "Carpet and rug mills (31411)" > 1590 "Textile product mills, except carpets and rugs (314 exc. > 31411)" > 1670 "Knitting mills (31324, 3151)" > 1680 "Cut and sew apparel manufacturing (3152)" > 1690 "Apparel accessories and other apparel manufacturing (315 > 9)" > 1770 "Footwear manufacturing (3162)" > 1790 "Leather tanning and products, except footwear manufactur > ing (3161, 3169)" > 1870 "Pulp, paper, and paperboard mills (3221)" > 1880 "Paperboard containers and boxes (32221)" > 1890 "Miscellaneous paper and pulp products (32222,32223, 3222 > 9)" > 1990 "Printing and related support activities (3231)" > 2070 "Petroleum refining (32411)" > 2090 "Miscellaneous petroleum and coal products (32419)" > 2170 "Resin, synthetic rubber and fibers, and filaments manufa > cturing (3252)" > 2180 "Agricultural chemical manufacturing (3253)" > 2190 "Pharmaceutical and medicine manufacturing (3254)" > 2270 "Paint, coating, and adhesive manufacturing B46 (3255)" > 2280 "Soap, cleaning compound, and cosmetics manufacturing (32 > 56)" > 2290 "Industrial and miscellaneous chemicals (3251, 3259)" > 2370 "Plastics product manufacturing (3261)" > 2380 "Tire manufacturing (32621)" > 2390 "Rubber products, except tires, manufacturing (32622, 326 > 29)" > 2470 "Pottery, ceramics, and related products manufacturing (3 > 2711)" > 2480 "Structural clay product manufacturing (32712)" > 2490 "Glass and glass product manufacturing (3272)" > 2570 "Cement, concrete, lime, and gypsum product manufacturing > (3273, 3274)" > 2590 "Miscellaneous nonmetallic mineral product manufacturing > (3279)" > 2670 "Iron and steel mills and steel product manufacturing (33 > 11, 3312)" > 2680 "Aluminum production and processing (3313)" > 2690 "Nonferrous metal, except aluminum, production and proces > sing (3314)" > 2770 "Foundries (3315)" > 2780 "Metal forgings and stampings (3321)" > 2790 "Cutlery and hand tool manufacturing (3322)" > 2870 "Structural metals, and tank and shipping container manuf > acturing (3323, 3324)" > 2880 "Machine shops; turned product; screw, nut and bolt manuf > acturing (3327)" > 2890 "Coating, engraving, heat treating and allied activities > (3328)" > 2970 "Ordnance (332992 to 332995)" > 2980 "Miscellaneous fabricated metal products manufacturing (3 > 325, 3326, 3329 exc. 332992, 332993, 332994, 332995)" > 2990 "Not specified metal industries (Part of 331 and 332)" > 3070 "Agricultural implement manufacturing (33311)" > 3080 "Construction, mining and oil field machinery manufacturi > ng (33312, 33313)" > 3090 "Commercial and service industry machinery manufacturing > (3333)" > 3170 "Metalworking machinery manufacturing (3335)" > 3180 "Engines, turbines, and power transmission equipment manu > facturing (3336)" > 3190 "Machinery manufacturing, n.e.c. (3332, 3334, 3339)" > 3290 "Not specified machinery manufacturing (Part of 333)" > 3360 "Computer and peripheral equipment manufacturing (3341)" > 3370 "Communications, audio, and video equipment manufacturing > (3342, 3343)" > 3380 "Navigational, measuring, electromedical, and control ins > truments manufacturing (3345)" > 3390 "Electronic component and product manufacturing, n.e.c. ( > 3344, 3346)" > 3470 "Household appliance manufacturing (3352)" > 3490 "Electrical lighting, equipment, and supplies manufacturi > ng, n.e.c. (3351, 3353, 3359)" > 3570 "Motor vehicles and motor vehicle equipment manufacturing > (3361, 3362, 3363)" > 3580 "Aircraft and parts manufacturing (336411 to 336413)" > 3590 "Aerospace products and parts manufacturing (336414, 3364 > 15, 336419)" > 3670 "Railroad rolling stock manufacturing (3365)" > 3680 "Ship and boat building (3366)" > 3690 "Other transportation equipment manufacturing (3369)" > 3770 "Sawmills and wood preservation (3211)" > 3780 "Veneer, plywood, and engineered wood products (3212)" > 3790 "Prefabricated wood buildings and mobile homes (321991, 3 > 21992)" > 3870 "Miscellaneous wood products (3219 exc. 321991, 321992)" > 3890 "Furniture and related product manufacturing (337)" > 3960 "Medical equipment and supplies manufacturing (3391)" > 3970 "Toys, amusement, and sporting goods manufacturing (33992 > , 33993)" > 3980 "Miscellaneous manufacturing, n.e.c. (3399 exc. 33992, 33 > 993)" > 3990 "Not specified manufacturing industries (Part of 31, 32, > 33)" > 4070 "** Motor vehicles, parts and supplies, merchant wholesal > ers (*4231)" > 4080 "** Furniture and home furnishing, merchant wholesalers ( > *4232)" > 4090 "** Lumber and other construction materials, merchant who > lesalers (*4233)" > 4170 "** Professional and commercial equipment and supplies, m > erchant wholesalers (*4234)" > 4180 "** Metals and minerals, except petroleum, merchant whole > salers (*4235)" > 4190 "** Electrical goods, merchant wholesalers (*4236)" > 4260 "** Hardware, plumbing and heating equipment, and supplie > s, merchant wholesalers (*4237)" > 4270 "** Machinery, equipment, and supplies, merchant wholesal > ers (*4238)" > 4280 "** Recyclable material, merchant wholesalers (*42393)" > 4290 "** Miscellaneous durable goods, merchant wholesalers (*4 > 239 exc. 42393)" > 4370 "** Paper and paper products, merchant wholesalers (*4241 > )" > 4380 "** Drugs, sundries, and chemical and allied products, me > rchant (wholesalerss*4242, 4246)" > 4390 "** Apparel, fabrics, and notions, merchant wholesalers ( > *4243)" > 4470 "** Groceries and related products, merchant wholesalers > (*4244)" > 4480 "** Farm product raw materials, merchant wholesalers (*42 > 45)" > 4490 "** Petroleum and petroleum products, merchant wholesaler > s (*4247)" > 4560 "** Alcoholic beverages, merchant wholesalers (*4248)" > 4570 "** Farm supplies, merchant wholesalers (*42491)" > 4580 "** Miscellaneous (nondurable goods, merchant wholesalers > s*4249 exc. 42491)" > 4585 "*** Wholesale electronic markets, agents and brokers New > industry (*4251)" > 4590 "**Not specified wholesale trade (Part of 42)" > 4670 "Automobile dealers (4411)" > 4680 "Other motor vehicle dealers (4412)" > 4690 "Auto parts, accessories, and tire stores (4413)" > 4770 "Furniture and home furnishings stores (442)" > 4780 "Household appliance stores (443111)" > 4790 "Radio, TV, and computer stores (443112, 44312)" > 4870 "Building material and supplies dealers (4441 exc. 44413) > " > 4880 "Hardware stores (44413)" > 4890 "Lawn and garden equipment and supplies stores (4442)" > 4970 "Grocery stores (4451)" > 4980 "Specialty food stores (4452)" > 4990 "Beer, wine, and liquor stores (4453)" > 5070 "Pharmacies and drug stores (44611)" > 5080 "Health and personal care, except drug, stores (446 exc. > 44611)" > 5090 "Gasoline stations (447)" > 5170 "Clothing and accessories, except shoe, stores (448 exc. > 44821, 4483)" > 5180 "Shoe stores (44821)" > 5190 "Jewelry, luggage, and leather goods stores (4483)" > 5270 "Sporting goods, camera, and hobby and toy stores (44313, > 45111, 45112)" > 5280 "Sewing, needlework, and piece goods stores (45113)" > 5290 "Music stores (45114, 45122)" > 5370 "Book stores and news dealers (45121)" > 5380 "****Department stores and discount stores (s45211)" > 5390 "Miscellaneous general merchandise stores (4529)" > 5470 "Retail florists (4531)" > 5480 "Office supplies and stationery stores (45321)" > 5490 "Used merchandise stores (4533)" > 5570 "Gift, novelty, and souvenir shops (45322)" > 5580 "Miscellaneous retail stores (4539)" > 5590 "*** Electronic shopping (New industry *454111)" > 5591 "*** Electronic auctions (New industrys*454112)" > 5592 "** Mail order houses (*454113)" > 5670 "Vending machine operators (4542)" > 5680 "Fuel dealers (45431)" > 5690 "Other direct selling establishments (45439)" > 5790 "Not specified retail trade (Part of 44, 45)" > 6070 "Air transportation (481)" > 6080 "Rail transportation (482)" > 6090 "Water transportation (483)" > 6170 "Truck transportation (484)" > 6180 "Bus service and urban transit (4851, 4852, 4854, 4855, 4 > 859)" > 6190 "Taxi and limousine service (4853)" > 6270 "Pipeline transportation (486)" > 6280 "Scenic and sightseeing transportation (487)" > 6290 "Services incidental to transportation (488)" > 6370 "Postal Service (491)" > 6380 "Couriers and messengers (492)" > 6390 "Warehousing and storage (493)" > 6470 "**Newspaper publishers (51111)" > 6480 "**Publishing, except newspapers and software (5111 exc. > 51111)" > 6490 "Software publishing (5112)" > 6570 "Motion pictures and video industries (5121)" > 6590 "Sound recording industries (5122)" > 6670 "Radio and television broadcasting and cable (5151, 5152, > 5175)" > 6672 "Internet publishing and broadcasting and web search port > als (51913)" > 6675 "*** Internet publishing and broadcasting (New industrys* > 5161)" > 6680 "Wired telecommunications carriers (*5171)" > 6690 "Other telecommunications services (*517 exc. 5171, 5175) > " > 6692 "*** Internet service providers New industry (*5181)" > 6695 "**** Data processing, hosting, and related services (*51 > 82)" > 6770 "Libraries and archives (*51912)" > 6780 "Other information services (*5191 exc. 51912)" > 6870 "Banking and related activities (521, 52211,52219)" > 6880 "Savings institutions, including credit unions (52212, 52 > 213)" > 6890 "Non-depository credit and related activities (5222, 5223 > )" > 6970 "Securities, commodities, funds, trusts, and other financ > ial investments (523, 525)" > 6990 "Insurance carriers and related activities (524)" > 7070 "Real estate (531)" > 7080 "Automotive equipment rental and leasing (5321)" > 7170 "Video tape and disk rental (53223)" > 7180 "Other consumer goods rental (53221, 53222, 53229, 5323)" > 7190 "Commercial, industrial, and other intangible assets rent > al and leasing (5324, 533)" > 7270 "Legal services (5411)" > 7280 "Accounting, tax preparation, bookkeeping, and payroll se > rvices (5412)" > 7290 "Architectural, engineering, and related services (5413)" > 7370 "Specialized design services (5414)" > 7380 "Computer systems design and related services (5415)" > 7390 "Management, scientific, and technical consulting service > s (5416)" > 7460 "Scientific research and development services (5417)" > 7470 "Advertising and related services (5418)" > 7480 "Veterinary services (54194)" > 7490 "Other professional, scientific, and technical services ( > 5419 exc. 54194)" > 7570 "Management of companies and enterprises (551)" > 7580 "Employment services (5613)" > 7590 "Business support services (5614)" > 7670 "Travel arrangements and reservation services (5615)" > 7680 "Investigation and security services (5616)" > 7690 "** Services to buildings and dwellings (5617 exc. 56173) > " > 7770 "Landscaping services (56173)" > 7780 "Other administrative and other support services (5611, 5 > 612, 5619)" > 7790 "Waste management and remediation services (562)" > 7860 "Elementary and secondary schools (6111)" > 7870 "Colleges and universities, including junior colleges (61 > 12, 6113)" > 7880 "Business, technical, and trade schools and training (611 > 4, 6115)" > 7890 "Other schools, instruction, and educational services (61 > 16, 6117)" > 7970 "Offices of physicians (6211)" > 7980 "Offices of dentists (6212)" > 7990 "Offices of chiropractors (62131)" > 8070 "Offices of optometrists (62132)" > 8080 "Offices of other health practitioners (6213 exc. 62131, > 62132)" > 8090 "Outpatient care centers (6214)" > 8170 "Home health care services (6216)" > 8180 "Other health care services (6215, 6219)" > 8190 "Hospitals (622)" > 8270 "Nursing care facilities (6231)" > 8290 "Residential care facilities, without nursing (6232, 6233 > , 6239)" > 8370 "Individual and family services (6241)" > 8380 "Community food and housing, and emergency services (6242 > )" > 8390 "Vocational rehabilitation services (6243)" > 8470 "Child day care services (6244)" > 8560 "Independent artists, performing arts, spectator sports, > and related industries (711)" > 8570 "Museums, art galleries, historical sites, and similar in > stitutions (712)" > 8580 "Bowling centers (71395)" > 8590 "Other amusement, gambling, and recreation industries (71 > 3 exc. 71395)" > 8660 "Traveler accommodation (7211)" > 8670 "Recreational vehicle parks and camps, and rooming and bo > arding houses (7212, 7213)" > 8680 "Restaurants and other food services (722 exc. 7224)" > 8690 "Drinking places, alcoholic beverages (7224)" > 8770 "Automotive repair and maintenance (8111 exc. 811192)" > 8780 "Car washes (811192)" > 8790 "Electronic and precision equipment repair and maintenanc > e (8112)" > 8870 "Commercial and industrial machinery and equipment repair > and maintenance (8113)" > 8880 "Personal and household goods repair and maintenance (811 > 4 exc. 81143)" > 8890 "Footwear and leather goods repair (81143)" > 8970 "Barber shops (812111)" > 8980 "Beauty salons (812112)" > 8990 "Nail salons and other personal care services (812113, 81 > 219)" > 9070 "Drycleaning and laundry services (8123)" > 9080 "Funeral homes, cemeteries, and crematories (8122)" > 9090 "Other personal services (8129)" > 9160 "Religious organizations (8131)" > 9170 "Civic, social, advocacy organizations, and grantmaking a > nd giving services (8132, 8133, 8134)" > 9180 "Labor unions (81393)" > 9190 "Business, professional, political, and similar organizat > ions (8139 exc. 81393)" > 9290 "Private households (814)" > 9370 "Executive offices and legislative bodies (92111, 92112, > 92114, pt. 92115)" > 9380 "Public finance activities (92113)" > 9390 "Other general government and support (92119)" > 9470 "Justice, public order, and safety activities (922, pt. 9 > 2115)" > 9480 "Administration of human resource programs (923)" > 9490 "Administration of environmental quality and housing prog > rams (924, 925)" > 9570 "Administration of economic programs and space research ( > 926, 927)" > 9590 "National security and international affairs (928)" > 9890 "Armed Forces" > 9970 "Problem referral" > 9990 "Uncodable ((Includes Refused or reported Classified))" > 9670 "U. S. Army" > 9680 "U. S. Air Force" > 9690 "U. S. Navy" > 9770 "U. S. Marines" > 9780 "U. S. Coast Guard" > 9790 "U. S. Armed Forces, Branch Not Specified" > 9870 "Military Reserves or National Guard" > ; . *dind02: 2000-; . label values dind02 dind02; . label define dind02 > 1 "Agriculture" > 2 "Forestry, logging, fishing, hunting, and trapping" > 3 "Mining" > 4 "Construction" > 5 "Nonmetallic mineral products" > 6 "Primary metals and fabricated metal products" > 7 "Machinery manufacturing" > 8 "Computer and electronic products" > 9 "Electrical equipment, appliance manufacturing" > 10 "Transportation equipment manufacturing" > 11 "Wood products" > 12 "Furniture and fixtures manufacturing" > 13 "Miscellaneous and not specified manufacturing" > 14 "Food manufacturing" > 15 "Beverage and tobacco products" > 16 "Textile, apparel, and leather manufacturing" > 17 "Paper and printing" > 18 "Petroleum and coal products" > 19 "Chemical manufacturing" > 20 "Plastics and rubber products" > 21 "Wholesale trade" > 22 "Retail trade" > 23 "Transportation and warehousing" > 24 "Utilities" > 25 "Publishing industries (except internet)" > 26 "Motion picture and sound recording industries" > 27 "Broadcasting (except internet)" > 28 "Internet publishing and broadcasting" > 29 "Telecommunications" > 30 "Internet service providers and data processing services > " > 31 "Other information services" > 32 "Finance" > 33 "Insurance" > 34 "Real Estate" > 35 "Rental and leasing services" > 36 "Professional and Technical services" > 37 "Management of companies and enterprises" > 38 "Administrative and support services" > 39 "Waste management and remediation services" > 40 "Educational services" > 41 "Hospitals" > 42 "Health care services , except hospitals" > 43 "Social assistance" > 44 "Arts, entertainment, and recreation" > 45 "Accomodation" > 46 "Food services and drinking places" > 47 "Repair and maintenance" > 48 "Personal and laundry services" > 49 "Membership associations and organizations" > 50 "Private households" > 51 "Public Administration" > 52 "Armed forces" > ; . * occ2011: 2011-; . *label values occ2011 occ2011l ; . *label define occ2011l > 10 "Chief executives 11-1011" > 20 "General and operations managers 11-1021" > 30 "Legislators 11-1031" > 40 "Advertising and promotions managers 11-2011" > 50 "Marketing and sales managers 11-2020" > 60 "Public relations managers 11-2031" > 100 "Administrative services managers 11-3011" > 110 "Computer and information systems managers 11-3021" > 120 "Financial managers 11-3031" > 135 "Compensation and benefits managers 11-3111" > 136 "Human Resources Managers 11-3121" > 137 "Training and Development Managers 11-3131" > 140 "Industrial production managers 11-3051" > 150 "Purchasing managers 11-3061" > 160 "Transportation, storage, and distribution managers 11-30 > 71" > 205 "Farmers, Ranchers, and other Agricultural Managers 11-90 > 13" > 220 "Construction managers 11-9021" > 230 "Education administrators 11-9030" > 300 "Engineering managers 11-9041" > 310 "Food service managers 11-9051" > 325 "Funeral Service Managers 11-9061" > 330 "Gaming managers 11-9071" > 340 "Lodging managers 11-9081" > 350 "Medical and health services managers 11-9111" > 360 "Natural sciences managers 11-9121" > 400 "Postmasters and mail superintendents 11-9131" > 410 "Property, real estate, and community association manager > s 11-9141" > 420 "Social and community service managers 11-9151" > 425 "Emergency Management Directors 11-9161" > 430 "Managers, all other 11-9199" > 500 "Agents and business managers of artists, performers, and > athletes 13-1011" > 510 "Purchasing agents and buyers, farm products 13-1021" > 520 "Wholesale and retail buyers, except farm products 13-102 > 2" > 530 "Purchasing agents, except wholesale, retail, and farm pr > oducts 13-1023" > 540 "Claims adjusters, appraisers, examiners, and investigato > rs 13-1030" > 565 "Compliance Officers 13-1041" > 600 "Cost estimators 13-1051" > 630 "Human resources workers 13-1070" > 640 "Compensation, benefits, and job analysis specialists 13- > 1141" > 650 "Training and development specialists 13-1151" > 700 "Logisticians 13-1081" > 710 "Management analysts 13-1111" > 725 "Meeting, convention, and event planners 13-1121" > 726 "Fundraisers 13-1131" > 735 "Market research analysts and marketing specialists 13-11 > 61" > 740 "Business operations specialists, all other 13-1199" > 800 "Accountants and auditors 13-2011" > 810 "Appraisers and assessors of real estate 13-2021" > 820 "Budget analysts 13-2031" > 830 "Credit analysts 13-2041" > 840 "Financial analysts 13-2051" > 850 "Personal financial advisors 13-2052" > 860 "Insurance underwriters 13-2053" > 900 "Financial examiners 13-2061" > 910 "Loan counselors and officers 13-2070" > 930 "Tax examiners, collectors, and revenue agents 13-2081" > 940 "Tax preparers 13-2082" > 950 "Financial specialists, all other 13-2099" > 1000 "Computer scientists and systems analysts 15-10XX" > 1005 "Computer and information research scientists 15-1111" > 1006 "Computer systems analysts 15-1121" > 1007 "Information security analysts 15-1122" > 1010 "Computer programmers 15-1131" > 1020 "Software developers, applications and systems software 1 > 5-113X" > 1030 "Web developers 15-1134" > 1050 "Computer support specialists 15-1150" > 1060 "Database administrators 15-1141" > 1105 "Network and computer systems administrators 15-1142" > 1106 "Computer network architects 15-1143" > 1107 "Computer occupations, all other 15-1199" > 1200 "Actuaries 15-2011" > 1210 "Mathematicians 15-2021" > 1220 "Operations research analysts 15-2031" > 1230 "Statisticians 15-2041" > 1240 "Miscellaneous mathematical science occupations 15-2090" > 1300 "Architects, except naval 17-1010" > 1310 "Surveyors, cartographers, and photogrammetrists 17-1020" > 1320 "Aerospace engineers 17-2011" > 1330 "Agricultural engineers 17-2021" > 1340 "Biomedical engineers 17-2031" > 1350 "Chemical engineers 17-2041" > 1360 "Civil engineers 17-2051" > 1400 "Computer hardware engineers 17-2061" > 1410 "Electrical and electronic engineers 17-2070" > 1420 "Environmental engineers 17-2081" > 1430 "Industrial engineers, including health and safety 17-211 > 0" > 1440 "Marine engineers and naval architects 17-2121" > 1450 "Materials engineers 17-2131" > 1460 "Mechanical engineers 17-2141" > 1500 "Mining and geological engineers, including mining safety > engineers 17-2151" > 1510 "Nuclear engineers 17-2161" > 1520 "Petroleum engineers 17-2171" > 1530 "Engineers, all other 17-2199" > 1540 "Drafters 17-3010" > 1550 "Engineering technicians, except drafters 17-3020" > 1560 "Surveying and mapping technicians 17-3031" > 1600 "Agricultural and food scientists 19-1010" > 1610 "Biological scientists 19-1020" > 1640 "Conservation scientists and foresters 19-1030" > 1650 "Medical scientists 19-1040" > 1660 "Life Scientists, all other 16-1099" > 1700 "Astronomers and physicists 19-2010" > 1710 "Atmospheric and space scientists 19-2021" > 1720 "Chemists and materials scientists 19-2030" > 1740 "Environmental scientists and geoscientists 19-2040" > 1760 "Physical scientists, all other 19-2099" > 1800 "Economists 19-3011" > 1815 "Survey Researchers 19-3022" > 1820 "Psychologists 19-3030" > 1830 "Sociologists 19-3041" > 1840 "Urban and regional planners 19-3051" > 1860 "Miscellaneous social scientists and related workers 19-3 > 090" > 1900 "Agricultural and food science technicians 19-4011" > 1910 "Biological technicians 19-4021" > 1920 "Chemical technicians 19-4031" > 1930 "Geological and petroleum technicians 19-4041" > 1940 "Nuclear technicians 19-4051" > 1950 "Social science research assistants 19-4061" > 1965 "Miscellaneous life, physical, and social science technic > ians 19-4090" > 2000 "Counselors 21-1010" > 2010 "Social workers 21-1020" > 2015 "Probation Officers and Correctional Treatment Specialist > s 21-1092" > 2016 "Social and Human Service Assistants 21-1093" > 2025 "Miscellaneous community and social service specialists, > 21-109X" > 2040 "Clergy 21-2011" > 2050 "Directors, religious activities and education 21-2021" > 2060 "Religious workers, all other 21-2099" > 2100 "Lawyers, Judges, magistrates, and other judicial workers > 23-1011" > 2105 "Judicial Law Clerks 23-1012" > 2110 "Judges, Magistrates, and Other Judicial Workers 23-1020" > 2145 "Paralegals and Legal Assistants 23-2011" > 2160 "Miscellaneous Legal Support Workers 23-2090" > 2200 "Postsecondary teachers 25-1000" > 2300 "Preschool and kindergarten teachers 25-2010" > 2310 "Elementary and middle school teachers 25-2020" > 2320 "Secondary school teachers 25-2030" > 2330 "Special education teachers 25-2050" > 2340 "Other teachers and instructors 25-3000" > 2400 "Archivists, curators, and museum technicians 25-4010" > 2430 "Librarians 25-4021" > 2440 "Library technicians 25-4031" > 2540 "Teacher assistants 25-9041" > 2550 "Other education, training, and library workers 25-90XX" > 2600 "Artists and related workers 27-1010" > 2630 "Designers 27-1020" > 2700 "Actors 27-2011" > 2710 "Producers and directors 27-2012" > 2720 "Athletes, coaches, umpires, and related workers 27-2020" > 2740 "Dancers and choreographers 27-2030" > 2750 "Musicians, singers, and related workers 27-2040" > 2760 "Entertainers and performers, sports and related workers, > all other 27-2099" > 2800 "Announcers 27-3010" > 2810 "News analysts, reporters and correspondents 27-3020" > 2825 "Public Relations Specialists 27-3031" > 2830 "Editors 27-3041" > 2840 "Technical writers 27-3042" > 2850 "Writers and authors 27-3043" > 2860 "Miscellaneous media and communication workers 27-3090" > 2900 "Broadcast and sound engineering technicians and radio op > erators 27-4010" > 2910 "Photographers 27-4021" > 2920 "Television, video, and motion picture camera operators a > nd editors 27-4030" > 2960 "Media and communication equipment workers, all other 27- > 4099" > 3000 "Chiropractors 29-1011" > 3010 "Dentists 29-1020" > 3030 "Dietitians and nutritionists 29-1031" > 3040 "Optometrists 29-1041" > 3050 "Pharmacists 29-1051" > 3060 "Physicians and surgeons 29-1060" > 3110 "Physician assistants 29-1071" > 3120 "Podiatrists 29-1081" > 3140 "Audiologists 29-1181" > 3150 "Occupational therapists 29-1122" > 3160 "Physical therapists 29-1123" > 3200 "Radiation therapists 29-1124" > 3210 "Recreational therapists 29-1125" > 3220 "Respiratory therapists 29-1126" > 3230 "Speech-language pathologists 29-1127" > 3235 "Exercise Physiologists 29-1128" > 3245 "Therapists, all other 29-1129" > 3250 "Veterinarians 29-1131" > 3255 "Registered Nurses 29-1141" > 3256 "Nurse Anesthetists 29-1151" > 3257 "Nurse Midwives 29-1161" > 3258 "Nurse Practitioners 29-1171" > 3260 "Health diagnosing and treating practitioners, all other > 29-1199" > 3300 "Clinical laboratory technologists and technicians 29-201 > 0" > 3310 "Dental hygienists 29-2021" > 3320 "Diagnostic related technologists and technicians 29-2030 > " > 3400 "Emergency medical technicians and paramedics 29-2041" > 3420 "Health Practitioner Support Technologists and Technician > s 29-2050" > 3500 "Licensed practical and licensed vocational nurses 29-206 > 1" > 3510 "Medical records and health information technicians 29-20 > 71" > 3520 "Opticians, dispensing 29-2081" > 3535 "Miscellaneous Health Technologists and Technicians 29-20 > 90" > 3540 "Other healthcare practitioners and technical occupations > 29-9000" > 3600 "Nursing, psychiatric, and home health aides 31-1010" > 3610 "Occupational therapist assistants and aides 31-2010" > 3620 "Physical therapist assistants and aides 31-2020" > 3630 "Massage therapists 31-9011" > 3640 "Dental assistants 31-9091" > 3645 "Medical Assistants 31-9092" > 3646 "Medical Transcriptionists 31-9094" > 3647 "Pharmacy Aides 31-9095" > 3648 "Veterinary Assistants and Laboratory Animal Caretakers 3 > 1-9096" > 3649 "Phlebotomists 31-9097" > 3655 "Miscellaneous Healthcare Support Occupations, Including > 31-909X" > 3700 "First-line supervisors/managers of correctional officers > 33-1011" > 3710 "First-line supervisors/managers of police and detectives > 33-1012" > 3720 "First-line supervisors/managers of fire fighting and pre > vention workers 33-1021" > 3730 "Supervisors, protective service workers, all other 33-10 > 99" > 3740 "Fire fighters 33-2011" > 3750 "Fire inspectors 33-2020" > 3800 "Bailiffs, correctional officers, and jailers 33-3010" > 3820 "Detectives and criminal investigators 33-3021" > 3830 "Fish and game wardens 33-3031" > 3840 "Parking enforcement workers 33-3041" > 3850 "Police and sheriff's patrol officers 33-3051" > 3860 "Transit and railroad police 33-3052" > 3900 "Animal control workers 33-9011" > 3910 "Private detectives and investigators 33-9021" > 3930 "Security Guards and Gaming Surveillance Officers 33-9030 > " > 3940 "Crossing guards 33-9091" > 3945 "Transportation Security Screeners 33-9093" > 3955 "Lifeguards and Other Recreational, and all Other Protect > ive Service Workers 33-909X" > 4000 "Chefs and head cooks 35-1011" > 4010 "First-line supervisors/managers of food preparation and > serving workers 35-1012" > 4020 "Cooks 35-2010" > 4030 "Food preparation workers 35-2021" > 4040 "Bartenders 35-3011" > 4050 "Combined food preparation and serving workers, including > fast food 35-3021" > 4060 "Counter attendants, cafeteria, food concession, and coff > ee shop 35-3022" > 4110 "Waiters and waitresses 35-3031" > 4120 "Food servers, nonrestaurant 35-3041" > 4130 "Dining room and cafeteria attendants and bartender helpe > rs 35-9011" > 4140 "Dishwashers 35-9021" > 4150 "Hosts and hostesses, restaurant, lounge, and coffee shop > 35-9031" > 4160 "Food preparation and serving related workers, all other > 35-9099" > 4200 "First-line supervisors/managers of housekeeping and jani > torial workers 37-1011" > 4210 "First-line supervisors/managers of landscaping, lawn ser > vice, and groundskeeping workers 37-1012" > 4220 "Janitors and building cleaners 31-201X" > 4230 "Maids and housekeeping cleaners 37-2012" > 4240 "Pest control workers 37-2021" > 4250 "Grounds maintenance workers 37-3010" > 4300 "First-line supervisors/managers of gaming workers 39-101 > 0" > 4320 "First-line supervisors/managers of personal service work > ers 39-1021" > 4340 "Animal trainers 39-2011" > 4350 "Nonfarm animal caretakers 39-2021" > 4400 "Gaming services workers 39-3010" > 4410 "Motion picture projectionists 39-3021" > 4420 "Ushers, lobby attendants, and ticket takers 39-3031" > 4430 "Miscellaneous entertainment attendants and related worke > rs 39-3090" > 4460 "Funeral service workers 39-40XX" > 4465 "Morticians, Undertakers, and Funeral Directors 39-4031" > 4500 "Barbers 39-5011" > 4510 "Hairdressers, hairstylists, and cosmetologists 39-5012" > 4520 "Miscellaneous personal appearance workers 39-5090" > 4530 "Baggage porters, bellhops, and concierges 39-6010" > 4540 "Tour and travel guides 39-7010" > 4600 "Child care workers 39-9011" > 4610 "Personal and home care aides 39-9021" > 4620 "Recreation and fitness workers 39-9030" > 4640 "Residential advisors 39-9041" > 4650 "Personal care and service workers, all other 39-9099" > 4700 "First-line supervisors/managers of retail sales workers > 41-1011" > 4710 "First-line supervisors/managers of non-retail sales work > ers 41-1012" > 4720 "Cashiers 41-2010" > 4740 "Counter and rental clerks 41-2021" > 4750 "Parts salespersons 41-2022" > 4760 "Retail salespersons 41-2031" > 4800 "Advertising sales agents 41-3011" > 4810 "Insurance sales agents 41-3021" > 4820 "Securities, commodities, and financial services sales ag > ents 41-3031" > 4830 "Travel agents 41-3041" > 4840 "Sales representatives, services, all other 41-3099" > 4850 "Sales representatives, wholesale and manufacturing 41-40 > 10" > 4900 "Models, demonstrators, and product promoters 41-9010" > 4920 "Real estate brokers and sales agents 41-9020" > 4930 "Sales engineers 41-9031" > 4940 "Telemarketers 41-9041" > 4950 "Door-to-door sales workers, news and street vendors, and > related workers 41-9091" > 4965 "Sales and Related Workers, all other 41-9099" > 5000 "First-line supervisors/managers of office and administra > tive support workers 43-1011" > 5010 "Switchboard operators, including answering service 43-20 > 11" > 5020 "Telephone operators 43-2021" > 5030 "Communications equipment operators, all other 43-2099" > 5100 "Bill and account collectors 43-3011" > 5110 "Billing and posting clerks and machine operators 43-3021 > " > 5120 "Bookkeeping, accounting, and auditing clerks 43-3031" > 5130 "Gaming cage workers 43-3041" > 5140 "Payroll and timekeeping clerks 43-3051" > 5150 "Procurement clerks 43-3061" > 5160 "Tellers 43-3071" > 5165 "Financial Clerks, all other 43-3099" > 5200 "Brokerage clerks 43-4011" > 5210 "Correspondence clerks 43-4021" > 5220 "Court, municipal, and license clerks 43-4031" > 5230 "Credit authorizers, checkers, and clerks 43-4041" > 5240 "Customer service representatives 43-4051" > 5250 "Eligibility interviewers, government programs 43-4061" > 5260 "File Clerks 43-4071" > 5300 "Hotel, motel, and resort desk clerks 43-4081" > 5310 "Interviewers, except eligibility and loan 43-4111" > 5320 "Library assistants, clerical 43-4121" > 5330 "Loan interviewers and clerks 43-4131" > 5340 "New accounts clerks 43-4141" > 5350 "Order clerks 43-4151" > 5360 "Human resources assistants, except payroll and timekeepi > ng 43-4161" > 5400 "Receptionists and information clerks 43-4171" > 5410 "Reservation and transportation ticket agents and travel > clerks 43-4181" > 5420 "Information and record clerks, all other 43-4199" > 5500 "Cargo and freight agents 43-5011" > 5510 "Couriers and messengers 43-5021" > 5520 "Dispatchers 43-5030" > 5530 "Meter readers, utilities 43-5041" > 5540 "Postal service clerks 43-5051" > 5550 "Postal service mail carriers 43-5052" > 5560 "Postal service mail sorters, processors, and processing > machine operators 43-5053" > 5600 "Production, planning, and expediting clerks 43-5061" > 5610 "Shipping, receiving, and traffic clerks 43-5071" > 5620 "Stock clerks and order fillers 43-5081" > 5630 "Weighers, measurers, checkers, and samplers, recordkeepi > ng 43-5111" > 5700 "Secretaries and administrative assistants 43-6010" > 5800 "Computer operators 43-9011" > 5810 "Data entry keyers 43-9021" > 5820 "Word processors and typists 43-9022" > 5830 "Desktop publishers 43-9031" > 5840 "Insurance claims and policy processing clerks 43-9041" > 5850 "Mail clerks and mail machine operators, except postal se > rvice 43-9051" > 5860 "Office clerks, general 43-9061" > 5900 "Office machine operators, except computer 43-9071" > 5910 "Proofreaders and copy markers 43-9081" > 5920 "Statistical assistants 43-9111" > 5940 "Office and Administrative Support Workers, all other 43- > 9199" > 6005 "First-line supervisors of farming, fishing, and forestry > workers 45-1011" > 6010 "Agricultural inspectors 45-2011" > 6020 "Animal breeders 45-2021" > 6040 "Graders and sorters, agricultural products 45-2041" > 6050 "Miscellaneous agricultural workers 45-2090" > 6100 "Fishers and related fishing workers 45-3011" > 6110 "Hunters and trappers 45-3021" > 6120 "Forest and conservation workers 45-4011" > 6130 "Logging workers 45-4020" > 6200 "First-line supervisors/managers of construction trades a > nd extraction workers 47-1011" > 6210 "Boilermakers 47-2011" > 6220 "Brickmasons, blockmasons, and stonemasons 47-2020" > 6230 "Carpenters 47-2031" > 6240 "Carpet, floor, and tile installers and finishers 47-2040 > " > 6250 "Cement masons, concrete finishers, and terrazzo workers > 47-2050" > 6260 "Construction laborers 47-2061" > 6300 "Paving, surfacing, and tamping equipment operators 47-20 > 71" > 6310 "Pile-driver operators 47-2072" > 6320 "Operating engineers and other construction equipment ope > rators 47-2073" > 6330 "Drywall installers, ceiling tile installers, and tapers > 47-2080" > 6355 "Electricians 47-2111" > 6360 "Glaziers 47-2121" > 6400 "Insulation workers 47-2130" > 6420 "Painters, construction and maintenance 47-2141" > 6430 "Paperhangers 47-2142" > 6440 "Pipelayers, plumbers, pipefitters, and steamfitters 47-2 > 150" > 6460 "Plasterers and stucco masons 47-2161" > 6500 "Reinforcing iron and rebar workers 47-2171" > 6515 "Roofers 47-2181" > 6520 "Sheet metal workers 47-2211" > 6530 "Structural iron and steel workers 47-2221" > 6540 "Solar Photovoltaic Installers 47-2231" > 6600 "Helpers, construction trades 47-3010" > 6660 "Construction and building inspectors 47-4011" > 6700 "Elevator installers and repairers 47-4021" > 6710 "Fence erectors 47-4031" > 6720 "Hazardous materials removal workers 47-4041" > 6730 "Highway maintenance workers 47-4051" > 6740 "Rail-track laying and maintenance equipment operators 47 > -4061" > 6750 "Septic tank servicers and sewer pipe cleaners 47-4071" > 6765 "Miscellaneous construction and related workers 47-4090" > 6800 "Derrick, rotary drill, and service unit operators, oil, > gas, and mining 47-5010" > 6820 "Earth drillers, except oil and gas 47-5021" > 6830 "Explosives workers, ordnance handling experts, and blast > ers 47-5031" > 6840 "Mining machine operators 47-5040" > 6910 "Roof bolters, mining 47-5061" > 6920 "Roustabouts, oil and gas 47-5071" > 6930 "Helpers--extraction workers 47-5081" > 6940 "Other extraction workers 47-50XX" > 7000 "First-line supervisors/managers of mechanics, installers > , and repairers 49-1011" > 7010 "Computer, automated teller, and office machine repairers > 49-2011" > 7020 "Radio and telecommunications equipment installers and re > pairers 49-2020" > 7030 "Avionics technicians 49-2091" > 7040 "Electric motor, power tool, and related repairers 49-209 > 2" > 7050 "Electrical and electronics installers and repairers, tra > nsportation equipment 49-2093" > 7100 "Electrical and electronics repairers, industrial and uti > lity 49-209X" > 7110 "Electronic equipment installers and repairers, motor veh > icles 49-2096" > 7120 "Electronic home entertainment equipment installers and r > epairers 49-2097" > 7130 "Security and fire alarm systems installers 49-2098" > 7140 "Aircraft mechanics and service technicians 49-3011" > 7150 "Automotive body and related repairers 49-3021" > 7160 "Automotive glass installers and repairers 49-3022" > 7200 "Automotive service technicians and mechanics 49-3023" > 7210 "Bus and truck mechanics and diesel engine specialists 49 > -3031" > 7220 "Heavy vehicle and mobile equipment service technicians a > nd mechanics 49-3040" > 7240 "Small engine mechanics 49-3050" > 7260 "Miscellaneous vehicle and mobile equipment mechanics, in > stallers, and repairers 49-3090" > 7300 "Control and valve installers and repairers 49-9010" > 7315 "Heating, air conditioning, and refrigeration mechanics a > nd installers 49-9021" > 7320 "Home appliance repairers 49-9031" > 7330 "Industrial and refractory machinery mechanics 49-904X" > 7340 "Maintenance and repair workers, general 49-9071" > 7350 "Maintenance workers, machinery 49-9043" > 7360 "Millwrights 49-9044" > 7410 "Electrical power-line installers and repairers 49-9051" > 7420 "Telecommunications line installers and repairers 49-9052 > " > 7430 "Precision instrument and equipment repairers 49-9060" > 7440 "Wind Turbine Service Technicians 49-9081" > 7510 "Coin, vending, and amusement machine servicers and repai > rers 49-9091" > 7520 "Commercial divers 49-9092" > 7540 "Locksmiths and safe repairers 49-9094" > 7550 "Manufactured building and mobile home installers 49-9095 > " > 7560 "Riggers 49-9096" > 7600 "Signal and track switch repairers 49-9097" > 7610 "Helpers--installation, maintenance, and repair workers 4 > 9-9098" > 7630 "Other installation, maintenance, and repair workers 49-9 > 09X" > 7700 "First-line supervisors/managers of production and operat > ing workers 51-1011" > 7710 "Aircraft structure, surfaces, rigging, and systems assem > blers 51-2011" > 7720 "Electrical, electronics, and electromechanical assembler > s 51-2020" > 7730 "Engine and other machine assemblers 51-2031" > 7740 "Structural metal fabricators and fitters 51-2041" > 7750 "Miscellaneous assemblers and fabricators 51-2090" > 7800 "Bakers 51-3011" > 7810 "Butchers and other meat, poultry, and fish processing wo > rkers 51-3020" > 7830 "Food and tobacco roasting, baking, and drying machine op > erators and tenders 51-3091" > 7840 "Food batchmakers 51-3092" > 7850 "Food cooking machine operators and tenders 51-3093" > 7855 "Food Processing Workers, all Other 51-3099" > 7900 "Computer control programmers and operators 51-4010" > 7920 "Extruding and drawing machine setters, operators, and te > nders, metal and plastic 51-4021" > 7930 "Forging machine setters, operators, and tenders, metal a > nd plastic 51-4022" > 7940 "Rolling machine setters, operators, and tenders, metal a > nd plastic 51-4023" > 7950 "Cutting, punching, and press machine setters, operators, > and tenders, metal and plastic 51-4031" > 7960 "Drilling and boring machine tool setters, operators, and > tenders, metal and plastic 51-4032" > 8000 "Grinding, lapping, polishing, and buffing machine tool s > etters, operators, and tenders, metal and plastic 51-4033" > 8010 "Lathe and turning machine tool setters, operators, and t > enders, metal and plastic 51-4034" > 8020 "Milling and planing machine setters, operators, and tend > ers, metal and plastic 51-4035" > 8030 "Machinists 51-4041" > 8040 "Metal furnace and kiln operators and tenders 51-4050" > 8060 "Model makers and patternmakers, metal and plastic 51-406 > 0" > 8100 "Molders and molding machine setters, operators, and tend > ers, metal and plastic 51-4070" > 8120 "Multiple machine tool setters, operators, and tenders, m > etal and plastic 51-4081" > 8130 "Tool and die makers 51-4111" > 8140 "Welding, soldering, and brazing workers 51-4120" > 8150 "Heat treating equipment setters, operators, and tenders, > metal and plastic 51-4191" > 8160 "Lay-out workers, metal and plastic 51-4192" > 8200 "Plating and coating machine setters, operators, and tend > ers, metal and plastic 51-4193" > 8210 "Tool grinders, filers, and sharpeners 51-4194" > 8220 "Metalworkers and plastic workers, all other 51-4199" > 8250 "Prepress technicians and workers 51-5111" > 8255 "Printing Press Operators 51-5112" > 8256 "Print Binding and Finishing Workers 51-5113" > 8300 "Laundry and dry-cleaning workers 51-6011" > 8310 "Pressers, textile, garment, and related materials 51-602 > 1" > 8320 "Sewing machine operators 51-6031" > 8330 "Shoe and leather workers and repairers 51-6041" > 8340 "Shoe machine operators and tenders 51-6042" > 8350 "Tailors, dressmakers, and sewers 51-6050" > 8360 "Textile bleaching and dyeing machine operators and tende > rs 51-6061" > 8400 "Textile cutting machine setters, operators, and tenders > 51-6062" > 8410 "Textile knitting and weaving machine setters, operators, > and tenders 51-6063" > 8420 "Textile winding, twisting, and drawing out machine sette > rs, operators, and tenders 51-6064" > 8430 "Extruding and forming machine setters, operators, and te > nders, synthetic and glass fibers 51-6091" > 8440 "Fabric and apparel patternmakers 51-6092" > 8450 "Upholsterers 51-6093" > 8460 "Textile, apparel, and furnishings workers, all other 51- > 6099" > 8500 "Cabinetmakers and bench carpenters 51-7011" > 8510 "Furniture finishers 51-7021" > 8520 "Model makers and patternmakers, wood 51-7030" > 8530 "Sawing machine setters, operators, and tenders, wood 51- > 7041" > 8540 "Woodworking machine setters, operators, and tenders, exc > ept sawing 51-7042" > 8550 "Woodworkers, all other 51-7099" > 8600 "Power plant operators, distributors, and dispatchers 51- > 8010" > 8610 "Stationary engineers and boiler operators 51-8021" > 8620 "Water and liquid waste treatment plant and system operat > ors 51-8031" > 8630 "Miscellaneous plant and system operators 51-8090" > 8640 "Chemical processing machine setters, operators, and tend > ers 51-9010" > 8650 "Crushing, grinding, polishing, mixing, and blending work > ers 51-9020" > 8710 "Cutting workers 51-9030" > 8720 "Extruding, forming, pressing, and compacting machine set > ters, operators, and tenders 51-9041" > 8730 "Furnace, kiln, oven, drier, and kettle operators and ten > ders 51-9051" > 8740 "Inspectors, testers, sorters, samplers, and weighers 51- > 9061" > 8750 "Jewelers and precious stone and metal workers 51-9071" > 8760 "Medical, dental, and ophthalmic laboratory technicians 5 > 1-9080" > 8800 "Packaging and filling machine operators and tenders 51-9 > 111" > 8810 "Painting workers 51-9120" > 8830 "Photographic process workers and processing machine oper > ators 51-9151" > 8840 "Semiconductor processors 51-9141" > 8850 "Cementing and gluing machine operators and tenders 51-91 > 91" > 8860 "Cleaning, washing, and metal pickling equipment operator > s and tenders 51-9192" > 8900 "Cooling and freezing equipment operators and tenders 51- > 9193" > 8910 "Etchers and engravers 51-9194" > 8920 "Molders, shapers, and casters, except metal and plastic > 51-9195" > 8930 "Paper goods machine setters, operators, and tenders 51-9 > 196" > 8940 "Tire builders 51-9197" > 8950 "Helpers--production workers 51-9198" > 8965 "Production workers, all other 51-9199" > 9000 "Supervisors, transportation and material moving workers > 53-1000" > 9030 "Aircraft pilots and flight engineers 53-2010" > 9040 "Air traffic controllers and airfield operations speciali > sts 53-2020" > 9050 "Flight Attendants 53-2031" > 9110 "Ambulance drivers and attendants, except emergency medic > al technicians 53-3011" > 9120 "Bus drivers 53-3020" > 9130 "Driver/sales workers and truck drivers 53-3030" > 9140 "Taxi drivers and chauffeurs 53-3041" > 9150 "Motor vehicle operators, all other 53-3099" > 9200 "Locomotive engineers and operators 53-4010" > 9230 "Railroad brake, signal, and switch operators 53-4021" > 9240 "Railroad conductors and yardmasters 53-4031" > 9260 "Subway, streetcar, and other rail transportation workers > 53-40XX" > 9300 "Sailors and marine oilers 53-5011" > 9310 "Ship and boat captains and operators 53-5020" > 9330 "Ship engineers 53-5031" > 9340 "Bridge and lock tenders 53-6011" > 9350 "Parking lot attendants 53-6021" > 9360 "Service station attendants 53-6031" > 9410 "Transportation inspectors 53-6051" > 9415 "Transportation Attendants, Except Flight Attendants 53-6 > 061" > 9420 "Other transportation workers 53-60XX" > 9500 "Conveyor operators and tenders 53-7011" > 9510 "Crane and tower operators 53-7021" > 9520 "Dredge, excavating, and loading machine operators 53-703 > 0" > 9560 "Hoist and winch operators 53-7041" > 9600 "Industrial truck and tractor operators 53-7051" > 9610 "Cleaners of vehicles and equipment 53-7061" > 9620 "Laborers and freight, stock, and material movers, hand 5 > 3-7062" > 9630 "Machine feeders and offbearers 53-7063" > 9640 "Packers and packagers, hand 53-7064" > 9650 "Pumping station operators 53-7070" > 9720 "Refuse and recyclable material collectors 53-7081" > 9730 "Shuttle car operators 53-7111" > 9740 "Tank car, truck, and ship loaders 53-7121" > 9750 "Material moving workers, all other 53-7199" > 9840 "Armed Forces" > 9970 "Problem referral" > 9990 "Not reported (Includes Refused, Classified, blank and al > l other noncodable entries)" > 9800 "Military officer special and tactical operations leaders > /managers 55-1010" > 9810 "First-line enlisted military supervisors/managers 55-201 > 0" > 9820 "Military enlisted tactical operations and air/weapons sp > ecialists and crew members 55-3010" > 9830 "Military, rank not specified 99-9999" > ; . * docc00: 2000-; . label values docc00 docc00l ; . label define docc00l > 1 "Management occupations" > 2 "Business and financial operations occupations" > 3 "Computer and mathematical science occupations" > 4 "Architecture and engineering occupations" > > 5 "Life, physical, and social science occupations" > 6 "Community and social service occupations" > 7 "Legal occupations" > 8 "Education, training, and library occupations" > 9 "Arts, design, entertainment, sports, and media occupatio > ns" > 10 "Healthcare practitioner and technical occupations" > 11 "Healthcare support occupations" > 12 "Protective service occupations" > 13 "Food preparation and serving related occupations" > 14 "Building and grounds cleaning and maintenance occupation > s" > 15 "Personal care and service occupations" > 16 "Sales and related occupations" > 17 "Office and administrative support occupations" > 18 "Farming, fishing, and forestry occupations" > 19 "Construction and extraction occupations" > 20 "Installation, maintenance, and repair occupations" > > 21 "Production occupations" > 22 "Transportation and material moving occupations" > 23 "Armed Forces" > ; . * eligible: 1979:5-; . label values eligible P21L; . label define P21L > 1 "Earnings Eligible For Edit" > 2 "Other" > ; . * reason94: 1994-; . label values reason94 P22L; . label define P22L > 1 "Slack Work/Business Conditions" > 2 "Seasonal Work" > 3 "Job Started Or Ended During Week" > 4 "Vacation/Personal Day" > 5 "Own Illness/Injury/Medical Appointment" > 6 "Holiday (legal Or Religious)" > 7 "Child Care Problems" > 8 "Other Family/Personal Obligations" > 9 "Labor Dispute" > 10 "Weather Affected Job" > 11 "School/Training" > 12 "Civic/Military Duty" > 13 "Other Reason" > ; . * absent94: 1994-; . label values absent94 P23L; . label define P23L > 1 "On Layoff" > 2 "Slack Work/Business Conditions" > 3 "Waiting For A New Job To Begin" > 4 "Vacation/Personal Days" > 5 "Own Illness/Injury/Medical Problems" > 6 "Child Care Problems" > 7 "Other Family/Personal Obligation" > 8 "Maternity/Paternity Leave" > 9 "Labor Dispute" > 10 "Weather Affected Job" > 11 "School/Training" > 12 "Civic/Military Duty" > 13 "Does Not Work In The Business" > 14 "Other (specify)" > ; . *why3594: 1994-; . label values why3594 P3594L; . label define P3594L > 1 "Usu. FT-Slack Work/Business Conditions" > 2 "Usu. FT-Seasonal Work" > 3 "Usu. FT-Job Started/Ended During Week" > 4 "Usu. FT-Vacation/Personal Day" > 5 "Usu. FT-Own Illness/Injury/Medical Appt" > 6 "Usu. FT-Holiday (religious Or Legal)" > 7 "Usu. FT-Child Care Problems" > 8 "Usu. FT-Other Fam/Pers Obligations" > 9 "Usu. FT-Labor Dispute" > 10 "Usu. FT-Weather Affected Job" > 11 "Usu. FT-School/Training" > 12 "Usu. FT-Civic/Military Duty" > 13 "Usu. FT-Other Reason" > 14 "Usu. PT-Slack Work/Business Conditions" > 15 "Usu. PT-Could Only Find PT Work" > 16 "Usu. PT-Seasonal Work" > 17 "Usu. PT-Child Care Problems" > 18 "Usu. PT-Other Fam/Pers Obligations" > 19 "Usu. PT-Health/Medical Limitations" > 20 "Usu. PT-School/Training" > 21 "Usu. PT-Retired/Ss Limit On Earnings" > 22 "Usu. PT-Workweek <35 Hours" > 23 "Usu. PT-Other Reason" > ; . * ftpt94: 1994-; . label values ftpt94 P160L; . label define P160L > 1 "Not In Labor Force" > 2 "FT Hours (35+), Usually FT" > 3 "PT For Economic Reasons, Usually FT" > 4 "PT For Non-Economic Reasons, Usually FT" > 5 "Not At Work, Usually FT" > 6 "PT Hours, Usually PT For Economic Reasons" > 7 "PT hrs, Usually PT For Non-Economic" > 8 "FT Hours, Usually PT For Economic Reas" > 9 "FT hrs, Usually PT For Non-Economic" > 10 "Not at work, Usually Part-Time" > 11 "Unemployed FT" > 12 "Unemployed PT" > ; . * studftpt: 1984-; . label values studftpt P24L; . label define P24L > 1 "Full-time" > 2 "Part-time" > ; . * unionmme: 1983-; . label values unionmme P25L; . label define P25L > 1 "Yes" > 2 "No" > ; . * unioncov: 1983-; . label values unioncov P26L; . label define P26L > 1 "Yes" > 2 "No" > ; . * otc: 1994-; . label values otc yesno; . label define yesno > 1 "Yes" > 2 "No" > ; . * hrhtype: 1984-; . label values hrhtype hrhtype; . label define hrhtype > 0 "Non-interview household" > 1 "Husband/wife primary fam (neither in Armed Forces)" > 2 "Husband/wife primary fam (one/both in Armed Forces)" > 3 "Unmarried civilian male primary fam householder" > 4 "Unmarried civilian female primary fam householder" > 5 "Unmarried primary fam householder in Armed Forces" > 6 "Civilian male primary individual" > 7 "Civilian female primary individual" > 8 "Primary ind HH - reference person in Armed Forces" > 9 "Group quarters with family" > 10 "Group quarters without family" > ; . ** Race 2003-April 2012 has 21 Categories" > ** "Race May 2012 on has 26 Categories" > label values race race26; > label define race26 > 1 "White Only" > 2 "Black Only" > 3 "American Indian, Alaskan Native Only" > 4 "Asian Only" > 5 "Hawaiian/Pacific Islander Only" > 6 "White-Black" > 7 "White-AI" > 8 "White-Asian" > 9 "White-HP" > 10 "Black-AI" > 11 "Black-Asian" > 12 "Black-HP" > 13 "AI-Asian" > 14 "AI-HP" > 15 "Asian-HP" > 16 "W-B-AI" > 17 "W-B-A" > 18 "W-B-HP" > 19 "W-AI-A" > 20 "W-AI-HP" > 21 "W-A-HP" > 22 "B-AI-A" > 23 "W-B-AI-A" > 24 "W-AI-A-HP" > 25 "Other 3 Race Combinations" > 26 "Other 4 and 5 Race Combinations" > ; > ** uhourse -4 Hours vary 1994-; > label values uhourse uhourse; > label define uhourse > -4 "Hours vary" > ; > > > end of do-file (saving in Stata 12 format, which Stata 11 can read) (note: file /homes/data/morg/annual/morg20.dta not found) file /homes/data/morg/annual/morg20.dta saved Variable | Obs Mean Std. Dev. Min Max -------------+--------------------------------------------------------- hhid | 0 intmonth | 271,251 6.459843 3.506768 1 12 hurespli | 271,225 1.251658 .6174206 0 13 hrhtype | 271,251 2.721431 2.291925 1 10 minsamp | 271,251 6.066632 1.998893 4 8 -------------+--------------------------------------------------------- hrlonglk | 271,251 1.989862 .1420342 0 2 hrsample | 0 hrhhid2 | 0 serial | 0 hhnum | 271,251 1.04998 .2396882 1 5 -------------+--------------------------------------------------------- stfips | 271,251 28.09621 16.21129 1 56 cbsafips | 271,251 22721.82 16501.28 0 49740 county | 271,251 25.65961 61.75492 0 810 centcity | 224,003 1.931474 .720643 1 3 smsastat | 268,532 1.189981 .3922867 1 2 -------------+--------------------------------------------------------- icntcity | 34,011 1.397959 .9672773 1 7 smsa04 | 271,251 3.67171 2.59222 0 7 relref95 | 271,251 42.7883 3.831038 40 59 age | 271,251 48.75274 18.92996 16 85 spouse | 140,192 1.580846 .6820287 1 15 -------------+--------------------------------------------------------- sex | 271,251 1.519615 .499616 1 2 grade92 | 271,251 40.55438 2.680535 31 46 race | 271,251 1.432518 1.28742 1 26 ethnic | 34,870 2.635245 2.431391 1 8 lineno | 271,251 1.739581 1.007063 1 15 -------------+--------------------------------------------------------- famnum | 271,251 .7882183 .4757027 0 4 pfamrel | 271,251 1.363486 1.082856 0 4 marital | 271,251 3.427781 2.653565 1 7 prpertyp | 271,251 2.004159 .0643524 2 3 penatvty | 271,251 87.27903 81.06214 57 555 -------------+--------------------------------------------------------- pemntvty | 271,251 98.36221 91.51369 57 555 pefntvty | 271,251 98.42636 91.6686 57 555 prcitshp | 271,251 1.477351 1.192378 1 5 prcitflg | 271,251 .2839731 2.609761 0 41 peinusyr | 271,251 2.188246 5.948778 0 26 -------------+--------------------------------------------------------- selfproxy | 267,856 1.486056 .50231 1 3 lfsr94 | 270,123 3.033296 2.3559 1 7 absent94 | 6,857 8.331194 4.42744 4 14 uhourse | 151,807 35.85547 14.88138 -4 99 reason94 | 13,321 4.908565 3.458361 1 13 -------------+--------------------------------------------------------- hourslw | 143,822 38.16429 12.88106 1 99 laydur | 6,001 10.85769 9.562134 1 52 dwrsn | 5,565 7.782031 3.618305 1 11 why3594 | 36,534 14.12569 7.600127 1 23 prunedur | 11,999 15.71639 18.76433 0 119 -------------+--------------------------------------------------------- untype | 11,999 2.270189 1.639091 1 6 ftpt94 | 270,123 2.636536 2.586049 1 12 class94 | 171,234 4.100179 1.1737 1 8 agri | 171,234 .0199551 .1398465 0 1 eligible | 271,251 1.507206 .499949 1 2 -------------+--------------------------------------------------------- otc | 133,671 1.862468 .3444091 1 2 ernpdh2 | 78,758 1.766487 .4230684 1 2 paidhre | 133,671 1.445646 .4970388 1 2 earnhre | 74,066 1976.72 1103.416 75 9999 earnwke | 133,671 1068.997 728.7891 0 2884.61 -------------+--------------------------------------------------------- unionmme | 133,671 1.894353 .307387 1 2 unioncov | 119,549 1.985654 .1189113 1 2 schenr | 157,490 1.852721 .3543851 1 2 studftpt | 23,195 1.135245 .3419921 1 2 schlvl | 23,195 1.59875 .4901621 1 2 -------------+--------------------------------------------------------- earnwt | 271,251 11516.82 6574.24 0 85441.58 weight | 271,251 2879.204 1633.526 0 20187.61 chldpres | 271,251 1.197186 2.690488 0 15 ownchild | 271,251 .4392389 .9244001 0 11 I25d | 133,671 .3578188 .4793602 0 1 -------------+--------------------------------------------------------- I25c | 74,101 .4004399 .4899909 0 1 I25a | 271,251 .3537314 3.634502 0 43 I25b | 271,251 3.964078 12.26686 0 42 qstnum | 0 occurnum | 0 -------------+--------------------------------------------------------- ged | 76,333 1.087708 .2828713 1 2 gedhigr | 6,695 6.48708 1.394676 1 8 yrcoll | 72,880 2.822352 .978108 1 5 grprof | 0 gr6cor | 0 -------------+--------------------------------------------------------- ms123 | 0 cmpwgt | 271,251 2879.449 1635.816 0 20298.16 ind02 | 171,234 6295.845 2694.671 170 9890 occ2012 | 171,234 4054.586 2676.862 10 9840 occ002 | 271,251 94.51635 697.1038 -1 9760 -------------+--------------------------------------------------------- vet1 | 20,505 3.346159 1.50362 1 9 vet2 | 4,130 3.131719 1.360832 1 9 vet3 | 936 2.754274 1.31364 1 8 vet4 | 118 3.330508 1.601576 1 8 linedad | 36,795 1.686561 .9257671 1 15 -------------+--------------------------------------------------------- linemom | 27,230 1.145832 .4125319 1 3 recnum | 271,251 200412.5 116735.8 1 401153 year | 271,251 2020 0 2020 2020 ym_file | 271,251 725.4598 3.506768 720 731 ym | 271,251 716.2599 6.924727 705 728 -------------+--------------------------------------------------------- ch02 | 271,251 .0559703 .2298648 0 1 ch35 | 271,251 .063974 .244707 0 1 ch613 | 271,251 .1361212 .3429178 0 1 ch1417 | 271,251 .0825324 .2751747 0 1 ch05 | 271,251 .1000033 .300005 0 1 -------------+--------------------------------------------------------- ihigrdc | 189,308 12.46477 2.408166 0 18 docc00 | 171,234 164.4632 944.2714 1 9760 dind02 | 171,234 700.6383 2145.805 1 8891 . . . exit, clear end of do-file . . exit,clear