------------------------------------------------------------------------------- log: /disk/nber10/SCCS/morg/sources/annual2002.log log type: text opened on: 18 Feb 2004, 12:28:40 . set memory 2000m (2048000k) . set more 1 . *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 . ! /bin/rm -f /tmp/aef.raw aef.dct dcthead . * run with stata6 -p0 do annual2002 to get Stata 5 format . * run with nohup stata -b do annual2002 & to run in batch mode . ! echo >dcthead dictionary using /tmp/aef.raw . program define aef2 1. * '-A' are missing value indicators in the earlier files. . if `1' < 1994 { 2. !zcat /home/data/morg/raw/morg`2'.Z |tr "\-A" " " >/tmp/aef.raw 3. } 4. if `1' >= 1994 { 5. !zcat /home/data/morg/raw/morg`2'.Z >/tmp/aef.raw 6. } 7. ! cat /home/data/morg/sources/dcthead /home/data/morg/sources/aef`3'.dbd > > ./aef.dct 8. quietly infile using aef if age>15&age!=. 9. #delimit cr delimiter now cr . local lastyear=2002 10. . * Miscellaneous (record keeping) variables . if `1' == 1994 { 11. replace hhid = hhid94 12. drop hhid94 13. } 14. if `1'== 1995 { 15. replace hhid = hhid94 if intmonth<9 16. drop hhid94 17. } 18. if `1' > 1995 & `1' <= 1997 { 19. drop hhid94 20. } 21. * Geography . display "Geography" 22. generate int year = `1' 23. if `1' > 1995 { 24. replace smsa93 = . if smsa93<2 25. } 26. display "smsasize = . if smsasize <=0" 27. replace smsasize = . if smsasize <=0 28. if `1' == 1995 { 29. replace smsastat = smsa995 if intmonth>8 30. replace icntcity = icntct94 if intmonth<9 31. replace centcity = centcitx if intmonth<9 32. replace smsa93 = . if intmonth>=9 & smsa93<2 33. replace smsa93 = . if intmonth<9 34. drop pmsarank 35. generate smsa80 = smsasize if intmonth < 10 36. } 37. if `1' > 1995 & `1' < 1998 { 38. replace smsastat = smsa995 39. } 40. display "replace smsastat = . if smsastat==3 | smsastat<0" 41. replace smsastat = . if smsastat==3 | smsastat<0 42. if `1' == 1994 { 43. drop smsa93 44. replace centcity = centcitx 45. replace icntcity = icntct94 46. replace pmsarank = . if intmonth > 3 47. replace pmsarank = . if pmsarank <= 0 48. replace cmsarank = . if intmonth > 3 49. } 50. if `1' > 1995 & `1' <= 1997 { 51. drop pmsarank 52. } 53. if `1' > 1993 & `1' < 1998 { 54. drop centcitx icntct94 smsa995 55. } 56. if `1' > 1993 { 57. replace hurespli =. if hurespli <0 58. replace peinusyr = . if peinusyr < 0 59. } 60. display "replace centcity = . if centcity==4 | centcity<=0" 61. replace centcity = . if centcity==4 | centcity<=0 62. if `1' >= 1986 & `1' < 1994 { 63. replace pmsarank = . if pmsarank<=0 64. } 65. if `1' >= 1995 & `1' <= 1997 { 66. drop cmsarank 67. } 68. if `1' >= 1986 { 69. replace icntcity = . if icntcity<=0 70. } 71. if `1' > 1984 & `1' < 1995 { 72. replace cmsarank = . if cmsarank<=0 73. } 74. if `1' >= 1989 { 75. replace msafips = . if msafips <=0 76. replace cmsacode = . if cmsacode<=0 77. } 78. if `1' == 1983 { 79. drop docc70 occ70 80. } 81. if `1' == 1985 { 82. replace smsarank = . if intmonth > 9 83. } 84. if `1' == 1984 { 85. display "drop icntcity pmsarank cmsarank" 86. drop icntcity pmsarank cmsarank 87. } 88. if `1' == 1985 & intmonth < 10 { 89. drop icntcity pmsarank cmsarank 90. } 91. if `1' == 1994 { 92. replace cmsarank = . if intmonth>3 93. } 94. display "replace smsasize=. if smsasize<=0" 95. **should line below be commented out??? . replace smsasize=. if smsasize<=0 96. if `1' < 1985 { 97. display "generate byte smsa70 = smsasize" 98. generate byte smsa70 = smsasize 99. } 100. if `1' > 1985 & `1' < 1995 { 101. generate byte smsa80 = smsasize 102. } 103. if `1' == 1985 { 104. generate byte smsa70 = smsasize if intmonth<10 105. } 106. if `1' == 1985 { 107. generate byte smsa80 = smsasize if intmonth>9 108. } 109. display "drop smsasize" 110. drop smsasize 111. if `1' > 1985 & `1' < 1989 { 112. drop smsarank 113. } 114. if `1' < 1983 { 115. display "drop unioncov unionmme occ80 ind80" 116. drop unioncov unionmme occ80 ind80 117. } 118. . * Demography . display "Demography" 119. if `1' > 1983 & `1' < 1994 { 120. replace ownchild = . if ownchild ==0 121. replace ownchild = ownchild - 1 122. generate int ch613=chldpres 123. generate int ch1417=chldpres 124. } 125. display "if `1' > 1983 & `1' < 1989 {" 126. if `1' > 1983 & `1' < 1989 { 127. generate int ch05= chldpres 128. recode ch05 (4 6/8 = 1) (0/3 5 = 0) 129. recode ch613 (3 5 7/8 = 1) (0/2 4 6 = 0) 130. recode ch1417 (2 5/6 8 =1) (0/1 3/4 7 = 0) 131. } 132. if `1' > 1988 & `1' < 1994 { 133. display "if `1' > 1988 & `1' < 1994 {" 134. generate int ch02 = chldpres 135. generate int ch35 = chldpres 136. recode ch02 (2 6/8 12/14 16 = 1) (0/1 3/5 9/11 15 = 0) 137. recode ch35 (3 6 9/10 12/13 15/16 = 1) (0/2 4/5 7/8 11 14 = 0) 138. recode ch613 (4 7 9 11/12 14/16 = 1) (0/3 5/6 8 10 13 = 0) 139. recode ch1417 (5 8 10/11 13/16 = 1) (0/4 6/7 9 12 = 0 ) 140. generate int ch05 = ch02 141. replace ch05 = ch35 if ch35 == 1 142. label variable ch02 "Children 0-2" 143. label variable ch35 "Children 3-5" 144. } 145. if `1' > 1983 & `1' < 1994 { 146. display "if `1' > 1983 & `1' < 1994 {" 147. label variable ch05 "Children 0-5" 148. label variable ch613 "Children 6-13" 149. label variable ch1417 "Children 6-17" 150. } 151. if `1' == 1998 { 152. drop ownchild chldpres 153. } 154. if `1' >= 1999 { 155. replace ownchild = . if ownchild < 0 156. replace chldpres = . if chldpres < 0 157. generate int ch02 = chldpres 158. generate int ch35 = chldpres 159. generate int ch613 = chldpres 160. generate int ch1417 = chldpres 161. recode ch02 (1 5/7 11/13 15 = 1) (0 2/4 8/10 14 = 0) 162. recode ch35 (2 5 8/9 11/12 14/15 = 1) (0/1 3/4 6/7 10 13 =0) 163. recode ch613 (3 6 8 10/11 13/15 = 1) (0/2 4/5 7 9 12 = 0) 164. recode ch1417 (4 7 9/10 12/15 = 1) (0/3 5/6 8 11 = 0) 165. generate int ch05 = ch02 166. replace ch05 = ch35 if ch35 == 1 167. } 168. . if `1' == 1999 { 169. replace ownchild = . if intmonth < 10 170. replace chldpres = . if intmonth < 10 171. replace ch613 = . if intmonth < 10 172. replace ch1417 = . if intmonth < 10 173. replace ch05 = . if intmonth < 10 174. replace ch02 = . if intmonth < 10 175. replace ch35 = . if intmonth < 10 176. } 177. if `1' > 1988 & `1' < 1992 { 178. drop grade92 179. } 180. if `1' < 1989 { 181. replace gradeat = gradeat - 1 182. replace marital = 7 if marital==5 183. } 184. if `1' > 1991 { 185. replace grade92 = . if grade92 < 0 186. } 187. if `1' >= 1998 { 188. replace ged = . if ged < 0 189. replace gedhigr = . if gedhigr < 0 190. replace yrcoll = . if yrcoll < 0 191. replace grprof = . if grprof < 0 192. replace gr6cor = . if gr6cor < 0 193. replace ms123 = . if ms123 < 0 194. generate double ihigrdc = . 195. label var ihigrdc "Imputed highest grade completed" 196. replace ihigrdc = 0 if grade92==31 197. replace ihigrdc = 2.5 if grade92==32 198. replace ihigrdc = 5.5 if grade92==33 199. replace ihigrdc = 7.5 if grade92==34 200. replace ihigrdc = 9 if grade92==35 201. replace ihigrdc =10 if grade92==36 202. replace ihigrdc =11 if grade92==37 203. replace ihigrdc =12 if grade92==38 204. replace ihigrdc = 0 if grade92==39 & ged==2 & gedhigr==1 205. replace ihigrdc = 2.5 if grade92==39 & ged==2 & gedhigr==2 206. replace ihigrdc = 5.5 if grade92==39 & ged==2 & gedhigr==3 207. replace ihigrdc = 7.5 if grade92==39 & ged==2 & gedhigr==4 208. replace ihigrdc = 9 if grade92==39 & ged==2 & gedhigr==5 209. replace ihigrdc = 10 if grade92==39 & ged==2 & gedhigr==6 210. replace ihigrdc = 11 if grade92==39 & ged==2 & gedhigr==7 211. replace ihigrdc = 12 if grade92==39 & ged==2 & gedhigr==8 212. replace ihigrdc = 12 if ged==1 213. replace ihigrdc = 12 if grade92>=40 & grade92<=42 & yrcoll==1 214. replace ihigrdc = 13 if grade92>=40 & grade92<=42 & yrcoll==2 215. replace ihigrdc = 14 if grade92>=40 & grade92<=42 & yrcoll==3 216. replace ihigrdc = 15 if grade92>=40 & grade92<=42 & yrcoll==4 217. replace ihigrdc = 16 if grade92>=40 & grade92<=42 & yrcoll==5 218. replace ihigrdc = 16 if grade92==43 & grprof==2 219. replace ihigrdc = 17 if grade92==43 & gr6cor==2 220. replace ihigrdc = 18 if grade92==43 & gr6cor==1 221. replace ihigrdc = 17 if grade92==44 & ms123==1 222. replace ihigrdc = 18 if grade92==44 & ms123>=2 & ms123<. 223. replace ihigrdc = 18 if grade92==45 | grade92==46 224. } 225. if `1' == 1992 | `1' == 1993 { 226. drop gradecp gradeat 227. } 228. if `1' == 1995 { 229. replace relref94 = . if intmonth > 2 230. replace relref95 = . if intmonth < 3 231. } 232. if `1' > 1995 { 233. drop relref94 234. } 235. if `1' == 1994 { 236. drop relref95 237. } 238. if `1' >= 1994 { 239. replace veteran = . if veteran < 0 240. replace penatvty = . if penatvty < 0 241. replace pemntvty = . if pemntvty < 0 242. replace pefntvty = . if pefntvty < 0 243. replace prcitshp = . if prcitshp < 0 244. replace prcitflg = . if prcitflg < 0 245. } 246. if `1' > 1989 { 247. replace ethnic = . if ethnic < 0 248. replace ethnic = . if ethnic >= 10 249. } 250. . * Employment . display "Employment" 251. if `1' >= 1994 { 252. replace occ80 = . if occ80 <0 253. replace ind80 = . if ind80 < 10 254. replace class94 = . if class94<0 255. } 256. #delimit ; delimiter now ; . display "docc80"; 257. if `1' >= 1983 { > display "generate int docc80=occ80;"; 258. generate int docc80=occ80; 259. display "recode docc80"; 260. 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); 261. }; 262. display "dind"; 263. gen byte dind = . ; 264. if `1'<= 1982 { > display "`1' <= 1982: creating dind from ind70"; 265. replace dind=ind70 ; 266. 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) ; 267. drop blsdind; 268. } ; 269. if `1' <=1991 & `1' >=1983 { > display "replacing dind for `1': `1' <=1991 & `1' >=1983"; 270. replace dind=ind80; 271. 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); 272. display "tabbing `1'" ; 273. tab dind if blsdind != dind ; 274. tab blsdind if blsdind != dind ; 275. tab dind blsdind if blsdind != dind ; 276. } ; 277. if `1' >= 1992 { > display "replacing dind for `1': `1' >= 1992"; 278. replace dind=ind80; 279. 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) ; 280. tab dind if blsdind != dind ; 281. tab blsdind if blsdind != dind ; 282. }; 283. #delimit cr delimiter now cr . * Wages (If earnings are 0, then wage rate is missing, not zero). . display "Wages" 284. replace paidhr = . if paidhr <=0 285. replace paidhre = . if paidhre <=0 286. replace earnhr = . if earnhr <=0 287. replace earnhre = . if earnhre <=0 288. replace earnwke = . if earnwke < 0 289. if `1' < 1989 { 290. replace eligible = 2 if eligible == . 291. } 292. if `1' >= 1989 { 293. replace eligible = 2 if eligible <= 0 294. } 295. if `1' < 1989 { 296. replace I25a = 0 if I25a ==. 297. replace I25b = 0 if I25b ==. 298. replace I25c = 0 if I25c ==. 299. replace I25d = 0 if I25d ==. 300. } 301. if `1' >= 1994 { 302. replace I25a = 0 if I25a <= 3 303. replace I25b = 0 if I25b <= 3 304. *replace I25a = . if I25a < 0 . *replace I25b = . if I25b < 0 . replace earnhre = . if earnhre ==1 305. replace uhourse = . if lfsr94 >2 | lfsr94 <1 306. replace lfsr94 = . if lfsr94 < 0 307. } 308. if `1' >= 1996 { 309. replace I25c = . if I25c < 0 310. replace I25d = . if I25d < 0 311. } 312. if `1' == 1995 { 313. replace I25c = . if I25c < 0 314. replace I25d = . if I25d < 0 315. replace I25c = . if intmonth < 9 316. replace I25d = . if intmonth < 9 317. } 318. if `1' == 1994 { 319. drop I25c I25d 320. } 321. * Hours, Unions . display "Hours, Unions" 322. if `1' >= 1994 { 323. replace reason94 = . if reason94< 0 324. replace absent94 = . if absent94< 0 325. replace studftpt = . if studftpt< 0 326. replace schenr = . if schenr < 0 327. replace schlvl = . if schlvl < 0 328. replace ftpt94 = . if ftpt94 < 0 329. replace hourslw = . if hourslw < 0 330. replace hourslw = 99 if hourslw >99 & hourslw != . 331. replace uhourse = . if uhourse < 0 332. replace why3594 = . if why3594 < 0 333. replace unionmme = . if unionmme< 0 334. replace unioncov = . if unioncov< 0 335. } 336. . ** Revised Census 2000-based Weights . *tempfile annual jan feb mar apr jun jul aug sep oct nov dec . *gen id = _n . *local rwlist qstnum intmonth year occurnum . *sort `rwlist' . *quietly save `annual', replace . *rw `2' jan 1 . *rw `2' feb 2 . *rw `2' mar 3 . *rw `2' apr 4 . *rw `2' may 5 . *rw `2' jun 6 . *rw `2' jul 7 . *rw `2' aug 8 . *rw `2' sep 9 . *rw `2' oct 10 . *rw `2' nov 11 . *rw `2' dec 12 . *local monlist feb mar apr jun jul aug sep oct nov dec . *clear . *use `jan' . *foreach mon in `monlist' { . * append using `mon' . *} . * . *sort id . *drop id . . * Save and exit . compress 337. saveold /home/data/morg/annual/temp/morg`2'rw,replace 338. summarize 339. ! /bin/chmod a+r /home/data/morg/annual/m*.dta 340. ! /bin/chmod g+w /home/data/morg/annual/m*.dta 341. ! /bin/chgrp web /home/data/morg/annual/m*.dta 342. clear 343. ! /bin/rm -f aef.dct /tmp/aef.raw 344. end . . 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 `annual' 2. keep if intmonth==`3' 3. sort `rwlist' 4. merge `rwlist' using /homes/data/morg/annual/rw/rw`2'`1' 5. save `2', replace 6. 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 . *aef2 1980 80 79_83 . *aef2 1981 81 79_83 . *aef2 1982 82 79_83 . aef2 1983 83 79_83 Geography smsasize = . if smsasize <=0 (0 real changes made) replace smsastat = . if smsastat==3 | smsastat<0 (53411 real changes made, 53411 to missing) replace centcity = . if centcity==4 | centcity<=0 (61562 real changes made, 61562 to missing) replace smsasize=. if smsasize<=0 (0 real changes made) generate byte smsa70 = smsasize (236428 missing values generated) drop smsasize Demography if 1983 > 1983 & 1983 < 1989 { (348521 real changes made) (82076 real changes made) Employment docc80 (86372 missing values generated) recode docc80 (docc80: 262149 changes made) dind (348521 missing values generated) dind was byte now int (262149 real changes made) (dind: 262149 changes made) tabbing 1983 dind | Freq. Percent Cum. ------------+----------------------------------- 37 | 546 4.18 4.18 52 | 12,517 95.82 100.00 ------------+----------------------------------- Total | 13,063 100.00 Detailed | industry | code | Freq. Percent Cum. ------------+----------------------------------- 0 | 2,349 15.24 15.24 38 | 546 3.54 18.78 47 | 3,525 22.87 41.66 48 | 1,715 11.13 52.78 49 | 2,040 13.24 66.02 50 | 5,237 33.98 100.00 ------------+----------------------------------- Total | 15,412 100.00 | Detailed industry code dind | 38 47 48 49 50 | Total -----------+-------------------------------------------------------+---------- 37 | 546 0 0 0 0 | 546 52 | 0 3,525 1,715 2,040 5,237 | 12,517 -----------+-------------------------------------------------------+---------- Total | 546 3,525 1,715 2,040 5,237 | 13,063 Wages (0 real changes made) (0 real changes made) (130 real changes made, 130 to missing) (0 real changes made) (0 real changes made) (174589 real changes made) (345921 real changes made) (345442 real changes made) (336774 real changes made) (324506 real changes made) Hours, Unions docc80 was int now byte dind was int now byte file /home/data/morg/annual/temp/morg83rw.dta saved Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- minsamp | 348521 5.997492 2.000001 4 8 intmonth | 348521 6.513714 3.457829 1 12 hhid | 0 state | 348521 53.37944 26.15401 11 95 smsarank | 348521 5.219482 10.54804 0 57 -------------+-------------------------------------------------------- hhnum | 348521 1.085496 .3217394 1 8 activlwr | 348521 2.950118 2.245813 1 7 hourslw | 190986 38.20078 14.14888 1 99 reasonlw | 51906 9.915039 4.043624 1 15 absentlw | 15467 3.835004 2.677151 1 8 -------------+-------------------------------------------------------- classer | 264498 1.397028 .7614176 1 5 ind70 | 262437 708.7819 144.5394 17 937 occ80 | 262149 404.1251 243.9768 3 905 lineno | 348521 1.810399 1.088934 0 32 relahh | 348521 2.431544 1.295036 1 6 -------------+-------------------------------------------------------- age | 348521 42.37974 18.57154 16 99 marital | 348521 2.897561 2.502914 1 7 race | 348521 1.158722 .4452776 1 3 sex | 348521 1.529853 .4991087 1 2 veteran | 164054 4.858675 1.779971 1 6 -------------+-------------------------------------------------------- gradeat | 348521 12.23501 3.062933 0 18 gradecp | 348521 1.225246 .4177449 1 2 esr | 348521 2.661447 2.114205 1 7 weight | 348521 1499.613 712.4353 22.24 10617.25 ind80 | 262149 547.3287 286.0425 10 991 -------------+-------------------------------------------------------- unioncov | 139633 1.960274 .1953144 1 2 blsdind | 264498 29.23571 13.99395 0 51 smsastat | 295110 1.34234 .4744936 1 2 centcity | 286959 2.07063 .7927873 1 3 ethnic | 347769 7.784391 1.133441 1 9 -------------+-------------------------------------------------------- ptstat | 348521 .6392183 1.801896 0 6 ftpt79 | 348521 1.067921 1.228882 0 5 doinglw | 348024 3.023527 2.392589 1 8 hourslwa | 190508 38.17607 14.17428 0 99 uhours35 | 51339 1.700345 .4581114 1 2 -------------+-------------------------------------------------------- why35lw | 51453 9.915846 4.044108 1 15 class | 263375 2.034441 1.832809 1 8 uhours | 172494 37.46962 11.1351 0 99 paidhr | 172032 1.414504 .4926377 1 2 earnhr | 89765 655.7097 370.8328 1 9999 -------------+-------------------------------------------------------- uearnwk | 150653 303.3553 206.3797 0 999 earnwt | 348521 5999.475 2862.394 90.01 41428.26 eligible | 348521 1.500943 .4999998 1 2 uhourse | 173932 37.50175 11.05899 0 99 paidhre | 173932 1.412253 .4922417 1 2 -------------+-------------------------------------------------------- earnhre | 102228 662.8943 362.3422 50 9999 earnwke | 173932 307.5514 207.0172 0 999 unionmme | 173932 1.803038 .3977045 1 2 I25a | 348521 .0074601 .0860492 0 1 I25b | 348521 .0088345 .0935759 0 1 -------------+-------------------------------------------------------- I25c | 348521 .0337053 .1804698 0 1 I25d | 348521 .0689055 .2532937 0 1 uearnwke | 102228 247.3718 161.8239 0 999 year | 348521 1983 0 1983 1983 smsa70 | 112093 1.612152 .4872617 1 2 -------------+-------------------------------------------------------- docc80 | 262149 24.77129 12.15505 1 46 dind | 262149 29.65229 14.00936 1 52 . aef2 1984 84 84_88 Geography smsasize = . if smsasize <=0 (0 real changes made) replace smsastat = . if smsastat==3 | smsastat<0 (52042 real changes made, 52042 to missing) replace centcity = . if centcity==4 | centcity<=0 (60378 real changes made, 60378 to missing) drop icntcity pmsarank cmsarank replace smsasize=. if smsasize<=0 (0 real changes made) generate byte smsa70 = smsasize (260231 missing values generated) drop smsasize Demography (57586 real changes made, 57586 to missing) (286079 real changes made) if 1984 > 1983 & 1984 < 1989 { (ch05: 286079 changes made) (ch613: 286079 changes made) (ch1417: 286079 changes made) if 1984 > 1983 & 1984 < 1994 { (343665 real changes made) (81303 real changes made) Employment docc80 (84867 missing values generated) recode docc80 (docc80: 258798 changes made) dind (343665 missing values generated) dind was byte now int (258798 real changes made) (dind: 258798 changes made) tabbing 1984 dind | Freq. Percent Cum. ------------+----------------------------------- 37 | 655 5.17 5.17 52 | 12,008 94.83 100.00 ------------+----------------------------------- Total | 12,663 100.00 Detailed | industry | code | Freq. Percent Cum. ------------+----------------------------------- 0 | 2,055 13.96 13.96 38 | 655 4.45 18.41 47 | 3,475 23.61 42.02 48 | 1,513 10.28 52.30 49 | 1,996 13.56 65.86 50 | 5,024 34.14 100.00 ------------+----------------------------------- Total | 14,718 100.00 | Detailed industry code dind | 38 47 48 49 50 | Total -----------+-------------------------------------------------------+---------- 37 | 655 0 0 0 0 | 655 52 | 0 3,475 1,513 1,996 5,024 | 12,008 -----------+-------------------------------------------------------+---------- Total | 655 3,475 1,513 1,996 5,024 | 12,663 Wages (0 real changes made) (0 real changes made) (139 real changes made, 139 to missing) (0 real changes made) (0 real changes made) (166417 real changes made) (340647 real changes made) (340000 real changes made) (330739 real changes made) (317565 real changes made) Hours, Unions ch613 was int now byte ch1417 was int now byte ch05 was int now byte docc80 was int now byte dind was int now byte file /home/data/morg/annual/temp/morg84rw.dta saved Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- minsamp | 343665 6.018733 1.999915 4 8 hhid | 0 state | 343665 52.94592 26.21478 11 95 smsarank | 343665 5.208657 10.52625 0 57 schenr | 67249 1.60679 .4884665 1 2 -------------+-------------------------------------------------------- schlvl | 26443 1.494119 .4999749 1 2 hhnum | 343665 1.091967 .3292597 1 8 activlwr | 343665 2.899946 2.248446 1 7 hourslw | 194147 38.67536 13.99387 1 99 reasonlw | 50027 10.10916 3.922843 1 15 -------------+-------------------------------------------------------- absentlw | 14140 3.595827 2.646903 1 8 classer | 260853 1.385236 .7467635 1 5 lineno | 343665 1.798656 1.080923 0 36 relahh | 343665 2.425787 1.294567 1 6 age | 343665 42.42364 18.52201 16 99 -------------+-------------------------------------------------------- marital | 343665 2.907369 2.505176 1 7 race | 343665 1.160287 .4479898 1 3 sex | 343665 1.530744 .4990547 1 2 veteran | 161889 4.880949 1.773514 1 6 gradeat | 343665 12.30682 3.033712 0 18 -------------+-------------------------------------------------------- gradecp | 343665 1.222187 .415717 1 2 esr | 343665 2.626823 2.128543 1 7 studftpt | 26443 1.113754 .3175184 1 2 intmonth | 343665 6.497298 3.455863 1 12 weight | 343665 1539.723 779.9211 23.15 16655.71 -------------+-------------------------------------------------------- smsastat | 291623 1.335951 .4723226 1 2 centcity | 283287 2.066438 .7879235 1 3 ethnic | 342905 7.777338 1.142623 1 9 ptstat | 343665 .6296713 1.793381 0 6 ftpt79 | 343665 1.044878 1.203676 0 5 -------------+-------------------------------------------------------- doinglw | 343148 2.967763 2.386222 1 8 hourslwa | 193609 38.64001 14.03294 0 99 uhours35 | 49363 1.709256 .4541103 1 2 why35lw | 49476 10.10983 3.922558 1 15 class | 259518 2.014161 1.814957 1 8 -------------+-------------------------------------------------------- uhours | 175777 37.76727 11.07017 0 99 paidhr | 174954 1.413577 .4924759 1 2 earnhr | 90719 674.1399 378.9471 1 9999 uearnwk | 151915 318.304 215.6998 0 999 earnwt | 343665 6161.268 3132.74 93.28 68606.39 -------------+-------------------------------------------------------- eligible | 343665 1.484242 .4997523 1 2 uhourse | 177248 37.80939 10.96385 0 99 paidhre | 177248 1.409979 .4918309 1 2 earnhre | 104580 682.9258 377.0261 50 9999 earnwke | 177248 322.4493 215.8607 0 999 -------------+-------------------------------------------------------- unionmme | 177248 1.814266 .3888931 1 2 I25a | 343665 .0087818 .0932991 0 1 I25b | 343665 .0106645 .1027169 0 1 I25c | 343665 .0376122 .1902568 0 1 I25d | 343665 .0759461 .2649122 0 1 -------------+-------------------------------------------------------- uearnwke | 104580 257.0817 167.2497 0 999 unionmm | 174659 1.814433 .3887582 1 2 unioncov | 143212 1.953803 .2099128 1 2 blsdind | 260853 29.27701 13.91338 0 51 ind80 | 258798 548.2273 284.3926 10 991 -------------+-------------------------------------------------------- occ80 | 258798 400.6177 245.0892 3 905 famnum | 343665 .8561041 .4080798 0 5 ownchild | 286079 .9393944 1.17641 0 8 chldpres | 343665 2.086194 2.019784 0 8 pfamrel | 343665 1.796348 1.344383 0 5 -------------+-------------------------------------------------------- year | 343665 1984 0 1984 1984 smsa70 | 83434 1.614941 .4866121 1 2 ch613 | 343665 .2191262 .4136549 0 1 ch1417 | 343665 .1887769 .3913318 0 1 ch05 | 343665 .1606652 .3672224 0 1 -------------+-------------------------------------------------------- docc80 | 258798 24.53068 12.20869 1 46 dind | 258798 29.65944 13.94557 1 52 . aef2 1985 85 84_88 Geography smsasize = . if smsasize <=0 (26898 real changes made, 26898 to missing) replace smsastat = . if smsastat==3 | smsastat<0 (28172 real changes made, 28172 to missing) replace centcity = . if centcity==4 | centcity<=0 (44790 real changes made, 44790 to missing) (26898 real changes made, 26898 to missing) (86232 real changes made, 86232 to missing) replace smsasize=. if smsasize<=0 (0 real changes made) (315355 missing values generated) (284257 missing values generated) drop smsasize Demography (59464 real changes made, 59464 to missing) (284127 real changes made) if 1985 > 1983 & 1985 < 1989 { (ch05: 284127 changes made) (ch613: 284127 changes made) (ch1417: 284127 changes made) if 1985 > 1983 & 1985 < 1994 { (343591 real changes made) (81764 real changes made) Employment docc80 (84502 missing values generated) recode docc80 (docc80: 259089 changes made) dind (343591 missing values generated) dind was byte now int (259089 real changes made) (dind: 259089 changes made) tabbing 1985 dind | Freq. Percent Cum. ------------+----------------------------------- 37 | 774 6.04 6.04 52 | 12,050 93.96 100.00 ------------+----------------------------------- Total | 12,824 100.00 Detailed | industry | code | Freq. Percent Cum. ------------+----------------------------------- 0 | 1,839 12.54 12.54 38 | 774 5.28 17.82 47 | 3,465 23.63 41.45 48 | 1,587 10.82 52.27 49 | 1,986 13.54 65.82 50 | 5,012 34.18 100.00 ------------+----------------------------------- Total | 14,663 100.00 | Detailed industry code dind | 38 47 48 49 50 | Total -----------+-------------------------------------------------------+---------- 37 | 774 0 0 0 0 | 774 52 | 0 3,465 1,587 1,986 5,012 | 12,050 -----------+-------------------------------------------------------+---------- Total | 774 3,465 1,587 1,986 5,012 | 12,824 Wages (0 real changes made) (0 real changes made) (158 real changes made, 158 to missing) (0 real changes made) (0 real changes made) (163359 real changes made) (340407 real changes made) (339831 real changes made) (330677 real changes made) (317872 real changes made) Hours, Unions ch613 was int now byte ch1417 was int now byte ch05 was int now byte docc80 was int now byte dind was int now byte file /home/data/morg/annual/temp/morg85rw.dta saved Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- minsamp | 343591 6.006758 1.999991 4 8 hhid | 0 state | 343591 51.33941 26.06169 11 95 smsarank | 257359 3.511733 9.005105 0 57 schenr | 64899 1.623769 .4844428 1 2 -------------+-------------------------------------------------------- schlvl | 24417 1.477987 .4995254 1 2 hhnum | 343591 1.088154 .3204148 1 8 activlwr | 343591 2.9089 2.275778 1 7 hourslw | 195489 38.83549 13.87874 1 99 reasonlw | 49342 10.18935 3.892784 1 15 -------------+-------------------------------------------------------- absentlw | 14543 3.554012 2.618309 1 8 classer | 260928 1.368845 .7266629 1 5 lineno | 343591 1.784584 1.061058 0 31 relahh | 343591 2.422956 1.297635 1 6 age | 343591 42.56664 18.46448 16 99 -------------+-------------------------------------------------------- marital | 343591 2.924937 2.507229 1 7 race | 343591 1.161241 .4468883 1 3 sex | 343591 1.531641 .4989986 1 2 veteran | 251916 5.286107 1.516428 1 6 gradeat | 343591 12.36867 3.014508 0 18 -------------+-------------------------------------------------------- gradecp | 343591 1.218882 .4134892 1 2 esr | 343591 2.629592 2.152968 1 7 studftpt | 24417 1.092722 .2900488 1 2 intmonth | 343591 6.498558 3.454322 1 12 weight | 343591 1555.97 743.511 38.05 20548.99 -------------+-------------------------------------------------------- smsastat | 315419 1.294415 .4557799 1 2 centcity | 213774 2.053655 .781938 1 3 ethnic | 342892 7.779298 1.128798 1 9 ptstat | 343591 .6217974 1.785371 0 6 ftpt79 | 343591 1.043491 1.199024 0 5 -------------+-------------------------------------------------------- doinglw | 343019 2.979059 2.416207 1 8 hourslwa | 194990 38.79767 13.91569 0 99 uhours35 | 48687 1.70524 .4559397 1 2 why35lw | 48820 10.18626 3.892225 1 15 class | 259797 1.978722 1.782954 1 8 -------------+-------------------------------------------------------- uhours | 178925 37.88957 11.1269 0 99 paidhr | 178216 1.413089 .4923899 1 2 earnhr | 92890 700.7255 404.3421 1 9999 uearnwk | 155730 333.2232 224.6136 0 999 earnwt | 343591 6227.852 2996.579 151.49 83988.15 -------------+-------------------------------------------------------- eligible | 343591 1.475446 .4993975 1 2 uhourse | 180232 37.96892 10.96679 0 99 paidhre | 180232 1.409123 .4916733 1 2 earnhre | 106495 709.4404 397.2761 50 9999 earnwke | 180232 337.6849 224.2307 0 999 -------------+-------------------------------------------------------- unionmme | 180232 1.821425 .3829974 1 2 I25a | 343591 .0092668 .0958175 0 1 I25b | 343591 .0109432 .1040361 0 1 I25c | 343591 .0375854 .1901916 0 1 I25d | 343591 .0748535 .2631552 0 1 -------------+-------------------------------------------------------- uearnwke | 106495 267.6373 174.3618 0 999 unionmm | 177849 1.822068 .3824564 1 2 unioncov | 147208 1.958148 .2002523 1 2 blsdind | 260928 29.4961 13.76057 0 51 ind80 | 259089 552.5288 281.9046 10 991 -------------+-------------------------------------------------------- occ80 | 259089 396.0338 244.8626 3 905 famnum | 343591 .8496934 .4115308 0 8 ownchild | 284127 .9246851 1.183464 0 8 chldpres | 343591 2.049891 2.008151 0 8 pfamrel | 343591 1.79035 1.356084 0 5 -------------+-------------------------------------------------------- year | 343591 1985 0 1985 1985 smsa70 | 28236 1.619422 .4855376 1 2 smsa80 | 59334 5.24566 1.894542 2 8 ch613 | 343591 .2109689 .4079969 0 1 ch1417 | 343591 .1839891 .3874759 0 1 -------------+-------------------------------------------------------- ch05 | 343591 .1595181 .3661591 0 1 docc80 | 259089 24.24333 12.20356 1 46 dind | 259089 29.85553 13.80779 1 52 . aef2 1986 86 84_88 Geography smsasize = . if smsasize <=0 (104502 real changes made, 104502 to missing) replace smsastat = . if smsastat==3 | smsastat<0 (5614 real changes made, 5614 to missing) replace centcity = . if centcity==4 | centcity<=0 (61198 real changes made, 61198 to missing) (223096 real changes made, 223096 to missing) (319386 real changes made, 319386 to missing) (104502 real changes made, 104502 to missing) replace smsasize=. if smsasize<=0 (0 real changes made) (104502 missing values generated) drop smsasize Demography (59768 real changes made, 59768 to missing) (278283 real changes made) if 1986 > 1983 & 1986 < 1989 { (ch05: 278283 changes made) (ch613: 278283 changes made) (ch1417: 278283 changes made) if 1986 > 1983 & 1986 < 1994 { (338051 real changes made) (80608 real changes made) Employment docc80 (82997 missing values generated) recode docc80 (docc80: 255054 changes made) dind (338051 missing values generated) dind was byte now int (255054 real changes made) (dind: 255054 changes made) tabbing 1986 dind | Freq. Percent Cum. ------------+----------------------------------- 37 | 720 5.73 5.73 52 | 11,836 94.27 100.00 ------------+----------------------------------- Total | 12,556 100.00 Detailed | industry | code | Freq. Percent Cum. ------------+----------------------------------- 0 | 1,805 12.57 12.57 38 | 720 5.01 17.58 47 | 3,588 24.98 42.57 48 | 1,526 10.63 53.19 49 | 1,956 13.62 66.81 50 | 4,766 33.19 100.00 ------------+----------------------------------- Total | 14,361 100.00 | Detailed industry code dind | 38 47 48 49 50 | Total -----------+-------------------------------------------------------+---------- 37 | 720 0 0 0 0 | 720 52 | 0 3,588 1,526 1,956 4,766 | 11,836 -----------+-------------------------------------------------------+---------- Total | 720 3,588 1,526 1,956 4,766 | 12,556 Wages (0 real changes made) (0 real changes made) (189 real changes made, 189 to missing) (0 real changes made) (0 real changes made) (158904 real changes made) (335643 real changes made) (335492 real changes made) (328854 real changes made) (318906 real changes made) Hours, Unions ch613 was int now byte ch1417 was int now byte ch05 was int now byte docc80 was int now byte dind was int now byte file /home/data/morg/annual/temp/morg86rw.dta saved Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- minsamp | 338051 5.997935 2.000002 4 8 hhid | 0 state | 338051 50.66852 25.97249 11 95 schenr | 61760 1.616548 .4862308 1 2 schlvl | 23682 1.453129 .4978088 1 2 -------------+-------------------------------------------------------- hhnum | 338051 1.089841 .3228626 1 7 activlwr | 338051 2.898944 2.284779 1 7 hourslw | 194172 38.83633 13.87146 1 99 reasonlw | 49143 10.25247 3.869305 1 15 absentlw | 13842 3.593339 2.6568 1 8 -------------+-------------------------------------------------------- classer | 256859 1.361549 .7203403 1 5 lineno | 338051 1.777264 1.056413 0 36 relahh | 338051 2.421076 1.298227 1 6 age | 338051 42.7048 18.46196 16 90 marital | 338051 2.937385 2.506602 1 7 -------------+-------------------------------------------------------- race | 338051 1.16417 .451371 1 3 sex | 338051 1.532579 .4989382 1 2 veteran | 337634 5.487498 1.3231 1 6 gradeat | 338051 12.42094 2.998146 0 18 gradecp | 338051 1.21597 .4114944 1 2 -------------+-------------------------------------------------------- esr | 338051 2.6244 2.166289 1 7 studftpt | 23682 1.082003 .2743754 1 2 intmonth | 338051 6.474337 3.461136 1 12 weight | 338051 1602.599 765.836 102.63 10973.91 cmsarank | 233549 42.25287 54.00693 1 252 -------------+-------------------------------------------------------- pmsarank | 114955 1.76376 1.539188 1 12 icntcity | 18665 1.143477 .4425751 1 4 smsastat | 332437 1.262209 .4398364 1 2 centcity | 276853 2.027466 .7755566 1 3 ethnic | 337490 7.776699 1.133001 1 9 -------------+-------------------------------------------------------- ptstat | 338051 .6321679 1.80012 0 6 ftpt79 | 338051 1.051072 1.203647 0 5 doinglw | 337575 2.965848 2.419125 1 8 hourslwa | 193875 38.80847 13.9013 0 99 uhours35 | 48483 1.70831 .454545 1 2 -------------+-------------------------------------------------------- why35lw | 48686 10.25334 3.867566 1 15 class | 256120 1.96497 1.771811 1 8 uhours | 178547 37.84776 11.10662 0 99 paidhr | 178290 1.411038 .4920235 1 2 earnhr | 96731 720.1781 399.4528 1 9999 -------------+-------------------------------------------------------- uearnwk | 160469 347.9379 231.057 1 999 earnwt | 338051 6412.018 3081.335 373.95 45215.87 eligible | 338051 1.470059 .4991035 1 2 uhourse | 179147 37.91343 10.96731 0 99 paidhre | 179147 1.40723 .4913197 1 2 -------------+-------------------------------------------------------- earnhre | 106193 727.3332 395.406 50 9999 earnwke | 179147 349.2177 231.4662 0 999 unionmme | 179147 1.826885 .3783476 1 2 I25a | 338051 .0071232 .084098 0 1 I25b | 338051 .0075699 .0866752 0 1 -------------+-------------------------------------------------------- I25c | 338051 .027206 .1626833 0 1 I25d | 338051 .0566335 .2311412 0 1 uearnwke | 106193 274.7858 178.7272 0 999 unionmm | 177997 1.827227 .3780516 1 2 unioncov | 148266 1.961077 .1934128 1 2 -------------+-------------------------------------------------------- blsdind | 256859 29.61878 13.69384 0 51 ind80 | 255054 555.2598 280.846 10 991 occ80 | 255054 392.6732 245.7122 3 905 famnum | 338051 .8469284 .415472 0 5 ownchild | 278283 .9203293 1.171213 0 8 -------------+-------------------------------------------------------- chldpres | 338051 2.03695 2.004394 0 8 pfamrel | 338051 1.787121 1.364143 0 5 year | 338051 1986 0 1986 1986 smsa80 | 233549 5.24153 1.895538 2 8 ch613 | 338051 .207661 .4056333 0 1 -------------+-------------------------------------------------------- ch1417 | 338051 .1846289 .3879968 0 1 ch05 | 338051 .1590263 .3657012 0 1 docc80 | 255054 24.03524 12.24898 1 46 dind | 255054 29.98021 13.74031 1 52 . aef2 1987 87 84_88 Geography smsasize = . if smsasize <=0 (103786 real changes made, 103786 to missing) replace smsastat = . if smsastat==3 | smsastat<0 (5427 real changes made, 5427 to missing) replace centcity = . if centcity==4 | centcity<=0 (61713 real changes made, 61713 to missing) (223694 real changes made, 223694 to missing) (318875 real changes made, 318875 to missing) (103786 real changes made, 103786 to missing) replace smsasize=. if smsasize<=0 (0 real changes made) (103786 missing values generated) drop smsasize Demography (59996 real changes made, 59996 to missing) (277004 real changes made) if 1987 > 1983 & 1987 < 1989 { (ch05: 277004 changes made) (ch613: 277004 changes made) (ch1417: 277004 changes made) if 1987 > 1983 & 1987 < 1994 { (337000 real changes made) (80318 real changes made) Employment docc80 (82398 missing values generated) recode docc80 (docc80: 254602 changes made) dind (337000 missing values generated) dind was byte now int (254602 real changes made) (dind: 254602 changes made) tabbing 1987 dind | Freq. Percent Cum. ------------+----------------------------------- 37 | 716 5.76 5.76 52 | 11,710 94.24 100.00 ------------+----------------------------------- Total | 12,426 100.00 Detailed | industry | code | Freq. Percent Cum. ------------+----------------------------------- 0 | 1,560 11.15 11.15 38 | 716 5.12 16.27 47 | 3,678 26.30 42.57 48 | 1,433 10.25 52.82 49 | 1,861 13.31 66.12 50 | 4,738 33.88 100.00 ------------+----------------------------------- Total | 13,986 100.00 | Detailed industry code dind | 38 47 48 49 50 | Total -----------+-------------------------------------------------------+---------- 37 | 716 0 0 0 0 | 716 52 | 0 3,678 1,433 1,861 4,738 | 11,710 -----------+-------------------------------------------------------+---------- Total | 716 3,678 1,433 1,861 4,738 | 12,426 Wages (0 real changes made) (0 real changes made) (129 real changes made, 129 to missing) (0 real changes made) (0 real changes made) (156566 real changes made) (334718 real changes made) (334825 real changes made) (325003 real changes made) (312586 real changes made) Hours, Unions ch613 was int now byte ch1417 was int now byte ch05 was int now byte docc80 was int now byte dind was int now byte file /home/data/morg/annual/temp/morg87rw.dta saved Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- minsamp | 337000 5.993128 1.999991 4 8 hhid | 0 state | 337000 50.81561 25.88324 11 95 schenr | 60046 1.603138 .4892511 1 2 schlvl | 23830 1.450986 .4976023 1 2 -------------+-------------------------------------------------------- hhnum | 337000 1.08854 .3178388 1 7 activlwr | 337000 2.892389 2.302566 1 7 hourslw | 195740 38.74444 13.88584 1 99 reasonlw | 53544 10.04159 3.797732 1 15 absentlw | 13694 3.47948 2.612177 1 8 -------------+-------------------------------------------------------- classer | 256162 1.360128 .7123716 1 5 lineno | 337000 1.766258 1.033067 0 32 relahh | 337000 2.418101 1.300159 1 6 age | 337000 42.88126 18.45139 16 90 marital | 337000 2.939786 2.50625 1 7 -------------+-------------------------------------------------------- race | 337000 1.165543 .4535547 1 3 sex | 337000 1.533329 .4988887 1 2 veteran | 336618 5.495505 1.314929 1 6 gradeat | 337000 12.46645 2.991089 0 18 gradecp | 337000 1.215039 .4108497 1 2 -------------+-------------------------------------------------------- esr | 337000 2.6217 2.185364 1 7 studftpt | 23830 1.087117 .2820125 1 2 intmonth | 337000 6.513285 3.454732 1 12 weight | 337000 1626.879 788.1528 127.31 10647.89 cmsarank | 233214 42.76547 54.40907 1 252 -------------+-------------------------------------------------------- pmsarank | 113306 1.755873 1.518415 1 12 icntcity | 18125 1.152662 .4597328 1 4 smsastat | 331573 1.260995 .439178 1 2 centcity | 275287 2.03027 .7730033 1 3 ethnic | 336489 7.772058 1.139999 1 9 -------------+-------------------------------------------------------- ptstat | 337000 .6339347 1.804296 0 6 ftpt79 | 337000 1.047576 1.200605 0 5 doinglw | 336557 2.958215 2.434539 1 8 hourslwa | 195538 38.70954 13.92817 0 99 uhours35 | 52889 1.649455 .4771453 1 2 -------------+-------------------------------------------------------- why35lw | 53024 10.04389 3.796089 1 15 class | 255441 1.964168 1.761925 1 8 uhours | 179887 38.01874 11.1407 0 99 paidhr | 179883 1.404418 .4907805 1 2 earnhr | 95725 740.7755 413.1646 1 9900 -------------+-------------------------------------------------------- uearnwk | 156131 359.7606 237.3426 0 999 earnwt | 337000 6507.827 3167.933 417.75 43415.1 eligible | 337000 1.464588 .4987451 1 2 uhourse | 180434 38.09249 11.00029 0 99 paidhre | 180434 1.400756 .490053 1 2 -------------+-------------------------------------------------------- earnhre | 108124 750.4134 408.5974 50 9900 earnwke | 180434 362.3267 238.4399 0 999 unionmme | 180434 1.83103 .3747268 1 2 I25a | 337000 .0067715 .0820102 0 1 I25b | 337000 .006454 .0800773 0 1 -------------+-------------------------------------------------------- I25c | 337000 .0355994 .1852895 0 1 I25d | 337000 .0724451 .2592239 0 1 uearnwke | 108124 284.5339 183.8061 0 999 unionmm | 179546 1.831247 .374535 1 2 unioncov | 150404 1.963877 .1865961 1 2 -------------+-------------------------------------------------------- blsdind | 256162 29.83635 13.57961 0 51 ind80 | 254602 558.9582 279.4016 10 991 occ80 | 254602 390.3029 246.056 3 905 famnum | 337000 .8452196 .4156782 0 4 ownchild | 277004 .906023 1.165527 0 8 -------------+-------------------------------------------------------- chldpres | 337000 2.020546 1.997076 0 8 pfamrel | 337000 1.787418 1.369653 0 5 year | 337000 1987 0 1987 1987 smsa80 | 233214 5.218602 1.891606 2 8 ch613 | 337000 .207 .4051561 0 1 -------------+-------------------------------------------------------- ch1417 | 337000 .179819 .3840372 0 1 ch05 | 337000 .1569258 .3637314 0 1 docc80 | 254602 23.89632 12.28068 1 46 dind | 254602 30.17024 13.64393 1 52 . aef2 1988 88 84_88 Geography smsasize = . if smsasize <=0 (103403 real changes made, 103403 to missing) replace smsastat = . if smsastat==3 | smsastat<0 (5427 real changes made, 5427 to missing) replace centcity = . if centcity==4 | centcity<=0 (61499 real changes made, 61499 to missing) (220202 real changes made, 220202 to missing) (305127 real changes made, 305127 to missing) (103403 real changes made, 103403 to missing) replace smsasize=. if smsasize<=0 (0 real changes made) (103403 missing values generated) drop smsasize Demography (58612 real changes made, 58612 to missing) (262209 real changes made) if 1988 > 1983 & 1988 < 1989 { (ch05: 262209 changes made) (ch613: 262209 changes made) (ch1417: 262209 changes made) if 1988 > 1983 & 1988 < 1994 { (320821 real changes made) (75864 real changes made) Employment docc80 (78245 missing values generated) recode docc80 (docc80: 242576 changes made) dind (320821 missing values generated) dind was byte now int (242576 real changes made) (dind: 242576 changes made) tabbing 1988 dind | Freq. Percent Cum. ------------+----------------------------------- 37 | 707 5.85 5.85 52 | 11,385 94.15 100.00 ------------+----------------------------------- Total | 12,092 100.00 Detailed | industry | code | Freq. Percent Cum. ------------+----------------------------------- 0 | 1,285 9.61 9.61 38 | 707 5.29 14.89 47 | 3,543 26.49 41.38 48 | 1,407 10.52 51.90 49 | 1,883 14.08 65.97 50 | 4,552 34.03 100.00 ------------+----------------------------------- Total | 13,377 100.00 | Detailed industry code dind | 38 47 48 49 50 | Total -----------+-------------------------------------------------------+---------- 37 | 707 0 0 0 0 | 707 52 | 0 3,543 1,407 1,883 4,552 | 11,385 -----------+-------------------------------------------------------+---------- Total | 707 3,543 1,407 1,883 4,552 | 12,092 Wages (0 real changes made) (0 real changes made) (133 real changes made, 133 to missing) (0 real changes made) (0 real changes made) (147703 real changes made) (318458 real changes made) (318666 real changes made) (308237 real changes made) (295818 real changes made) Hours, Unions ch613 was int now byte ch1417 was int now byte ch05 was int now byte docc80 was int now byte dind was int now byte (note: file /home/data/morg/annual/temp/morg88rw.dta not found) file /home/data/morg/annual/temp/morg88rw.dta saved Variable | Obs Mean Std. Dev. Min Max -------------+-------------------------------------------------------- minsamp | 320821 5.99189 1.999987 4 8 hhid | 0 state | 320821 50.61581 25.34102 11 95 schenr | 55059 1.600519 .4897961 1 2 schlvl | 21995 1.462651 .4986144 1 2 -------------+-------------------------------------------------------- hhnum | 320821 1.08477 .3119935 1 8 activlwr | 320821 2.88483 2.316998 1 7 hourslw | 188503 39.16508 13.94417 1 99 reasonlw | 47256 10.40069 3.811482 1 15 absentlw | 12432 3.469514 2.645986 1 8 -------------+-------------------------------------------------------- classer | 243861 1.360156 .7068174 1 5 lineno | 320821 1.752111 1.018233 0 30 relahh | 320821 2.413997 1.304434 1 6 age | 320821 43.17714 18.44137 16 90 marital | 320821 2.929309 2.502842 1 7 -------------+-------------------------------------------------------- race | 320821 1.163371 .451722 1 3 sex | 320821 1.531904 .4989819 1 2 veteran | 320476 5.50791 1.30066 1 6 gradeat | 320821 12.50949 2.983557 0 18 gradecp | 320821 1.213895 .4100542 1 2 -------------+-------------------------------------------------------- esr | 320821 2.62024 2.205779 1 7 studftpt | 21995 1.091021 .2876451 1 2 intmonth | 320821 6.440217 3.482284 1 12 weight | 320821 1726.314 984.2418 118.96 12757.97 cmsarank | 217418 45.24634 55.40494 1 252 -------------+-------------------------------------------------------- pmsarank | 100619 1.805345 1.576072 1 12 icntcity | 15694 1.146808 .44372 1 4 smsastat | 315394 1.272767 .4453826 1 2 centcity | 259322 2.060253 .7743451 1 3 ethnic | 319967 7.78385 1.114728 1 9 -------------+-------------------------------------------------------- ptstat | 320821 .6426076 1.817401 0 6 ftpt79 | 320821 1.042591 1.194696 0 5 doinglw | 320373 2.949331 2.445982 1 8 hourslwa | 188282 39.12394 13.9886 0 99 uhours35 | 46617 1.708175 .454607 1 2 -------------+-------------------------------------------------------- why35lw | 46750 10.40171 3.80921 1 15 class | 243182 1.970779 1.762168 1 8 uhours | 172485 38.10206 11.11575 0 99 paidhr | 172415 1.40185 .4902734 1 2 earnhr | 91418 762.4043 428.0574 1 9999 -------------+-------------------------------------------------------- uearnwk | 148188 370.7305 242.9891 0 999 earnwt | 320821 6905.679 3949.607 357.98 50995.55 eligible | 320821 1.460391 .4984294 1 2 uhourse | 173118 38.18686 10.963 0 99 paidhre | 173118 1.398145 .489517 1 2 -------------+-------------------------------------------------------- earnhre | 104192 773.36 423.3943 50 9900 earnwke | 173118 373.3713 243.4652 0 999 unionmme | 173118 1.835915 .3703534 1 2 I25a | 320821 .0073655 .0855059 0 1 I25b | 320821 .0067171 .0816826 0 1 -------------+-------------------------------------------------------- I25c | 320821 .0392244 .1941286 0 1 I25d | 320821 .0779344 .2680688 0 1 uearnwke | 104192 293.2954 188.3674 0 999 unionmm | 172193 1.836329 .3699778 1 2 unioncov | 145168 1.963732 .1869577 1 2 -------------+-------------------------------------------------------- blsdind | 243861 29.9094 13.60851 0 51 ind80 | 242576 559.9783 280.323 10 991 occ80 | 242576 387.9549 246.6491 3 905 famnum | 320821 .8399793 .4185734 0 8 ownchild | 262209 .8850154 1.154143 0 8 -------------+-------------------------------------------------------- chldpres | 320821 1.992606 1.992762 0 8 pfamrel | 320821 1.770919 1.370001 0 5 year | 320821 1988 0 1988 1988 smsa80 | 217418 5.080417 1.849605 2 8 ch613 | 320821 .2063362 .4046753 0 1 -------------+-------------------------------------------------------- ch1417 | 320821 .1702226 .3758289 0 1 ch05 | 320821 .1534095 .3603824 0 1 docc80 | 242576 23.78166 12.36716 1 46 dind | 242576 30.22198 13.69772 1 52 . aef2 1989 89 89_93 Geography smsasize = . if smsasize <=0 (104372 real changes made, 104372 to missing) replace smsastat = . if smsastat==3 | smsastat<0 (5576 real changes made, 5576 to missing) replace centcity = . if centcity==4 | centcity<=0 (62099 real changes made, 62099 to missing) (222527 real changes made, 222527 to missing) (308970 real changes made, 308970 to missing) (104372 real changes made, 104372 to missing) (107765 real changes made, 107765 to missing) (219134 real changes made, 219134 to missing) replace smsasize=. if smsasize<=0 (0 real changes made) (104372 missing values generated) drop smsasize Demography (60600 real changes made, 60600 to missing) (264111 real changes made) if 1989 > 1983 & 1989 < 1989 { if 1989 > 1988 & 1989 < 1994 { (ch02: 264111 changes made) (ch35: 264111 changes made) (ch613: 264111 changes made) (ch1417: 264111 changes made) (20705 real changes made) if 1989 > 1983 & 1989 < 1994 { Employment docc80 (78270 missing values generated) recode docc80 (docc80: 246441 changes made) dind (324711 missing values generated) dind was byte now int (246441 real changes made) (dind: 246441 changes made) tabbing 1989 blsdind not found r(111); end of do-file r(111); . exit,clear