{smcl} {com}{sf}{ul off}{txt}{.-} log: {res}/disk/nber10/SCCS/morg/sources/annual200log.smcl {txt}log type: {res}smcl {txt}opened on: {res}29 Sep 2009, 13:29:17 {txt} {com}. set memory 2000m {txt}(2048000k) {com}. set more 1 {txt} {com}. *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 {txt} {com}. . program rw {txt} 1{com}. * 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 {txt} 2{com}. keep if intmonth==`3' {txt} 3{com}. quietly describe {txt} 4{com}. display "`3' `2' obs " r(N) {txt} 5{com}. local rwlist qstnum intmonth year occurnum {txt} 6{com}. sort `rwlist' {txt} 7{com}. merge `rwlist' using /homes/data/morg/annual/rw/rw`2'`1' {txt} 8{com}. drop if _merge == 2 {txt} 9{com}. save /homes/data/morg/annual/rw/`2', replace {txt} 10{com}. end {txt} {com}. {txt}end of do-file {com}. ! /bin/rm -f /tmp/aef.raw aef.dct dcthead {txt} {com}. capture erase /tmp/aef.raw {txt} {com}. capture erase aef.dct {txt} {com}. capture erase dcthead {txt} {com}. ! echo >dcthead dictionary using /tmp/aef.raw {txt} {com}. program define aef2 {txt} 1{com}. local dct_name "aef`3'.dbd" {txt} 2{com}. local raw_name "../raw/morg`2'" {txt} 3{com}. display "dct_name `dct_name' raw_name=`raw_name'" {txt} 4{com}. if `1' <= 1993 {c -(} {txt} 5{com}. *!zcat /homes/data/cps-basic/cpsb`2'??.Z |tr "\-A" " " >/tmp/aef.raw . !zcat /homes/data/morg/raw/morg`2'.Z |tr "\-A" " " >/tmp/aef.raw {txt} 6{com}. {c )-} {txt} 7{com}. *if `1' == 1993 {c -(} . * *!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/aef.raw . *{c )-} . if `1' >= 1994 {c -(} {txt} 8{com}. *!zcat /homes/data/cps-basic/cpsb`2'??.Z >/tmp/aef.raw . !zcat /homes/data/morg/raw/morg`2'.Z >/tmp/aef.raw {txt} 9{com}. {c )-} {txt} 10{com}. *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_name'") 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 {txt} 11{com}. *quietly infile using aef.dct if age>15&age!=. , using("/tmp/aef.raw") clear . quietly infile using aef.dct , using("/tmp/aef.raw") clear {txt} 12{com}. keep if minsamp==4 | minsamp==8 {txt} 13{com}. gen recnum=_n {txt} 14{com}. label variable recnum "Unique record ID number. It's sequence in the original file." {txt} 15{com}. quietly describe {txt} 16{com}. display "obs " r(N) {txt} 17{com}. quietly count if age<=15 {txt} 18{com}. display "# of persons with age<=15 `r(N)'" {txt} 19{com}. quietly count if age==. {txt} 20{com}. display "# of non-interview records `r(N)'" {txt} 21{com}. tab age , missing {txt} 22{com}. tab age if age==. , missing {txt} 23{com}. tab age if age<=15 {txt} 24{com}. keep if age>15 {txt} 25{com}. keep if age!=. {txt} 26{com}. quietly describe {txt} 27{com}. display "obs " r(N) " after keeping age>15&age!=. " {txt} 28{com}. display "infile successful" {txt} 29{com}. #delimit cr {txt}delimiter now cr {com}. generate int year = `1' {txt} 30{com}. *summarize . tab intmonth if `1'==2005 {txt} 31{com}. ** Revised Census 2000-based Weights. Impact employment and union variables . if inlist( `1', 2000 , 2001 , 2002 ) {c -(} {txt} 32{com}. gen id = _n {txt} 33{com}. local rwlist qstnum intmonth year occurnum {txt} 34{com}. sort `rwlist' {txt} 35{com}. quietly describe {txt} 36{com}. display "total obs pre-revise `1' " r(N) {txt} 37{com}. saveold /homes/data/morg/annual/rw/annual, replace {txt} 38{com}. clear {txt} 39{com}. rw `2' jan 1 {txt} 40{com}. rw `2' feb 2 {txt} 41{com}. rw `2' mar 3 {txt} 42{com}. rw `2' apr 4 {txt} 43{com}. rw `2' may 5 {txt} 44{com}. rw `2' jun 6 {txt} 45{com}. rw `2' jul 7 {txt} 46{com}. rw `2' aug 8 {txt} 47{com}. rw `2' sep 9 {txt} 48{com}. rw `2' oct 10 {txt} 49{com}. rw `2' nov 11 {txt} 50{com}. rw `2' dec 12 {txt} 51{com}. local monlist feb mar apr may jun jul aug sep oct nov dec {txt} 52{com}. clear {txt} 53{com}. display "using jan" {txt} 54{com}. use /homes/data/morg/annual/rw/jan {txt} 55{com}. foreach mon in `monlist' {c -(} {txt} 56{com}. append using /home/data/morg/annual/rw/`mon' {txt} 57{com}. {c )-} {txt} 58{com}. quietly describe {txt} 59{com}. display "total obs post-revise" r(N) {txt} 60{com}. display "start renaming" {txt} 61{com}. rename neio1icd ind02 {txt} 62{com}. rename ntio1ocd occ00 {txt} 63{com}. replace occ00 = . if occ00 < 0 {txt} 64{com}. rename class94 class94p {txt} 65{com}. replace class94p = . if class94p<0 {txt} 66{com}. . rename neio1cow class94 {txt} 67{com}. rename earnwt earnwtp {txt} 68{com}. rename nworwgt earnwt {txt} 69{com}. rename weight weightp {txt} 70{com}. rename nwsswgt weight {txt} 71{com}. display "done renaming" {txt} 72{com}. display "drop 2000" {txt} 73{com}. if `1' == 2000 {c -(} {txt} 74{com}. drop neerncov neernlab {txt} 75{com}. {c )-} {txt} 76{com}. display "rename 2001-2002" {txt} 77{com}. if inlist( `1' , 2001 , 2002 ) {c -(} {txt} 78{com}. rename unioncov unioncop {txt} 79{com}. replace unioncop = . if unioncop < 0 {txt} 80{com}. rename neerncov unioncov {txt} 81{com}. rename unionmme unionmep {txt} 82{com}. replace unionmep = . if unionmep < 0 {txt} 83{com}. rename neernlab unionmme {txt} 84{com}. {c )-} {txt} 85{com}. sort id {txt} 86{com}. drop id _merge {txt} 87{com}. {c )-} {txt} 88{com}. . * Miscellaneous (record keeping) variables . if `1' == 1994 {c -(} {txt} 89{com}. replace hhid = hhid94 {txt} 90{com}. drop hhid94 {txt} 91{com}. {c )-} {txt} 92{com}. if `1'== 1995 {c -(} {txt} 93{com}. replace hhid = hhid94 if intmonth<9 {txt} 94{com}. drop hhid94 {txt} 95{com}. {c )-} {txt} 96{com}. if inlist( `1', 1996 , 1997 ) {c -(} {txt} 97{com}. drop hhid94 {txt} 98{com}. {c )-} {txt} 99{com}. replace hurespli =. if hurespli <0 {txt}100{com}. if `1'>=2003 & `1'<=2006 {c -(} {txt}101{com}. drop linedad {txt}102{com}. drop linemom {txt}103{com}. {c )-} {txt}104{com}. if `1'>=2007 {c -(} {txt}105{com}. replace linedad=. if linedad<0 {txt}106{com}. replace linemom=. if linemom<0 {txt}107{com}. {c )-} {txt}108{com}. if ( inlist(`1',2003,2004) | `1'>=2007 ) {c -(} {txt}109{com}. drop hurhhscrn {txt}110{com}. drop purkat1 {txt}111{com}. drop purkat2 {txt}112{com}. {c )-} {txt}113{com}. if `1'==2005 {c -(} {txt}114{com}. replace hurhhscrn=. if intmonth<=10 | hurhhscrn<0 {txt}115{com}. replace purkat1=. if intmonth<=10 | purkat1<0 {txt}116{com}. replace purkat2=. if intmonth<=10 | purkat2<0 {txt}117{com}. {c )-} {txt}118{com}. if `1'==2006 {c -(} {txt}119{com}. replace hurhhscrn=. if hurhhscrn<0 {txt}120{com}. replace purkat1=. if purkat2<0 {txt}121{com}. replace purkat2=. if purkat2<0 {txt}122{com}. . {c )-} {txt}123{com}. ************************************************** . ** Creating time-series month/year from the first month-in-sample . generate ym_file = ym(year,intmonth) {txt}124{com}. label variable ym_file "time series month from original data" {txt}125{com}. generate ym = ym_file {txt}126{com}. label variable ym "time series month of first month-in-sample" {txt}127{com}. replace ym = ym - 1 if minsamp == 2 {txt}128{com}. replace ym = ym - 2 if minsamp == 3 {txt}129{com}. replace ym = ym - 3 if minsamp == 4 {txt}130{com}. replace ym = ym - 13 if minsamp == 5 {txt}131{com}. replace ym = ym - 14 if minsamp == 6 {txt}132{com}. replace ym = ym - 15 if minsamp == 7 {txt}133{com}. replace ym = ym - 16 if minsamp == 8 {txt}134{com}. ************************************************** . * Geography . display "Geography" {txt}135{com}. if `1'==2004 {c -(} {txt}136{com}. display "replace serial" {txt}137{com}. replace serial = serial04 if intmonth >= 5 {txt}138{com}. replace hrsample = "" if intmonth >= 5 {txt}139{com}. replace hhnum = hhnum04 if intmonth >= 5 {txt}140{com}. display "replace cmsacode" {txt}141{com}. replace cmsacode = . if intmonth >= 5 {txt}142{com}. display "replace msafips" {txt}143{com}. replace msafips = . if intmonth >= 5 {txt}144{com}. display "replace smsa93" {txt}145{com}. replace smsa93 = . if smsa93<2 & intmonth<=4 {txt}146{com}. replace smsa93 = . if intmonth >= 5 {txt}147{com}. display "replacing smsa04 in May 2004 and later" {txt}148{com}. replace smsa04 = . if smsa04<2 & intmonth >= 5 {txt}149{com}. {c )-} {txt}150{com}. if `1' == 2005 {c -(} {txt}151{com}. replace serial = serial04 {txt}152{com}. replace hrsample ="" {txt}153{com}. replace smsa04 = . if smsa04<2 & intmonth >= 5 {txt}154{com}. {c )-} {txt}155{com}. if `1' >= 2005 {c -(} {txt}156{com}. replace hhnum = hhnum04 {txt}157{com}. display "dropping cmsacode msafips smsa93" {txt}158{com}. drop cmsacode msafips smsa93 {txt}159{com}. {c )-} {txt}160{com}. if `1' == 2003 {c -(} {txt}161{com}. display "dropping non-2003 variables" {txt}162{com}. drop cbsafips smsa04 serial04 hhnum04 hrhhid2 {txt}163{com}. {c )-} {txt}164{com}. if `1'==2004 {c -(} {txt}165{com}. display "replacing pre-May 2004 variables" {txt}166{com}. replace cbsafips = . if intmonth <=4 {txt}167{com}. replace smsa04 = . if intmonth <=4 {txt}168{com}. replace hrhhid2 ="" if intmonth <=4 {txt}169{com}. {c )-} {txt}170{com}. if `1' >= 2004 {c -(} {txt}171{com}. drop serial04 hhnum04 {txt}172{com}. {c )-} {txt}173{com}. if `1' >= 1996 & `1' <= 2003 {c -(} {txt}174{com}. replace smsa93 = . if smsa93<2 {txt}175{com}. {c )-} {txt}176{com}. display "smsasize = . if smsasize <=0" {txt}177{com}. capture replace smsasize = . if smsasize <=0 {txt}178{com}. if `1' == 1995 {c -(} {txt}179{com}. replace smsastat = smsa995 if intmonth>8 {txt}180{com}. replace icntcity = icntct94 if intmonth<9 {txt}181{com}. replace centcity = centcitx if intmonth<9 {txt}182{com}. replace smsa93 = . if intmonth>=9 & smsa93<2 {txt}183{com}. replace smsa93 = . if intmonth<9 {txt}184{com}. drop pmsarank {txt}185{com}. dis "gen smsa80" {txt}186{com}. generate smsa80 = smsasize {txt}187{com}. dis "rep smsa80" {txt}188{com}. replace smsa80 = . if intmonth >= 10 {txt}189{com}. dis "replace county" {txt}190{com}. replace county = . if county < 0 {txt}191{com}. dis "drop county" {txt}192{com}. if intmonth<9 {c -(} {txt}193{com}. drop county {txt}194{com}. {c )-} {txt}195{com}. {c )-} {txt}196{com}. display "inlisting 96 97" {txt}197{com}. if inlist( `1', 1996 , 1997 ) {c -(} {txt}198{com}. replace smsastat = smsa995 {txt}199{com}. {c )-} {txt}200{com}. display "replace smsastat = . if smsastat==3 | smsastat<0" {txt}201{com}. replace smsastat = . if smsastat==3 | smsastat<0 {txt}202{com}. if `1' == 1994 {c -(} {txt}203{com}. drop smsa93 {txt}204{com}. replace centcity = centcitx {txt}205{com}. replace icntcity = icntct94 {txt}206{com}. replace pmsarank = . if intmonth > 3 {txt}207{com}. replace pmsarank = . if pmsarank <= 0 {txt}208{com}. replace cmsarank = . if intmonth > 3 {txt}209{com}. {c )-} {txt}210{com}. if inlist( `1', 1996 , 1997 ) {c -(} {txt}211{com}. drop pmsarank {txt}212{com}. {c )-} {txt}213{com}. if `1' >= 1994 & `1' <= 1997 {c -(} {txt}214{com}. drop centcitx icntct94 smsa995 {txt}215{com}. {c )-} {txt}216{com}. if `1' >= 1994 {c -(} {txt}217{com}. replace peinusyr = . if peinusyr < 0 {txt}218{com}. {c )-} {txt}219{com}. display "replace centcity = . if centcity==4 | centcity<=0" {txt}220{com}. replace centcity = . if centcity==4 | centcity<=0 {txt}221{com}. if `1' >= 1986 & `1' < 1994 {c -(} {txt}222{com}. replace pmsarank = . if pmsarank<=0 {txt}223{com}. {c )-} {txt}224{com}. if `1' >= 1995 & `1' <= 1997 {c -(} {txt}225{com}. drop cmsarank {txt}226{com}. {c )-} {txt}227{com}. if `1' >= 1986 {c -(} {txt}228{com}. replace icntcity = . if icntcity<=0 {txt}229{com}. {c )-} {txt}230{com}. if `1' > 1984 & `1' < 1995 {c -(} {txt}231{com}. replace cmsarank = . if cmsarank<=0 {txt}232{com}. {c )-} {txt}233{com}. if `1' >= 1989 & `1' <= 2004 {c -(} {txt}234{com}. replace msafips = . if msafips <=0 {txt}235{com}. replace cmsacode = . if cmsacode<=0 {txt}236{com}. {c )-} {txt}237{com}. ** 1970 occupation variables are not correct on morg83.raw . if `1' == 1983 {c -(} {txt}238{com}. drop docc70 occ70 {txt}239{com}. {c )-} {txt}240{com}. if `1' == 1985 {c -(} {txt}241{com}. replace smsarank = . if intmonth > 9 {txt}242{com}. {c )-} {txt}243{com}. if `1' == 1984 {c -(} {txt}244{com}. display "drop icntcity pmsarank cmsarank" {txt}245{com}. drop icntcity pmsarank cmsarank {txt}246{com}. {c )-} {txt}247{com}. if `1' == 1985 & intmonth < 10 {c -(} {txt}248{com}. drop icntcity pmsarank cmsarank {txt}249{com}. {c )-} {txt}250{com}. if `1' == 1994 {c -(} {txt}251{com}. replace cmsarank = . if intmonth>3 {txt}252{com}. {c )-} {txt}253{com}. display "replace smsasize=. if smsasize<=0" {txt}254{com}. **should line below be commented out??? . capture replace smsasize=. if smsasize<=0 {txt}255{com}. if `1' < 1985 {c -(} {txt}256{com}. display "generate byte smsa70 = smsasize" {txt}257{com}. generate byte smsa70 = smsasize {txt}258{com}. {c )-} {txt}259{com}. if `1' > 1985 & `1' < 1995 {c -(} {txt}260{com}. generate byte smsa80 = smsasize {txt}261{com}. {c )-} {txt}262{com}. if `1' == 1985 {c -(} {txt}263{com}. generate byte smsa70 = smsasize if intmonth<10 {txt}264{com}. {c )-} {txt}265{com}. if `1' == 1985 {c -(} {txt}266{com}. generate byte smsa80 = smsasize if intmonth>9 {txt}267{com}. {c )-} {txt}268{com}. display "drop smsasize" {txt}269{com}. capture drop smsasize {txt}270{com}. if `1' > 1985 & `1' < 1989 {c -(} {txt}271{com}. drop smsarank {txt}272{com}. {c )-} {txt}273{com}. if `1' < 1983 {c -(} {txt}274{com}. display "drop unioncov unionmme occ80 ind80" {txt}275{com}. drop unioncov unionmme occ80 ind80 {txt}276{com}. {c )-} {txt}277{com}. . * Demography . display "Demography" {txt}278{com}. if `1' > 1983 & `1' < 1994 {c -(} {txt}279{com}. replace ownchild = . if ownchild ==0 {txt}280{com}. replace ownchild = ownchild - 1 {txt}281{com}. generate int ch613=chldpres {txt}282{com}. generate int ch1417=chldpres {txt}283{com}. {c )-} {txt}284{com}. display "if `1' > 1983 & `1' < 1989 {c -(}" {txt}285{com}. if `1' > 1983 & `1' < 1989 {c -(} {txt}286{com}. generate int ch05= chldpres {txt}287{com}. recode ch05 (4 6/8 = 1) (0/3 5 = 0) {txt}288{com}. recode ch613 (3 5 7/8 = 1) (0/2 4 6 = 0) {txt}289{com}. recode ch1417 (2 5/6 8 =1) (0/1 3/4 7 = 0) {txt}290{com}. {c )-} {txt}291{com}. if `1' > 1988 & `1' < 1994 {c -(} {txt}292{com}. display "if `1' > 1988 & `1' < 1994 {c -(}" {txt}293{com}. generate int ch02 = chldpres {txt}294{com}. generate int ch35 = chldpres {txt}295{com}. recode ch02 (2 6/8 12/14 16 = 1) (0/1 3/5 9/11 15 = 0) {txt}296{com}. recode ch35 (3 6 9/10 12/13 15/16 = 1) (0/2 4/5 7/8 11 14 = 0) {txt}297{com}. recode ch613 (4 7 9 11/12 14/16 = 1) (0/3 5/6 8 10 13 = 0) {txt}298{com}. recode ch1417 (5 8 10/11 13/16 = 1) (0/4 6/7 9 12 = 0 ) {txt}299{com}. generate int ch05 = ch02 {txt}300{com}. replace ch05 = ch35 if ch35 == 1 {txt}301{com}. label variable ch02 "Children 0-2" {txt}302{com}. label variable ch35 "Children 3-5" {txt}303{com}. {c )-} {txt}304{com}. if `1' > 1983 & `1' < 1994 {c -(} {txt}305{com}. display "if `1' > 1983 & `1' < 1994 {c -(}" {txt}306{com}. label variable ch05 "Children 0-5" {txt}307{com}. label variable ch613 "Children 6-13" {txt}308{com}. label variable ch1417 "Children 6-17" {txt}309{com}. {c )-} {txt}310{com}. if `1' >= 1994 & `1' <= 1996 {c -(} {txt}311{com}. drop prpertyp {txt}312{com}. {c )-} {txt}313{com}. if `1' >= 1997 {c -(} {txt}314{com}. replace prpertyp=. if prpertyp<0 {txt}315{com}. {c )-} {txt}316{com}. if `1' == 1998 {c -(} {txt}317{com}. drop ownchild chldpres {txt}318{com}. {c )-} {txt}319{com}. if `1' >= 1999 {c -(} {txt}320{com}. replace ownchild = . if ownchild < 0 {txt}321{com}. replace chldpres = . if chldpres < 0 {txt}322{com}. generate int ch02 = chldpres {txt}323{com}. generate int ch35 = chldpres {txt}324{com}. generate int ch613 = chldpres {txt}325{com}. generate int ch1417 = chldpres {txt}326{com}. recode ch02 (1 5/7 11/13 15 = 1) (0 2/4 8/10 14 = 0) {txt}327{com}. recode ch35 (2 5 8/9 11/12 14/15 = 1) (0/1 3/4 6/7 10 13 =0) {txt}328{com}. recode ch613 (3 6 8 10/11 13/15 = 1) (0/2 4/5 7 9 12 = 0) {txt}329{com}. recode ch1417 (4 7 9/10 12/15 = 1) (0/3 5/6 8 11 = 0) {txt}330{com}. generate int ch05 = ch02 {txt}331{com}. replace ch05 = ch35 if ch35 == 1 {txt}332{com}. {c )-} {txt}333{com}. . if `1' == 1999 {c -(} {txt}334{com}. replace ownchild = . if intmonth < 10 {txt}335{com}. replace chldpres = . if intmonth < 10 {txt}336{com}. replace ch613 = . if intmonth < 10 {txt}337{com}. replace ch1417 = . if intmonth < 10 {txt}338{com}. replace ch05 = . if intmonth < 10 {txt}339{com}. replace ch02 = . if intmonth < 10 {txt}340{com}. replace ch35 = . if intmonth < 10 {txt}341{com}. {c )-} {txt}342{com}. if `1' > 1988 & `1' < 1992 {c -(} {txt}343{com}. drop grade92 {txt}344{com}. {c )-} {txt}345{com}. if `1' < 1989 {c -(} {txt}346{com}. replace gradeat = gradeat - 1 {txt}347{com}. replace marital = 7 if marital==5 {txt}348{com}. {c )-} {txt}349{com}. if `1' > 1991 {c -(} {txt}350{com}. replace grade92 = . if grade92 < 0 {txt}351{com}. {c )-} {txt}352{com}. if `1' >= 1998 {c -(} {txt}353{com}. replace ged = . if ged < 0 {txt}354{com}. replace gedhigr = . if gedhigr < 0 {txt}355{com}. replace yrcoll = . if yrcoll < 0 {txt}356{com}. replace grprof = . if grprof < 0 {txt}357{com}. replace gr6cor = . if gr6cor < 0 {txt}358{com}. replace ms123 = . if ms123 < 0 {txt}359{com}. generate double ihigrdc = . {txt}360{com}. ** Jaeger . label var ihigrdc "Imputed highest grade completed" {txt}361{com}. replace ihigrdc = 0 if grade92==31 {txt}362{com}. replace ihigrdc = 2.5 if grade92==32 {txt}363{com}. replace ihigrdc = 5.5 if grade92==33 {txt}364{com}. replace ihigrdc = 7.5 if grade92==34 {txt}365{com}. replace ihigrdc = 9 if grade92==35 {txt}366{com}. replace ihigrdc =10 if grade92==36 {txt}367{com}. replace ihigrdc =11 if grade92==37 {txt}368{com}. replace ihigrdc =12 if grade92==38 {txt}369{com}. replace ihigrdc = 0 if grade92==39 & ged==2 & gedhigr==1 {txt}370{com}. replace ihigrdc = 2.5 if grade92==39 & ged==2 & gedhigr==2 {txt}371{com}. replace ihigrdc = 5.5 if grade92==39 & ged==2 & gedhigr==3 {txt}372{com}. replace ihigrdc = 7.5 if grade92==39 & ged==2 & gedhigr==4 {txt}373{com}. replace ihigrdc = 9 if grade92==39 & ged==2 & gedhigr==5 {txt}374{com}. replace ihigrdc = 10 if grade92==39 & ged==2 & gedhigr==6 {txt}375{com}. replace ihigrdc = 11 if grade92==39 & ged==2 & gedhigr==7 {txt}376{com}. replace ihigrdc = 12 if grade92==39 & ged==2 & gedhigr==8 {txt}377{com}. replace ihigrdc = 12 if ged==1 {txt}378{com}. replace ihigrdc = 12 if grade92>=40 & grade92<=42 & yrcoll==1 {txt}379{com}. replace ihigrdc = 13 if grade92>=40 & grade92<=42 & yrcoll==2 {txt}380{com}. replace ihigrdc = 14 if grade92>=40 & grade92<=42 & yrcoll==3 {txt}381{com}. replace ihigrdc = 15 if grade92>=40 & grade92<=42 & yrcoll==4 {txt}382{com}. replace ihigrdc = 16 if grade92>=40 & grade92<=42 & yrcoll==5 {txt}383{com}. replace ihigrdc = 16 if grade92==43 & grprof==2 {txt}384{com}. replace ihigrdc = 17 if grade92==43 & gr6cor==2 {txt}385{com}. replace ihigrdc = 18 if grade92==43 & gr6cor==1 {txt}386{com}. replace ihigrdc = 17 if grade92==44 & ms123==1 {txt}387{com}. replace ihigrdc = 18 if grade92==44 & ms123>=2 & ms123<. {txt}388{com}. replace ihigrdc = 18 if grade92==45 | grade92==46 {txt}389{com}. {c )-} {txt}390{com}. if inlist( `1', 1992 , 1993 ) {c -(} {txt}391{com}. drop gradecp gradeat {txt}392{com}. {c )-} {txt}393{com}. if `1' == 1995 {c -(} {txt}394{com}. replace relref94 = . if intmonth > 2 {txt}395{com}. replace relref95 = . if intmonth < 3 {txt}396{com}. {c )-} {txt}397{com}. if inlist( `1', 1996 , 1997 ) {c -(} {txt}398{com}. drop relref94 {txt}399{com}. {c )-} {txt}400{com}. if `1' == 1994 {c -(} {txt}401{com}. drop relref95 {txt}402{com}. {c )-} {txt}403{com}. if `1' >= 1994 {c -(} {txt}404{com}. replace penatvty = . if penatvty < 0 {txt}405{com}. replace pemntvty = . if pemntvty < 0 {txt}406{com}. replace pefntvty = . if pefntvty < 0 {txt}407{com}. replace prcitshp = . if prcitshp < 0 {txt}408{com}. replace prcitflg = . if prcitflg < 0 {txt}409{com}. {c )-} {txt}410{com}. if `1' > 1989 {c -(} {txt}411{com}. replace ethnic = . if ethnic < 0 {txt}412{com}. replace ethnic = . if ethnic >= 10 {txt}413{com}. {c )-} {txt}414{com}. if `1' >= 1994 & `1' <= 2004 {c -(} {txt}415{com}. replace veteran = . if veteran < 0 {txt}416{com}. {c )-} {txt}417{com}. if `1' >= 2003 & `1' <= 2004 {c -(} {txt}418{com}. drop vet1-vet4 {txt}419{com}. {c )-} {txt}420{com}. if `1' == 2005 {c -(} {txt}421{com}. display "replacing veteran Jan-July 2005" {txt}422{com}. replace veteran = . if veteran < 0 & intmonth <= 7 {txt}423{com}. display "replacing vet1-vet4 if intmonth <= 7 " {txt}424{com}. replace vet1 = . if intmonth <= 7 {txt}425{com}. replace vet2 = . if intmonth <= 7 {txt}426{com}. replace vet3 = . if intmonth <= 7 {txt}427{com}. replace vet4 = . if intmonth <= 7 {txt}428{com}. {c )-} {txt}429{com}. if `1' == 2005 {c -(} {txt}430{com}. replace veteran = . if intmonth >= 8 {txt}431{com}. replace vet1 = . if vet1 < 0 & intmonth >= 8 {txt}432{com}. replace vet2 = . if vet2 < 0 & intmonth >= 8 {txt}433{com}. replace vet3 = . if vet3 < 0 & intmonth >= 8 {txt}434{com}. replace vet4 = . if vet4 < 0 & intmonth >= 8 {txt}435{com}. {c )-} {txt}436{com}. if `1' >= 2006 {c -(} {txt}437{com}. drop veteran {txt}438{com}. replace vet1=. if vet1<0 {txt}439{com}. replace vet2=. if vet2<0 {txt}440{com}. replace vet3=. if vet3<0 {txt}441{com}. replace vet4=. if vet4<0 {txt}442{com}. {c )-} {txt}443{com}. * Employment . display "Employment" {txt}444{com}. if `1' >= 1994 {c -(} {txt}445{com}. replace selfproxy = . if selfproxy<0 {txt}446{com}. replace dwrsn = . if dwrsn<0 {txt}447{com}. replace otc = . if otc<0 {txt}448{com}. {c )-} {txt}449{com}. if `1' >= 1994 & `1' <= 2002 {c -(} {txt}450{com}. replace occ80 = . if occ80 <0 {txt}451{com}. replace ind80 = . if ind80 < 10 {txt}452{com}. replace class94 = . if class94<0 {txt}453{com}. {c )-} {txt}454{com}. if `1' >= 2000 {c -(} {txt}455{com}. replace occ00 = . if occ00 <0 {txt}456{com}. replace ind02 = . if ind02 < 10 {txt}457{com}. replace class94 = . if class94<0 {txt}458{com}. {c )-} {txt}459{com}. #delimit ; {txt}delimiter now ; {com}. ; . display "docc80" ; {txt}460{com}. if `1' >= 1983 & `1' <= 2002 {c -(} > display "generate int docc80=occ80;"; {txt}461{com}. generate int docc80=occ80; {txt}462{com}. display "recode docc80"; {txt}463{com}. 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=12) > (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); {txt}464{com}. {c )-} ; {txt}465{com}. display "** The renaming is part of the Census reweighting ; " ; {txt}466{com}. if inlist( `1', 2000 , 2001 , 2002 ) {c -(} > *display "renaming docc80 docc80p " ; {txt}467{com}. *rename docc80 docc80p ; . {c )-} ; {txt}468{com}. display "docc00" ; {txt}469{com}. if `1' >= 2000 {c -(} > display "generate int docc00=occ00;"; {txt}470{com}. generate int docc00=occ00; {txt}471{com}. display "recode docc00"; {txt}472{com}. recode docc00 (10/430=1) (500/950=2) (1000/1240=3) (1300/1560=4) (1600/1960=5) > (2000/2060=6) (2100/2150=7) (2200/2550=8) (2600/2960=9) (3000/3540=10) (3600/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); {txt}473{com}. {c )-} ; {txt}474{com}. display "dind"; {txt}475{com}. if `1'<= 1982 {c -(} > display "`1' <= 1982: creating dind from ind70"; {txt}476{com}. gen dind=ind70 ; {txt}477{com}. 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) ; {txt}478{com}. {c )-} ; {txt}479{com}. if `1' <=1991 & `1' >=1983 {c -(} > display "replacing dind for `1': `1' <=1991 & `1' >=1983"; {txt}480{com}. gen dind=ind80; {txt}481{com}. 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); {txt}482{com}. {c )-} ; {txt}483{com}. if `1' >= 1992 & `1' <= 2002 {c -(} > display "replacing dind for `1': `1' >= 1992 & `1' <= 2002 "; {txt}484{com}. gen dind=ind80; {txt}485{com}. 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) ; {txt}486{com}. {c )-}; {txt}487{com}. if `1' >= 2000 {c -(} > display "replacing dind for `1' >= 2000 " ; {txt}488{com}. gen dind02 = ind02; {txt}489{com}. 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) (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 8670=45) > (8680 8690=46) (8770/8890=47) (8970/9090=48) (9160/9190=49) (9290=50) > (9370/9590=51) (9890=52) ; {txt}490{com}. {c )-} ; {txt}491{com}. #delimit cr {txt}delimiter now cr {com}. **Wages (If earnings are 0, then wage rate is missing, not zero). . display "Wages" {txt}492{com}. replace paidhr = . if paidhr <=0 {txt}493{com}. replace paidhre = . if paidhre <=0 {txt}494{com}. replace earnhr = . if earnhr <=0 {txt}495{com}. replace earnhre = . if earnhre <=0 {txt}496{com}. replace earnwke = . if earnwke < 0 {txt}497{com}. if `1' < 1989 {c -(} {txt}498{com}. replace eligible = 2 if eligible == . {txt}499{com}. {c )-} {txt}500{com}. if `1' >= 1989 {c -(} {txt}501{com}. replace eligible = 2 if eligible <= 0 {txt}502{com}. replace agri = 0 if agri==2 {txt}503{com}. replace agri = . if agri< 0 {txt}504{com}. replace untype = . if untype<0 {txt}505{com}. {c )-} {txt}506{com}. if `1' < 1989 {c -(} {txt}507{com}. replace I25a = 0 if I25a ==. {txt}508{com}. replace I25b = 0 if I25b ==. {txt}509{com}. replace I25c = 0 if I25c ==. {txt}510{com}. replace I25d = 0 if I25d ==. {txt}511{com}. replace agri = . if agri< 0 {txt}512{com}. {c )-} {txt}513{com}. if `1' >= 1994 {c -(} {txt}514{com}. replace I25a = 0 if I25a <= 3 {txt}515{com}. replace I25b = 0 if I25b <= 3 {txt}516{com}. *replace I25a = . if I25a < 0 . *replace I25b = . if I25b < 0 . replace earnhre = . if earnhre ==1 {txt}517{com}. replace uhourse = . if lfsr94 >2 | lfsr94 <1 {txt}518{com}. replace lfsr94 = . if lfsr94 < 0 {txt}519{com}. {c )-} {txt}520{com}. if `1' >= 1996 {c -(} {txt}521{com}. replace I25c = . if I25c < 0 {txt}522{com}. replace I25d = . if I25d < 0 {txt}523{com}. {c )-} {txt}524{com}. if `1' == 1995 {c -(} {txt}525{com}. replace I25c = . if I25c < 0 {txt}526{com}. replace I25d = . if I25d < 0 {txt}527{com}. replace I25c = . if intmonth < 9 {txt}528{com}. replace I25d = . if intmonth < 9 {txt}529{com}. {c )-} {txt}530{com}. if `1' == 1994 {c -(} {txt}531{com}. drop I25c I25d {txt}532{com}. {c )-} {txt}533{com}. ** Hours, Unions . display "Hours, Unions" {txt}534{com}. if `1' >= 1994 {c -(} {txt}535{com}. replace reason94 = . if reason94< 0 {txt}536{com}. replace absent94 = . if absent94< 0 {txt}537{com}. replace studftpt = . if studftpt< 0 {txt}538{com}. replace schenr = . if schenr < 0 {txt}539{com}. replace schlvl = . if schlvl < 0 {txt}540{com}. replace ftpt94 = . if ftpt94 < 0 {txt}541{com}. replace hourslw = . if hourslw < 0 {txt}542{com}. replace hourslw = 99 if hourslw >99 & hourslw != . {txt}543{com}. replace uhourse = . if uhourse < 0 {txt}544{com}. replace why3594 = . if why3594 < 0 {txt}545{com}. replace unionmme = . if unionmme< 0 {txt}546{com}. replace unioncov = . if unioncov< 0 {txt}547{com}. {c )-} {txt}548{com}. . ** Save and exit . compress {txt}549{com}. saveold /homes/data/morg/annual/morg`2',replace {txt}550{com}. summarize {txt}551{com}. clear {txt}552{com}. capture ! /usr/bin/rm -f aef.dct /tmp/aef.raw {txt}553{com}. capture ! /bin/rm -f aef.dct /tmp/aef.raw {txt}554{com}. capture ! /usr/bin/chmod a+r /home/data/morg/annual/morg`2'.dta {txt}555{com}. capture ! /bin/chmod a+r /home/data/morg/annual/morg`2'.dta {txt}556{com}. capture ! /usr/bin/chmod g+w /home/data/morg/annual/morg`2'.dta {txt}557{com}. capture ! /bin/chmod g+w /home/data/morg/annual/morg`2'.dta {txt}558{com}. capture ! /usr/bin/chgrp web /home/data/morg/annual/morg`2'.dta {txt}559{com}. capture ! /bin/chgrp web /home/data/morg/annual/morg`2'.dta {txt}560{com}. end {txt} {com}. . *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 . *aef2 1984 84 84_88 . *aef2 1985 85 84_88 . *aef2 1986 86 84_88 . *aef2 1987 87 84_88 . *aef2 1988 88 84_88 . *aef2 1989 89 89_93 . *aef2 1990 90 89_93 . *aef2 1991 91 89_93 . *aef2 1992 92 89_93 . aef2 1993 93 89_93 dct_name aef89_93.dbd raw_name=../raw/morg93 {txt}(0 observations deleted) obs 472016 # of persons with age<=15 105299 # of non-interview records 38632 Age {c |} Freq. Percent Cum. {hline 12}{c +}{hline 35} 0 {c |}{res} 6,358 1.35 1.35 {txt} 1 {c |}{res} 6,607 1.40 2.75 {txt} 2 {c |}{res} 6,948 1.47 4.22 {txt} 3 {c |}{res} 6,826 1.45 5.66 {txt} 4 {c |}{res} 6,870 1.46 7.12 {txt} 5 {c |}{res} 6,686 1.42 8.54 {txt} 6 {c |}{res} 6,671 1.41 9.95 {txt} 7 {c |}{res} 6,664 1.41 11.36 {txt} 8 {c |}{res} 6,630 1.40 12.77 {txt} 9 {c |}{res} 6,543 1.39 14.15 {txt} 10 {c |}{res} 6,632 1.41 15.56 {txt} 11 {c |}{res} 6,415 1.36 16.92 {txt} 12 {c |}{res} 6,654 1.41 18.33 {txt} 13 {c |}{res} 6,598 1.40 19.72 {txt} 14 {c |}{res} 6,106 1.29 21.02 {txt} 15 {c |}{res} 6,091 1.29 22.31 {txt} 16 {c |}{res} 6,013 1.27 23.58 {txt} 17 {c |}{res} 5,633 1.19 24.78 {txt} 18 {c |}{res} 5,467 1.16 25.93 {txt} 19 {c |}{res} 5,069 1.07 27.01 {txt} 20 {c |}{res} 5,207 1.10 28.11 {txt} 21 {c |}{res} 5,543 1.17 29.29 {txt} 22 {c |}{res} 5,829 1.23 30.52 {txt} 23 {c |}{res} 5,882 1.25 31.77 {txt} 24 {c |}{res} 5,964 1.26 33.03 {txt} 25 {c |}{res} 5,927 1.26 34.29 {txt} 26 {c |}{res} 5,956 1.26 35.55 {txt} 27 {c |}{res} 6,149 1.30 36.85 {txt} 28 {c |}{res} 6,694 1.42 38.27 {txt} 29 {c |}{res} 6,802 1.44 39.71 {txt} 30 {c |}{res} 7,322 1.55 41.26 {txt} 31 {c |}{res} 7,122 1.51 42.77 {txt} 32 {c |}{res} 7,473 1.58 44.35 {txt} 33 {c |}{res} 7,283 1.54 45.90 {txt} 34 {c |}{res} 7,175 1.52 47.42 {txt} 35 {c |}{res} 7,398 1.57 48.98 {txt} 36 {c |}{res} 7,266 1.54 50.52 {txt} 37 {c |}{res} 7,190 1.52 52.05 {txt} 38 {c |}{res} 7,098 1.50 53.55 {txt} 39 {c |}{res} 6,864 1.45 55.00 {txt} 40 {c |}{res} 7,001 1.48 56.49 {txt} 41 {c |}{res} 6,560 1.39 57.88 {txt} 42 {c |}{res} 6,382 1.35 59.23 {txt} 43 {c |}{res} 6,220 1.32 60.55 {txt} 44 {c |}{res} 6,117 1.30 61.84 {txt} 45 {c |}{res} 6,317 1.34 63.18 {txt} 46 {c |}{res} 6,224 1.32 64.50 {txt} 47 {c |}{res} 5,036 1.07 65.57 {txt} 48 {c |}{res} 4,820 1.02 66.59 {txt} 49 {c |}{res} 4,985 1.06 67.64 {txt} 50 {c |}{res} 5,260 1.11 68.76 {txt} 51 {c |}{res} 4,618 0.98 69.74 {txt} 52 {c |}{res} 4,225 0.90 70.63 {txt} 53 {c |}{res} 3,988 0.84 71.48 {txt} 54 {c |}{res} 3,951 0.84 72.31 {txt} 55 {c |}{res} 3,888 0.82 73.14 {txt} 56 {c |}{res} 3,684 0.78 73.92 {txt} 57 {c |}{res} 3,572 0.76 74.67 {txt} 58 {c |}{res} 3,655 0.77 75.45 {txt} 59 {c |}{res} 3,437 0.73 76.18 {txt} 60 {c |}{res} 3,519 0.75 76.92 {txt} 61 {c |}{res} 3,644 0.77 77.69 {txt} 62 {c |}{res} 3,514 0.74 78.44 {txt} 63 {c |}{res} 3,638 0.77 79.21 {txt} 64 {c |}{res} 3,481 0.74 79.95 {txt} 65 {c |}{res} 3,703 0.78 80.73 {txt} 66 {c |}{res} 3,606 0.76 81.50 {txt} 67 {c |}{res} 3,500 0.74 82.24 {txt} 68 {c |}{res} 3,478 0.74 82.97 {txt} 69 {c |}{res} 3,267 0.69 83.67 {txt} 70 {c |}{res} 3,416 0.72 84.39 {txt} 71 {c |}{res} 3,181 0.67 85.06 {txt} 72 {c |}{res} 3,178 0.67 85.74 {txt} 73 {c |}{res} 2,900 0.61 86.35 {txt} 74 {c |}{res} 2,610 0.55 86.90 {txt} 75 {c |}{res} 2,713 0.57 87.48 {txt} 76 {c |}{res} 2,227 0.47 87.95 {txt} 77 {c |}{res} 2,192 0.46 88.41 {txt} 78 {c |}{res} 2,100 0.44 88.86 {txt} 79 {c |}{res} 1,921 0.41 89.27 {txt} 80 {c |}{res} 1,758 0.37 89.64 {txt} 81 {c |}{res} 1,569 0.33 89.97 {txt} 82 {c |}{res} 1,463 0.31 90.28 {txt} 83 {c |}{res} 1,351 0.29 90.57 {txt} 84 {c |}{res} 1,082 0.23 90.80 {txt} 85 {c |}{res} 953 0.20 91.00 {txt} 86 {c |}{res} 803 0.17 91.17 {txt} 87 {c |}{res} 654 0.14 91.31 {txt} 88 {c |}{res} 588 0.12 91.43 {txt} 89 {c |}{res} 460 0.10 91.53 {txt} 90 {c |}{res} 1,350 0.29 91.82 {txt} . {c |}{res} 38,632 8.18 100.00 {txt}{hline 12}{c +}{hline 35} Total {c |}{res} 472,016 100.00 {txt}Age {c |} Freq. Percent Cum. {hline 12}{c +}{hline 35} . {c |}{res} 38,632 100.00 100.00 {txt}{hline 12}{c +}{hline 35} Total {c |}{res} 38,632 100.00 {txt}Age {c |} Freq. Percent Cum. {hline 12}{c +}{hline 35} 0 {c |}{res} 6,358 6.04 6.04 {txt} 1 {c |}{res} 6,607 6.27 12.31 {txt} 2 {c |}{res} 6,948 6.60 18.91 {txt} 3 {c |}{res} 6,826 6.48 25.39 {txt} 4 {c |}{res} 6,870 6.52 31.92 {txt} 5 {c |}{res} 6,686 6.35 38.27 {txt} 6 {c |}{res} 6,671 6.34 44.60 {txt} 7 {c |}{res} 6,664 6.33 50.93 {txt} 8 {c |}{res} 6,630 6.30 57.23 {txt} 9 {c |}{res} 6,543 6.21 63.44 {txt} 10 {c |}{res} 6,632 6.30 69.74 {txt} 11 {c |}{res} 6,415 6.09 75.83 {txt} 12 {c |}{res} 6,654 6.32 82.15 {txt} 13 {c |}{res} 6,598 6.27 88.42 {txt} 14 {c |}{res} 6,106 5.80 94.22 {txt} 15 {c |}{res} 6,091 5.78 100.00 {txt}{hline 12}{c +}{hline 35} Total {c |}{res} 105,299 100.00 {txt}(105299 observations deleted) (38632 observations deleted) obs 328085 after keeping age>15&age!=. infile successful no observations (0 real changes made) (0 real changes made) (0 real changes made) (163478 real changes made) (0 real changes made) (0 real changes made) (0 real changes made) (164607 real changes made) Geography smsasize = . if smsasize <=0 inlisting 96 97 replace smsastat = . if smsastat==3 | smsastat<0 (5600 real changes made, 5600 to missing) replace centcity = . if centcity==4 | centcity<=0 (60686 real changes made, 60686 to missing) (217275 real changes made, 217275 to missing) (310766 real changes made, 310766 to missing) (102816 real changes made, 102816 to missing) (106017 real changes made, 106017 to missing) (214074 real changes made, 214074 to missing) replace smsasize=. if smsasize<=0 (102816 missing values generated) drop smsasize Demography (64625 real changes made, 64625 to missing) (263460 real changes made) if 1993 > 1983 & 1993 < 1989 { if 1993 > 1988 & 1993 < 1994 { (ch02: 263460 changes made) (ch35: 263460 changes made) (ch613: 263460 changes made) (ch1417: 263460 changes made) (20602 real changes made) if 1993 > 1983 & 1993 < 1994 { (0 real changes made) (0 real changes made) (274 real changes made, 274 to missing) Employment docc80 (82443 missing values generated) recode docc80 (docc80: 245642 changes made) ** The renaming is part of the Census reweighting ; docc00 dind (82443 missing values generated) (dind: 245642 changes made) Wages (0 real changes made) (0 real changes made) (174 real changes made, 174 to missing) (1 real change made, 1 to missing) (0 real changes made) (151922 real changes made) (238428 real changes made) (0 real changes made) (0 real changes made) Hours, Unions ym_file was {res}float{txt} now {res}int {txt}ym was {res}float{txt} now {res}int {txt}ch613 was {res}int{txt} now {res}byte {txt}ch1417 was {res}int{txt} now {res}byte {txt}ch02 was {res}int{txt} now {res}byte {txt}ch35 was {res}int{txt} now {res}byte {txt}ch05 was {res}int{txt} now {res}byte {txt}docc80 was {res}int{txt} now {res}byte {txt}dind was {res}float{txt} now {res}byte {txt}file /homes/data/morg/annual/morg93.dta saved Variable {c |} Obs Mean Std. Dev. Min Max {hline 13}{c +}{hline 56} intmonth {c |}{res} 328085 6.493473 3.454551 1 12 {txt}hhnum {c |}{res} 327739 1.084082 .3074319 1 7 {txt}hurespli {c |}{res} 326800 1.599067 .8271617 1 7 {txt}minsamp {c |}{res} 328085 6.006882 1.999991 4 8 {txt}state {c |}{res} 328085 50.99566 26.0027 11 95 {txt}{hline 13}{c +}{hline 56} stfips {c |}{res} 328085 28.6916 14.89029 1 56 {txt}centcity {c |}{res} 267399 2.04549 .7680071 1 3 {txt}msafips {c |}{res} 222068 4422.927 2542.033 80 9340 {txt}pmsarank {c |}{res} 110810 1.761763 1.515316 1 12 {txt}cmsarank {c |}{res} 225269 43.06108 54.62925 1 252 {txt}{hline 13}{c +}{hline 56} cmsacode {c |}{res} 114011 51.44726 25.24713 7 91 {txt}smsastat {c |}{res} 322485 1.264257 .4409376 1 2 {txt}icntcity {c |}{res} 17319 1.155898 .4471797 1 4 {txt}hhid {c |}{res} 0 {txt}sex {c |}{res} 328085 1.53075 .4990543 1 2 {txt}{hline 13}{c +}{hline 56} veteran {c |}{res} 326517 5.555891 1.247842 1 6 {txt}grade92 {c |}{res} 328085 39.39729 2.855713 31 46 {txt}doinglw {c |}{res} 325960 3.027267 2.530032 1 8 {txt}hourslwa {c |}{res} 189167 39.17036 13.91672 0 99 {txt}uhours35 {c |}{res} 47485 1.696262 .4598757 1 2 {txt}{hline 13}{c +}{hline 56} why35lw {c |}{res} 47635 10.15337 4.05454 1 15 {txt}class {c |}{res} 245999 1.983691 1.768913 1 8 {txt}uhours {c |}{res} 173182 38.21328 11.13179 0 99 {txt}paidhr {c |}{res} 172937 1.392785 .488371 1 2 {txt}earnhr {c |}{res} 91446 912.724 515.767 1 9999 {txt}{hline 13}{c +}{hline 56} uearnwk {c |}{res} 146828 460.4223 341.8794 0 1999 {txt}unionmm {c |}{res} 172802 1.842189 .3645644 1 2 {txt}unioncov {c |}{res} 146016 1.970202 .1700305 1 2 {txt}studftpt {c |}{res} 21396 1.09212 .2892021 1 2 {txt}lineno {c |}{res} 328085 1.733429 1.01524 1 36 {txt}{hline 13}{c +}{hline 56} relaref {c |}{res} 328085 3.085828 2.243243 1 10 {txt}age {c |}{res} 328085 43.95019 18.24052 16 90 {txt}marital {c |}{res} 328085 3.133642 2.588896 1 7 {txt}race {c |}{res} 328085 1.234183 .6710871 1 5 {txt}activlwr {c |}{res} 326517 3.041162 2.540762 1 8 {txt}{hline 13}{c +}{hline 56} hourslw {c |}{res} 189354 39.203 13.88066 1 99 {txt}reasonlw {c |}{res} 47849 10.13118 4.065747 1 15 {txt}absentlw {c |}{res} 12805 3.6549 2.698855 1 8 {txt}ind80 {c |}{res} 245642 577.3268 276.5838 10 991 {txt}occ80 {c |}{res} 245642 378.4367 245.7107 3 905 {txt}{hline 13}{c +}{hline 56} classer {c |}{res} 247113 1.94248 1.718647 1 8 {txt}uhourse {c |}{res} 174595 38.27757 10.98457 1 99 {txt}paidhre {c |}{res} 174595 1.395155 .4888853 1 2 {txt}unionmme {c |}{res} 174595 1.842292 .3644679 1 2 {txt}untype {c |}{res} 14268 2.760583 1.228221 1 5 {txt}{hline 13}{c +}{hline 56} agri {c |}{res} 245642 .0293679 .168836 0 1 {txt}schenr {c |}{res} 50276 1.564981 .4957644 1 2 {txt}schlvl {c |}{res} 21871 1.491884 .4999456 1 2 {txt}ethnic {c |}{res} 327811 7.704134 1.259929 1 9 {txt}lfsr89 {c |}{res} 326517 3.190379 2.794535 1 7 {txt}{hline 13}{c +}{hline 56} ftpt89 {c |}{res} 326517 2.090418 1.293029 1 7 {txt}eligible {c |}{res} 326517 1.465281 .4987939 1 2 {txt}classer2 {c |}{res} 247113 1.741988 1.414651 1 7 {txt}earnhre {c |}{res} 105602 928.0515 517.1191 50 9999 {txt}earnwke {c |}{res} 174595 468.9893 338.1808 1 1923 {txt}{hline 13}{c +}{hline 56} weight {c |}{res} 326517 1790.145 975.159 108.06 15077.71 {txt}earnwt {c |}{res} 326517 7160.603 3907.99 400.57 58618.42 {txt}famnum {c |}{res} 328085 .8311505 .4362089 0 6 {txt}ownchild {c |}{res} 263460 .874034 1.154 0 8 {txt}chldpres {c |}{res} 328085 2.763884 3.394483 0 16 {txt}{hline 13}{c +}{hline 56} pfamrel {c |}{res} 328085 1.758703 1.406292 0 5 {txt}I25a {c |}{res} 326517 .0360533 .3780392 0 4 {txt}I25b {c |}{res} 326517 .0394711 .3847751 0 4 {txt}I25c {c |}{res} 326517 .0027104 .090133 0 3 {txt}I25d {c |}{res} 326517 .0898483 .5743412 0 4 {txt}{hline 13}{c +}{hline 56} recnum {c |}{res} 328085 236199.1 136369.3 1 472016 {txt}year {c |}{res} 328085 1993 0 1993 1993 {txt}ym_file {c |}{res} 328085 401.4935 3.454551 396 407 {txt}ym {c |}{res} 328085 391.9711 7.344123 380 404 {txt}smsa80 {c |}{res} 225269 5.226139 1.913564 2 8 {txt}{hline 13}{c +}{hline 56} ch613 {c |}{res} 328085 .2063337 .4046735 0 1 {txt}ch1417 {c |}{res} 328085 .1525519 .3595556 0 1 {txt}ch02 {c |}{res} 328085 .0897237 .2857859 0 1 {txt}ch35 {c |}{res} 328085 .0952893 .2936146 0 1 {txt}ch05 {c |}{res} 328085 .1525184 .3595232 0 1 {txt}{hline 13}{c +}{hline 56} docc80 {c |}{res} 245642 23.2442 12.40883 1 46 {txt}dind {c |}{res} 245642 31.07605 13.39511 1 52 {txt} {com}. *aef2 1994 94 94_97 . *aef2 1995 95 94_97 . *aef2 1996 96 94_97 . *aef2 1997 97 94_97 . *aef2 1998 98 98_02 . *aef2 1999 99 98_02 . *aef2 2000 00 98_02 . *aef2 2001 01 98_02 . *aef2 2002 02 98_02 . *aef2 2003 03 03 . *aef2 2004 04 03 . *aef2 2005 05 03 . *aef2 2006 06 03 . *aef2 2007 07 03 . *aef2 2008 08 03 . . exit, clear {txt}end of do-file {com}. exit,clear