---------------------------------------------------------------------------------------------------------------------------------- name: log: C:\Users\rwr\Dropbox\basu-house\build\code\../temp/raw2dta_JOB_WK_NUM_DUAL_JOB4.log log type: text opened on: 17 Jul 2016, 14:11:33 . /*****************************************************************************/ > /*****************************************************************************/ > /*****************************************************************************/ > > clear all; . infile using `raw'`prg'.dct; infile dictionary { R0000100 "ID# (1-12686) 79" R0214700 "RACL/ETHNIC COHORT /SCRNR 79" R0214800 "SEX OF R 79" W0085200 "JOB NUM 4 (1980) WEEK 118" W0086800 "JOB NUM 4 (1980) WEEK 122" W0087200 "JOB NUM 4 (1980) WEEK 123" W0087600 "JOB NUM 4 (1980) WEEK 124" W0088000 "JOB NUM 4 (1980) WEEK 125" W0088400 "JOB NUM 4 (1980) WEEK 126" W0088800 "JOB NUM 4 (1980) WEEK 127" W0089200 "JOB NUM 4 (1980) WEEK 128" W0089600 "JOB NUM 4 (1980) WEEK 129" W0090000 "JOB NUM 4 (1980) WEEK 130" W0090400 "JOB NUM 4 (1980) WEEK 131" W0090800 "JOB NUM 4 (1980) WEEK 132" W0160200 "JOB NUM 4 (1982) WEEK 210" W0160600 "JOB NUM 4 (1982) WEEK 211" W0162200 "JOB NUM 4 (1982) WEEK 215" W0283700 "JOB NUM 4 (1985) WEEK 375" W0284100 "JOB NUM 4 (1985) WEEK 376" W0284500 "JOB NUM 4 (1985) WEEK 377" W0284900 "JOB NUM 4 (1985) WEEK 378" W0285300 "JOB NUM 4 (1985) WEEK 379" W0285700 "JOB NUM 4 (1985) WEEK 380" W0286100 "JOB NUM 4 (1985) WEEK 381" W0286500 "JOB NUM 4 (1985) WEEK 382" W0286900 "JOB NUM 4 (1985) WEEK 383" W0287300 "JOB NUM 4 (1985) WEEK 384" W0295300 "JOB NUM 4 (1985) WEEK 404" W0295700 "JOB NUM 4 (1985) WEEK 405" W0296100 "JOB NUM 4 (1985) WEEK 406" W0296500 "JOB NUM 4 (1985) WEEK 407" W0296900 "JOB NUM 4 (1985) WEEK 408" W0297300 "JOB NUM 4 (1985) WEEK 409" W0297700 "JOB NUM 4 (1985) WEEK 410" W0298100 "JOB NUM 4 (1985) WEEK 411" W0298500 "JOB NUM 4 (1985) WEEK 412" W0298900 "JOB NUM 4 (1985) WEEK 413" W0299300 "JOB NUM 4 (1985) WEEK 414" W0299700 "JOB NUM 4 (1985) WEEK 415" W0300100 "JOB NUM 4 (1985) WEEK 416" W0366300 "JOB NUM 4 (1987) WEEK 486" W0413800 "JOB NUM 4 (1988) WEEK 557" W0414200 "JOB NUM 4 (1988) WEEK 558" W0414600 "JOB NUM 4 (1988) WEEK 559" W0415000 "JOB NUM 4 (1988) WEEK 560" W0415400 "JOB NUM 4 (1988) WEEK 561" W0415800 "JOB NUM 4 (1988) WEEK 562" W0416200 "JOB NUM 4 (1988) WEEK 563" W0416600 "JOB NUM 4 (1988) WEEK 564" W0417000 "JOB NUM 4 (1988) WEEK 565" W0417400 "JOB NUM 4 (1988) WEEK 566" W0417800 "JOB NUM 4 (1988) WEEK 567" W0418200 "JOB NUM 4 (1988) WEEK 568" W0418600 "JOB NUM 4 (1988) WEEK 569" W0419000 "JOB NUM 4 (1988) WEEK 570" W0419400 "JOB NUM 4 (1988) WEEK 571" W0419800 "JOB NUM 4 (1988) WEEK 572" W0420200 "JOB NUM 4 (1988) WEEK 573" W0420600 "JOB NUM 4 (1988) WEEK 574" W0440200 "JOB NUM 4 (1989) WEEK 575" W0440600 "JOB NUM 4 (1989) WEEK 576" W0441000 "JOB NUM 4 (1989) WEEK 577" W0441400 "JOB NUM 4 (1989) WEEK 578" W0441800 "JOB NUM 4 (1989) WEEK 579" W0442200 "JOB NUM 4 (1989) WEEK 580" W0442600 "JOB NUM 4 (1989) WEEK 581" W0443000 "JOB NUM 4 (1989) WEEK 582" W0528500 "JOB NUM 4 (1991) WEEK 700" W0528900 "JOB NUM 4 (1991) WEEK 701" W0529300 "JOB NUM 4 (1991) WEEK 702" W0529700 "JOB NUM 4 (1991) WEEK 703" W0574400 "JOB NUM 4 (1992) WEEK 767" W0574800 "JOB NUM 4 (1992) WEEK 768" W0575200 "JOB NUM 4 (1992) WEEK 769" W0575600 "JOB NUM 4 (1992) WEEK 770" W0576000 "JOB NUM 4 (1992) WEEK 771" W0576400 "JOB NUM 4 (1992) WEEK 772" W0576800 "JOB NUM 4 (1992) WEEK 773" W0577200 "JOB NUM 4 (1992) WEEK 774" W0577600 "JOB NUM 4 (1992) WEEK 775" W0578000 "JOB NUM 4 (1992) WEEK 776" W0578400 "JOB NUM 4 (1992) WEEK 777" W0578800 "JOB NUM 4 (1992) WEEK 778" W0579200 "JOB NUM 4 (1992) WEEK 779" W0579600 "JOB NUM 4 (1992) WEEK 780" W0580000 "JOB NUM 4 (1992) WEEK 781" W0580400 "JOB NUM 4 (1992) WEEK 782" W0580800 "JOB NUM 4 (1992) WEEK 783" W0600300 "JOB NUM 4 (1993) WEEK 784" W0600700 "JOB NUM 4 (1993) WEEK 785" W0601100 "JOB NUM 4 (1993) WEEK 786" W0601500 "JOB NUM 4 (1993) WEEK 787" W0601900 "JOB NUM 4 (1993) WEEK 788" W0602300 "JOB NUM 4 (1993) WEEK 789" W0602700 "JOB NUM 4 (1993) WEEK 790" W0603100 "JOB NUM 4 (1993) WEEK 791" W0603900 "JOB NUM 4 (1993) WEEK 793" W0604300 "JOB NUM 4 (1993) WEEK 794" W0604700 "JOB NUM 4 (1993) WEEK 795" W0605100 "JOB NUM 4 (1993) WEEK 796" W0606300 "JOB NUM 4 (1993) WEEK 799" W0606700 "JOB NUM 4 (1993) WEEK 800" W0607100 "JOB NUM 4 (1993) WEEK 801" W0607500 "JOB NUM 4 (1993) WEEK 802" W0607900 "JOB NUM 4 (1993) WEEK 803" W0608300 "JOB NUM 4 (1993) WEEK 804" W0613900 "JOB NUM 4 (1993) WEEK 818" W0614300 "JOB NUM 4 (1993) WEEK 819" W0614700 "JOB NUM 4 (1993) WEEK 820" W0615100 "JOB NUM 4 (1993) WEEK 821" W0615500 "JOB NUM 4 (1993) WEEK 822" W0615900 "JOB NUM 4 (1993) WEEK 823" W0616300 "JOB NUM 4 (1993) WEEK 824" W0616700 "JOB NUM 4 (1993) WEEK 825" W0617100 "JOB NUM 4 (1993) WEEK 826" W0617500 "JOB NUM 4 (1993) WEEK 827" W0617900 "JOB NUM 4 (1993) WEEK 828" W0618300 "JOB NUM 4 (1993) WEEK 829" W0618700 "JOB NUM 4 (1993) WEEK 830" W0619100 "JOB NUM 4 (1993) WEEK 831" W0619500 "JOB NUM 4 (1993) WEEK 832" W0619900 "JOB NUM 4 (1993) WEEK 833" W0620300 "JOB NUM 4 (1993) WEEK 834" W0620700 "JOB NUM 4 (1993) WEEK 835" W0640200 "JOB NUM 4 (1994) WEEK 836" W0640600 "JOB NUM 4 (1994) WEEK 837" W0641000 "JOB NUM 4 (1994) WEEK 838" W0641400 "JOB NUM 4 (1994) WEEK 839" W0641800 "JOB NUM 4 (1994) WEEK 840" W0642200 "JOB NUM 4 (1994) WEEK 841" W0642600 "JOB NUM 4 (1994) WEEK 842" W0643000 "JOB NUM 4 (1994) WEEK 843" W0643400 "JOB NUM 4 (1994) WEEK 844" W0643800 "JOB NUM 4 (1994) WEEK 845" W0644200 "JOB NUM 4 (1994) WEEK 846" W0644600 "JOB NUM 4 (1994) WEEK 847" W0645000 "JOB NUM 4 (1994) WEEK 848" W0645400 "JOB NUM 4 (1994) WEEK 849" W0645800 "JOB NUM 4 (1994) WEEK 850" W0646200 "JOB NUM 4 (1994) WEEK 851" W0646600 "JOB NUM 4 (1994) WEEK 852" W0647000 "JOB NUM 4 (1994) WEEK 853" W0647400 "JOB NUM 4 (1994) WEEK 854" W0647800 "JOB NUM 4 (1994) WEEK 855" W0648200 "JOB NUM 4 (1994) WEEK 856" W0648600 "JOB NUM 4 (1994) WEEK 857" W0649000 "JOB NUM 4 (1994) WEEK 858" W0649400 "JOB NUM 4 (1994) WEEK 859" W0649800 "JOB NUM 4 (1994) WEEK 860" } (12,686 observations read) . #delimit cr delimiter now cr . do `raw'`prg'-value-labels.do . label define vlR0214700 1 "HISPANIC" 2 "BLACK" 3 "NON-BLACK, NON-HISPANIC" . label values R0214700 vlR0214700 . label define vlR0214800 1 "MALE" 2 "FEMALE" . label values R0214800 vlR0214800 . label define vlW0085200 0 "0: NO DUAL JOB REPORTED" . label values W0085200 vlW0085200 . label define vlW0086800 0 "0: NO DUAL JOB REPORTED" . label values W0086800 vlW0086800 . label define vlW0087200 0 "0: NO DUAL JOB REPORTED" . label values W0087200 vlW0087200 . label define vlW0087600 0 "0: NO DUAL JOB REPORTED" . label values W0087600 vlW0087600 . label define vlW0088000 0 "0: NO DUAL JOB REPORTED" . label values W0088000 vlW0088000 . label define vlW0088400 0 "0: NO DUAL JOB REPORTED" . label values W0088400 vlW0088400 . label define vlW0088800 0 "0: NO DUAL JOB REPORTED" . label values W0088800 vlW0088800 . label define vlW0089200 0 "0: NO DUAL JOB REPORTED" . label values W0089200 vlW0089200 . label define vlW0089600 0 "0: NO DUAL JOB REPORTED" . label values W0089600 vlW0089600 . label define vlW0090000 0 "0: NO DUAL JOB REPORTED" . label values W0090000 vlW0090000 . label define vlW0090400 0 "0: NO DUAL JOB REPORTED" . label values W0090400 vlW0090400 . label define vlW0090800 0 "0: NO DUAL JOB REPORTED" . label values W0090800 vlW0090800 . label define vlW0160200 0 "0: NO DUAL JOB REPORTED" . label values W0160200 vlW0160200 . label define vlW0160600 0 "0: NO DUAL JOB REPORTED" . label values W0160600 vlW0160600 . label define vlW0162200 0 "0: NO DUAL JOB REPORTED" . label values W0162200 vlW0162200 . label define vlW0283700 0 "0: NO DUAL JOB REPORTED" . label values W0283700 vlW0283700 . label define vlW0284100 0 "0: NO DUAL JOB REPORTED" . label values W0284100 vlW0284100 . label define vlW0284500 0 "0: NO DUAL JOB REPORTED" . label values W0284500 vlW0284500 . label define vlW0284900 0 "0: NO DUAL JOB REPORTED" . label values W0284900 vlW0284900 . label define vlW0285300 0 "0: NO DUAL JOB REPORTED" . label values W0285300 vlW0285300 . label define vlW0285700 0 "0: NO DUAL JOB REPORTED" . label values W0285700 vlW0285700 . label define vlW0286100 0 "0: NO DUAL JOB REPORTED" . label values W0286100 vlW0286100 . label define vlW0286500 0 "0: NO DUAL JOB REPORTED" . label values W0286500 vlW0286500 . label define vlW0286900 0 "0: NO DUAL JOB REPORTED" . label values W0286900 vlW0286900 . label define vlW0287300 0 "0: NO DUAL JOB REPORTED" . label values W0287300 vlW0287300 . label define vlW0295300 0 "0: NO DUAL JOB REPORTED" . label values W0295300 vlW0295300 . label define vlW0295700 0 "0: NO DUAL JOB REPORTED" . label values W0295700 vlW0295700 . label define vlW0296100 0 "0: NO DUAL JOB REPORTED" . label values W0296100 vlW0296100 . label define vlW0296500 0 "0: NO DUAL JOB REPORTED" . label values W0296500 vlW0296500 . label define vlW0296900 0 "0: NO DUAL JOB REPORTED" . label values W0296900 vlW0296900 . label define vlW0297300 0 "0: NO DUAL JOB REPORTED" . label values W0297300 vlW0297300 . label define vlW0297700 0 "0: NO DUAL JOB REPORTED" . label values W0297700 vlW0297700 . label define vlW0298100 0 "0: NO DUAL JOB REPORTED" . label values W0298100 vlW0298100 . label define vlW0298500 0 "0: NO DUAL JOB REPORTED" . label values W0298500 vlW0298500 . label define vlW0298900 0 "0: NO DUAL JOB REPORTED" . label values W0298900 vlW0298900 . label define vlW0299300 0 "0: NO DUAL JOB REPORTED" . label values W0299300 vlW0299300 . label define vlW0299700 0 "0: NO DUAL JOB REPORTED" . label values W0299700 vlW0299700 . label define vlW0300100 0 "0: NO DUAL JOB REPORTED" . label values W0300100 vlW0300100 . label define vlW0366300 0 "0: NO DUAL JOB REPORTED" . label values W0366300 vlW0366300 . label define vlW0413800 0 "0: NO DUAL JOB REPORTED" . label values W0413800 vlW0413800 . label define vlW0414200 0 "0: NO DUAL JOB REPORTED" . label values W0414200 vlW0414200 . label define vlW0414600 0 "0: NO DUAL JOB REPORTED" . label values W0414600 vlW0414600 . label define vlW0415000 0 "0: NO DUAL JOB REPORTED" . label values W0415000 vlW0415000 . label define vlW0415400 0 "0: NO DUAL JOB REPORTED" . label values W0415400 vlW0415400 . label define vlW0415800 0 "0: NO DUAL JOB REPORTED" . label values W0415800 vlW0415800 . label define vlW0416200 0 "0: NO DUAL JOB REPORTED" . label values W0416200 vlW0416200 . label define vlW0416600 0 "0: NO DUAL JOB REPORTED" . label values W0416600 vlW0416600 . label define vlW0417000 0 "0: NO DUAL JOB REPORTED" . label values W0417000 vlW0417000 . label define vlW0417400 0 "0: NO DUAL JOB REPORTED" . label values W0417400 vlW0417400 . label define vlW0417800 0 "0: NO DUAL JOB REPORTED" . label values W0417800 vlW0417800 . label define vlW0418200 0 "0: NO DUAL JOB REPORTED" . label values W0418200 vlW0418200 . label define vlW0418600 0 "0: NO DUAL JOB REPORTED" . label values W0418600 vlW0418600 . label define vlW0419000 0 "0: NO DUAL JOB REPORTED" . label values W0419000 vlW0419000 . label define vlW0419400 0 "0: NO DUAL JOB REPORTED" . label values W0419400 vlW0419400 . label define vlW0419800 0 "0: NO DUAL JOB REPORTED" . label values W0419800 vlW0419800 . label define vlW0420200 0 "0: NO DUAL JOB REPORTED" . label values W0420200 vlW0420200 . label define vlW0420600 0 "0: NO DUAL JOB REPORTED" . label values W0420600 vlW0420600 . label define vlW0440200 0 "0: NO DUAL JOB REPORTED" . label values W0440200 vlW0440200 . label define vlW0440600 0 "0: NO DUAL JOB REPORTED" . label values W0440600 vlW0440600 . label define vlW0441000 0 "0: NO DUAL JOB REPORTED" . label values W0441000 vlW0441000 . label define vlW0441400 0 "0: NO DUAL JOB REPORTED" . label values W0441400 vlW0441400 . label define vlW0441800 0 "0: NO DUAL JOB REPORTED" . label values W0441800 vlW0441800 . label define vlW0442200 0 "0: NO DUAL JOB REPORTED" . label values W0442200 vlW0442200 . label define vlW0442600 0 "0: NO DUAL JOB REPORTED" . label values W0442600 vlW0442600 . label define vlW0443000 0 "0: NO DUAL JOB REPORTED" . label values W0443000 vlW0443000 . label define vlW0528500 0 "0: NO DUAL JOB REPORTED" . label values W0528500 vlW0528500 . label define vlW0528900 0 "0: NO DUAL JOB REPORTED" . label values W0528900 vlW0528900 . label define vlW0529300 0 "0: NO DUAL JOB REPORTED" . label values W0529300 vlW0529300 . label define vlW0529700 0 "0: NO DUAL JOB REPORTED" . label values W0529700 vlW0529700 . label define vlW0574400 0 "0: NO DUAL JOB REPORTED" . label values W0574400 vlW0574400 . label define vlW0574800 0 "0: NO DUAL JOB REPORTED" . label values W0574800 vlW0574800 . label define vlW0575200 0 "0: NO DUAL JOB REPORTED" . label values W0575200 vlW0575200 . label define vlW0575600 0 "0: NO DUAL JOB REPORTED" . label values W0575600 vlW0575600 . label define vlW0576000 0 "0: NO DUAL JOB REPORTED" . label values W0576000 vlW0576000 . label define vlW0576400 0 "0: NO DUAL JOB REPORTED" . label values W0576400 vlW0576400 . label define vlW0576800 0 "0: NO DUAL JOB REPORTED" . label values W0576800 vlW0576800 . label define vlW0577200 0 "0: NO DUAL JOB REPORTED" . label values W0577200 vlW0577200 . label define vlW0577600 0 "0: NO DUAL JOB REPORTED" . label values W0577600 vlW0577600 . label define vlW0578000 0 "0: NO DUAL JOB REPORTED" . label values W0578000 vlW0578000 . label define vlW0578400 0 "0: NO DUAL JOB REPORTED" . label values W0578400 vlW0578400 . label define vlW0578800 0 "0: NO DUAL JOB REPORTED" . label values W0578800 vlW0578800 . label define vlW0579200 0 "0: NO DUAL JOB REPORTED" . label values W0579200 vlW0579200 . label define vlW0579600 0 "0: NO DUAL JOB REPORTED" . label values W0579600 vlW0579600 . label define vlW0580000 0 "0: NO DUAL JOB REPORTED" . label values W0580000 vlW0580000 . label define vlW0580400 0 "0: NO DUAL JOB REPORTED" . label values W0580400 vlW0580400 . label define vlW0580800 0 "0: NO DUAL JOB REPORTED" . label values W0580800 vlW0580800 . label define vlW0600300 0 "0: NO DUAL JOB REPORTED" . label values W0600300 vlW0600300 . label define vlW0600700 0 "0: NO DUAL JOB REPORTED" . label values W0600700 vlW0600700 . label define vlW0601100 0 "0: NO DUAL JOB REPORTED" . label values W0601100 vlW0601100 . label define vlW0601500 0 "0: NO DUAL JOB REPORTED" . label values W0601500 vlW0601500 . label define vlW0601900 0 "0: NO DUAL JOB REPORTED" . label values W0601900 vlW0601900 . label define vlW0602300 0 "0: NO DUAL JOB REPORTED" . label values W0602300 vlW0602300 . label define vlW0602700 0 "0: NO DUAL JOB REPORTED" . label values W0602700 vlW0602700 . label define vlW0603100 0 "0: NO DUAL JOB REPORTED" . label values W0603100 vlW0603100 . label define vlW0603900 0 "0: NO DUAL JOB REPORTED" . label values W0603900 vlW0603900 . label define vlW0604300 0 "0: NO DUAL JOB REPORTED" . label values W0604300 vlW0604300 . label define vlW0604700 0 "0: NO DUAL JOB REPORTED" . label values W0604700 vlW0604700 . label define vlW0605100 0 "0: NO DUAL JOB REPORTED" . label values W0605100 vlW0605100 . label define vlW0606300 0 "0: NO DUAL JOB REPORTED" . label values W0606300 vlW0606300 . label define vlW0606700 0 "0: NO DUAL JOB REPORTED" . label values W0606700 vlW0606700 . label define vlW0607100 0 "0: NO DUAL JOB REPORTED" . label values W0607100 vlW0607100 . label define vlW0607500 0 "0: NO DUAL JOB REPORTED" . label values W0607500 vlW0607500 . label define vlW0607900 0 "0: NO DUAL JOB REPORTED" . label values W0607900 vlW0607900 . label define vlW0608300 0 "0: NO DUAL JOB REPORTED" . label values W0608300 vlW0608300 . label define vlW0613900 0 "0: NO DUAL JOB REPORTED" . label values W0613900 vlW0613900 . label define vlW0614300 0 "0: NO DUAL JOB REPORTED" . label values W0614300 vlW0614300 . label define vlW0614700 0 "0: NO DUAL JOB REPORTED" . label values W0614700 vlW0614700 . label define vlW0615100 0 "0: NO DUAL JOB REPORTED" . label values W0615100 vlW0615100 . label define vlW0615500 0 "0: NO DUAL JOB REPORTED" . label values W0615500 vlW0615500 . label define vlW0615900 0 "0: NO DUAL JOB REPORTED" . label values W0615900 vlW0615900 . label define vlW0616300 0 "0: NO DUAL JOB REPORTED" . label values W0616300 vlW0616300 . label define vlW0616700 0 "0: NO DUAL JOB REPORTED" . label values W0616700 vlW0616700 . label define vlW0617100 0 "0: NO DUAL JOB REPORTED" . label values W0617100 vlW0617100 . label define vlW0617500 0 "0: NO DUAL JOB REPORTED" . label values W0617500 vlW0617500 . label define vlW0617900 0 "0: NO DUAL JOB REPORTED" . label values W0617900 vlW0617900 . label define vlW0618300 0 "0: NO DUAL JOB REPORTED" . label values W0618300 vlW0618300 . label define vlW0618700 0 "0: NO DUAL JOB REPORTED" . label values W0618700 vlW0618700 . label define vlW0619100 0 "0: NO DUAL JOB REPORTED" . label values W0619100 vlW0619100 . label define vlW0619500 0 "0: NO DUAL JOB REPORTED" . label values W0619500 vlW0619500 . label define vlW0619900 0 "0: NO DUAL JOB REPORTED" . label values W0619900 vlW0619900 . label define vlW0620300 0 "0: NO DUAL JOB REPORTED" . label values W0620300 vlW0620300 . label define vlW0620700 0 "0: NO DUAL JOB REPORTED" . label values W0620700 vlW0620700 . label define vlW0640200 0 "0: NO DUAL JOB REPORTED" . label values W0640200 vlW0640200 . label define vlW0640600 0 "0: NO DUAL JOB REPORTED" . label values W0640600 vlW0640600 . label define vlW0641000 0 "0: NO DUAL JOB REPORTED" . label values W0641000 vlW0641000 . label define vlW0641400 0 "0: NO DUAL JOB REPORTED" . label values W0641400 vlW0641400 . label define vlW0641800 0 "0: NO DUAL JOB REPORTED" . label values W0641800 vlW0641800 . label define vlW0642200 0 "0: NO DUAL JOB REPORTED" . label values W0642200 vlW0642200 . label define vlW0642600 0 "0: NO DUAL JOB REPORTED" . label values W0642600 vlW0642600 . label define vlW0643000 0 "0: NO DUAL JOB REPORTED" . label values W0643000 vlW0643000 . label define vlW0643400 0 "0: NO DUAL JOB REPORTED" . label values W0643400 vlW0643400 . label define vlW0643800 0 "0: NO DUAL JOB REPORTED" . label values W0643800 vlW0643800 . label define vlW0644200 0 "0: NO DUAL JOB REPORTED" . label values W0644200 vlW0644200 . label define vlW0644600 0 "0: NO DUAL JOB REPORTED" . label values W0644600 vlW0644600 . label define vlW0645000 0 "0: NO DUAL JOB REPORTED" . label values W0645000 vlW0645000 . label define vlW0645400 0 "0: NO DUAL JOB REPORTED" . label values W0645400 vlW0645400 . label define vlW0645800 0 "0: NO DUAL JOB REPORTED" . label values W0645800 vlW0645800 . label define vlW0646200 0 "0: NO DUAL JOB REPORTED" . label values W0646200 vlW0646200 . label define vlW0646600 0 "0: NO DUAL JOB REPORTED" . label values W0646600 vlW0646600 . label define vlW0647000 0 "0: NO DUAL JOB REPORTED" . label values W0647000 vlW0647000 . label define vlW0647400 0 "0: NO DUAL JOB REPORTED" . label values W0647400 vlW0647400 . label define vlW0647800 0 "0: NO DUAL JOB REPORTED" . label values W0647800 vlW0647800 . label define vlW0648200 0 "0: NO DUAL JOB REPORTED" . label values W0648200 vlW0648200 . label define vlW0648600 0 "0: NO DUAL JOB REPORTED" . label values W0648600 vlW0648600 . label define vlW0649000 0 "0: NO DUAL JOB REPORTED" . label values W0649000 vlW0649000 . label define vlW0649400 0 "0: NO DUAL JOB REPORTED" . label values W0649400 vlW0649400 . label define vlW0649800 0 "0: NO DUAL JOB REPORTED" . label values W0649800 vlW0649800 . /* Crosswalk for Reference number & Question name > * Uncomment and edit this RENAME statement to rename variables for ease of use. > * This command does not guarantee uniqueness > */ . /* *start* */ . /* > rename R0000100 CASEID_1979 > rename R0214700 SAMPLE_RACE_1979 > rename R0214800 SAMPLE_SEX_1979 > rename W0085200 JOB_WK_NUM0118_DUALJOB_NUM4_XRND > rename W0086800 JOB_WK_NUM0122_DUALJOB_NUM4_XRND > rename W0087200 JOB_WK_NUM0123_DUALJOB_NUM4_XRND > rename W0087600 JOB_WK_NUM0124_DUALJOB_NUM4_XRND > rename W0088000 JOB_WK_NUM0125_DUALJOB_NUM4_XRND > rename W0088400 JOB_WK_NUM0126_DUALJOB_NUM4_XRND > rename W0088800 JOB_WK_NUM0127_DUALJOB_NUM4_XRND > rename W0089200 JOB_WK_NUM0128_DUALJOB_NUM4_XRND > rename W0089600 JOB_WK_NUM0129_DUALJOB_NUM4_XRND > rename W0090000 JOB_WK_NUM0130_DUALJOB_NUM4_XRND > rename W0090400 JOB_WK_NUM0131_DUALJOB_NUM4_XRND > rename W0090800 JOB_WK_NUM0132_DUALJOB_NUM4_XRND > rename W0160200 JOB_WK_NUM0210_DUALJOB_NUM4_XRND > rename W0160600 JOB_WK_NUM0211_DUALJOB_NUM4_XRND > rename W0162200 JOB_WK_NUM0215_DUALJOB_NUM4_XRND > rename W0283700 JOB_WK_NUM0375_DUALJOB_NUM4_XRND > rename W0284100 JOB_WK_NUM0376_DUALJOB_NUM4_XRND > rename W0284500 JOB_WK_NUM0377_DUALJOB_NUM4_XRND > rename W0284900 JOB_WK_NUM0378_DUALJOB_NUM4_XRND > rename W0285300 JOB_WK_NUM0379_DUALJOB_NUM4_XRND > rename W0285700 JOB_WK_NUM0380_DUALJOB_NUM4_XRND > rename W0286100 JOB_WK_NUM0381_DUALJOB_NUM4_XRND > rename W0286500 JOB_WK_NUM0382_DUALJOB_NUM4_XRND > rename W0286900 JOB_WK_NUM0383_DUALJOB_NUM4_XRND > rename W0287300 JOB_WK_NUM0384_DUALJOB_NUM4_XRND > rename W0295300 JOB_WK_NUM0404_DUALJOB_NUM4_XRND > rename W0295700 JOB_WK_NUM0405_DUALJOB_NUM4_XRND > rename W0296100 JOB_WK_NUM0406_DUALJOB_NUM4_XRND > rename W0296500 JOB_WK_NUM0407_DUALJOB_NUM4_XRND > rename W0296900 JOB_WK_NUM0408_DUALJOB_NUM4_XRND > rename W0297300 JOB_WK_NUM0409_DUALJOB_NUM4_XRND > rename W0297700 JOB_WK_NUM0410_DUALJOB_NUM4_XRND > rename W0298100 JOB_WK_NUM0411_DUALJOB_NUM4_XRND > rename W0298500 JOB_WK_NUM0412_DUALJOB_NUM4_XRND > rename W0298900 JOB_WK_NUM0413_DUALJOB_NUM4_XRND > rename W0299300 JOB_WK_NUM0414_DUALJOB_NUM4_XRND > rename W0299700 JOB_WK_NUM0415_DUALJOB_NUM4_XRND > rename W0300100 JOB_WK_NUM0416_DUALJOB_NUM4_XRND > rename W0366300 JOB_WK_NUM0486_DUALJOB_NUM4_XRND > rename W0413800 JOB_WK_NUM0557_DUALJOB_NUM4_XRND > rename W0414200 JOB_WK_NUM0558_DUALJOB_NUM4_XRND > rename W0414600 JOB_WK_NUM0559_DUALJOB_NUM4_XRND > rename W0415000 JOB_WK_NUM0560_DUALJOB_NUM4_XRND > rename W0415400 JOB_WK_NUM0561_DUALJOB_NUM4_XRND > rename W0415800 JOB_WK_NUM0562_DUALJOB_NUM4_XRND > rename W0416200 JOB_WK_NUM0563_DUALJOB_NUM4_XRND > rename W0416600 JOB_WK_NUM0564_DUALJOB_NUM4_XRND > rename W0417000 JOB_WK_NUM0565_DUALJOB_NUM4_XRND > rename W0417400 JOB_WK_NUM0566_DUALJOB_NUM4_XRND > rename W0417800 JOB_WK_NUM0567_DUALJOB_NUM4_XRND > rename W0418200 JOB_WK_NUM0568_DUALJOB_NUM4_XRND > rename W0418600 JOB_WK_NUM0569_DUALJOB_NUM4_XRND > rename W0419000 JOB_WK_NUM0570_DUALJOB_NUM4_XRND > rename W0419400 JOB_WK_NUM0571_DUALJOB_NUM4_XRND > rename W0419800 JOB_WK_NUM0572_DUALJOB_NUM4_XRND > rename W0420200 JOB_WK_NUM0573_DUALJOB_NUM4_XRND > rename W0420600 JOB_WK_NUM0574_DUALJOB_NUM4_XRND > rename W0440200 JOB_WK_NUM0575_DUALJOB_NUM4_XRND > rename W0440600 JOB_WK_NUM0576_DUALJOB_NUM4_XRND > rename W0441000 JOB_WK_NUM0577_DUALJOB_NUM4_XRND > rename W0441400 JOB_WK_NUM0578_DUALJOB_NUM4_XRND > rename W0441800 JOB_WK_NUM0579_DUALJOB_NUM4_XRND > rename W0442200 JOB_WK_NUM0580_DUALJOB_NUM4_XRND > rename W0442600 JOB_WK_NUM0581_DUALJOB_NUM4_XRND > rename W0443000 JOB_WK_NUM0582_DUALJOB_NUM4_XRND > rename W0528500 JOB_WK_NUM0700_DUALJOB_NUM4_XRND > rename W0528900 JOB_WK_NUM0701_DUALJOB_NUM4_XRND > rename W0529300 JOB_WK_NUM0702_DUALJOB_NUM4_XRND > rename W0529700 JOB_WK_NUM0703_DUALJOB_NUM4_XRND > rename W0574400 JOB_WK_NUM0767_DUALJOB_NUM4_XRND > rename W0574800 JOB_WK_NUM0768_DUALJOB_NUM4_XRND > rename W0575200 JOB_WK_NUM0769_DUALJOB_NUM4_XRND > rename W0575600 JOB_WK_NUM0770_DUALJOB_NUM4_XRND > rename W0576000 JOB_WK_NUM0771_DUALJOB_NUM4_XRND > rename W0576400 JOB_WK_NUM0772_DUALJOB_NUM4_XRND > rename W0576800 JOB_WK_NUM0773_DUALJOB_NUM4_XRND > rename W0577200 JOB_WK_NUM0774_DUALJOB_NUM4_XRND > rename W0577600 JOB_WK_NUM0775_DUALJOB_NUM4_XRND > rename W0578000 JOB_WK_NUM0776_DUALJOB_NUM4_XRND > rename W0578400 JOB_WK_NUM0777_DUALJOB_NUM4_XRND > rename W0578800 JOB_WK_NUM0778_DUALJOB_NUM4_XRND > rename W0579200 JOB_WK_NUM0779_DUALJOB_NUM4_XRND > rename W0579600 JOB_WK_NUM0780_DUALJOB_NUM4_XRND > rename W0580000 JOB_WK_NUM0781_DUALJOB_NUM4_XRND > rename W0580400 JOB_WK_NUM0782_DUALJOB_NUM4_XRND > rename W0580800 JOB_WK_NUM0783_DUALJOB_NUM4_XRND > rename W0600300 JOB_WK_NUM0784_DUALJOB_NUM4_XRND > rename W0600700 JOB_WK_NUM0785_DUALJOB_NUM4_XRND > rename W0601100 JOB_WK_NUM0786_DUALJOB_NUM4_XRND > rename W0601500 JOB_WK_NUM0787_DUALJOB_NUM4_XRND > rename W0601900 JOB_WK_NUM0788_DUALJOB_NUM4_XRND > rename W0602300 JOB_WK_NUM0789_DUALJOB_NUM4_XRND > rename W0602700 JOB_WK_NUM0790_DUALJOB_NUM4_XRND > rename W0603100 JOB_WK_NUM0791_DUALJOB_NUM4_XRND > rename W0603900 JOB_WK_NUM0793_DUALJOB_NUM4_XRND > rename W0604300 JOB_WK_NUM0794_DUALJOB_NUM4_XRND > rename W0604700 JOB_WK_NUM0795_DUALJOB_NUM4_XRND > rename W0605100 JOB_WK_NUM0796_DUALJOB_NUM4_XRND > rename W0606300 JOB_WK_NUM0799_DUALJOB_NUM4_XRND > rename W0606700 JOB_WK_NUM0800_DUALJOB_NUM4_XRND > rename W0607100 JOB_WK_NUM0801_DUALJOB_NUM4_XRND > rename W0607500 JOB_WK_NUM0802_DUALJOB_NUM4_XRND > rename W0607900 JOB_WK_NUM0803_DUALJOB_NUM4_XRND > rename W0608300 JOB_WK_NUM0804_DUALJOB_NUM4_XRND > rename W0613900 JOB_WK_NUM0818_DUALJOB_NUM4_XRND > rename W0614300 JOB_WK_NUM0819_DUALJOB_NUM4_XRND > rename W0614700 JOB_WK_NUM0820_DUALJOB_NUM4_XRND > rename W0615100 JOB_WK_NUM0821_DUALJOB_NUM4_XRND > rename W0615500 JOB_WK_NUM0822_DUALJOB_NUM4_XRND > rename W0615900 JOB_WK_NUM0823_DUALJOB_NUM4_XRND > rename W0616300 JOB_WK_NUM0824_DUALJOB_NUM4_XRND > rename W0616700 JOB_WK_NUM0825_DUALJOB_NUM4_XRND > rename W0617100 JOB_WK_NUM0826_DUALJOB_NUM4_XRND > rename W0617500 JOB_WK_NUM0827_DUALJOB_NUM4_XRND > rename W0617900 JOB_WK_NUM0828_DUALJOB_NUM4_XRND > rename W0618300 JOB_WK_NUM0829_DUALJOB_NUM4_XRND > rename W0618700 JOB_WK_NUM0830_DUALJOB_NUM4_XRND > rename W0619100 JOB_WK_NUM0831_DUALJOB_NUM4_XRND > rename W0619500 JOB_WK_NUM0832_DUALJOB_NUM4_XRND > rename W0619900 JOB_WK_NUM0833_DUALJOB_NUM4_XRND > rename W0620300 JOB_WK_NUM0834_DUALJOB_NUM4_XRND > rename W0620700 JOB_WK_NUM0835_DUALJOB_NUM4_XRND > rename W0640200 JOB_WK_NUM0836_DUALJOB_NUM4_XRND > rename W0640600 JOB_WK_NUM0837_DUALJOB_NUM4_XRND > rename W0641000 JOB_WK_NUM0838_DUALJOB_NUM4_XRND > rename W0641400 JOB_WK_NUM0839_DUALJOB_NUM4_XRND > rename W0641800 JOB_WK_NUM0840_DUALJOB_NUM4_XRND > rename W0642200 JOB_WK_NUM0841_DUALJOB_NUM4_XRND > rename W0642600 JOB_WK_NUM0842_DUALJOB_NUM4_XRND > rename W0643000 JOB_WK_NUM0843_DUALJOB_NUM4_XRND > rename W0643400 JOB_WK_NUM0844_DUALJOB_NUM4_XRND > rename W0643800 JOB_WK_NUM0845_DUALJOB_NUM4_XRND > rename W0644200 JOB_WK_NUM0846_DUALJOB_NUM4_XRND > rename W0644600 JOB_WK_NUM0847_DUALJOB_NUM4_XRND > rename W0645000 JOB_WK_NUM0848_DUALJOB_NUM4_XRND > rename W0645400 JOB_WK_NUM0849_DUALJOB_NUM4_XRND > rename W0645800 JOB_WK_NUM0850_DUALJOB_NUM4_XRND > rename W0646200 JOB_WK_NUM0851_DUALJOB_NUM4_XRND > rename W0646600 JOB_WK_NUM0852_DUALJOB_NUM4_XRND > rename W0647000 JOB_WK_NUM0853_DUALJOB_NUM4_XRND > rename W0647400 JOB_WK_NUM0854_DUALJOB_NUM4_XRND > rename W0647800 JOB_WK_NUM0855_DUALJOB_NUM4_XRND > rename W0648200 JOB_WK_NUM0856_DUALJOB_NUM4_XRND > rename W0648600 JOB_WK_NUM0857_DUALJOB_NUM4_XRND > rename W0649000 JOB_WK_NUM0858_DUALJOB_NUM4_XRND > rename W0649400 JOB_WK_NUM0859_DUALJOB_NUM4_XRND > rename W0649800 JOB_WK_NUM0860_DUALJOB_NUM4_XRND > */ . /* *end* */ . /* To convert variable names to lower case use the TOLOWER command > * (type findit tolower and follow the links to install). > * TOLOWER VARLIST will change listed variables to lower case; > * TOLOWER without a specified variable list will convert all variables in the dataset to lower case > */ . /* tolower */ . end of do-file . #delimit ; delimiter now ; . rename R0000100 id; . rename R0214800 sex; . rename R0214700 race; . keep if sex=="MALE":vlR0214800; (6,283 observations deleted) . d, varlist; Contains data obs: 6,403 vars: 150 size: 3,841,800 ---------------------------------------------------------------------------------------------------------------------------------- storage display value variable name type format label variable label ---------------------------------------------------------------------------------------------------------------------------------- id float %9.0g ID# (1-12686) 79 race float %23.0g vlR0214700 RACL/ETHNIC COHORT /SCRNR 79 sex float %9.0g vlR0214800 SEX OF R 79 W0085200 float %23.0g vlW0085200 JOB NUM 4 (1980) WEEK 118 W0086800 float %23.0g vlW0086800 JOB NUM 4 (1980) WEEK 122 W0087200 float %23.0g vlW0087200 JOB NUM 4 (1980) WEEK 123 W0087600 float %23.0g vlW0087600 JOB NUM 4 (1980) WEEK 124 W0088000 float %23.0g vlW0088000 JOB NUM 4 (1980) WEEK 125 W0088400 float %23.0g vlW0088400 JOB NUM 4 (1980) WEEK 126 W0088800 float %23.0g vlW0088800 JOB NUM 4 (1980) WEEK 127 W0089200 float %23.0g vlW0089200 JOB NUM 4 (1980) WEEK 128 W0089600 float %23.0g vlW0089600 JOB NUM 4 (1980) WEEK 129 W0090000 float %23.0g vlW0090000 JOB NUM 4 (1980) WEEK 130 W0090400 float %23.0g vlW0090400 JOB NUM 4 (1980) WEEK 131 W0090800 float %23.0g vlW0090800 JOB NUM 4 (1980) WEEK 132 W0160200 float %23.0g vlW0160200 JOB NUM 4 (1982) WEEK 210 W0160600 float %23.0g vlW0160600 JOB NUM 4 (1982) WEEK 211 W0162200 float %23.0g vlW0162200 JOB NUM 4 (1982) WEEK 215 W0283700 float %23.0g vlW0283700 JOB NUM 4 (1985) WEEK 375 W0284100 float %23.0g vlW0284100 JOB NUM 4 (1985) WEEK 376 W0284500 float %23.0g vlW0284500 JOB NUM 4 (1985) WEEK 377 W0284900 float %23.0g vlW0284900 JOB NUM 4 (1985) WEEK 378 W0285300 float %23.0g vlW0285300 JOB NUM 4 (1985) WEEK 379 W0285700 float %23.0g vlW0285700 JOB NUM 4 (1985) WEEK 380 W0286100 float %23.0g vlW0286100 JOB NUM 4 (1985) WEEK 381 W0286500 float %23.0g vlW0286500 JOB NUM 4 (1985) WEEK 382 W0286900 float %23.0g vlW0286900 JOB NUM 4 (1985) WEEK 383 W0287300 float %23.0g vlW0287300 JOB NUM 4 (1985) WEEK 384 W0295300 float %23.0g vlW0295300 JOB NUM 4 (1985) WEEK 404 W0295700 float %23.0g vlW0295700 JOB NUM 4 (1985) WEEK 405 W0296100 float %23.0g vlW0296100 JOB NUM 4 (1985) WEEK 406 W0296500 float %23.0g vlW0296500 JOB NUM 4 (1985) WEEK 407 W0296900 float %23.0g vlW0296900 JOB NUM 4 (1985) WEEK 408 W0297300 float %23.0g vlW0297300 JOB NUM 4 (1985) WEEK 409 W0297700 float %23.0g vlW0297700 JOB NUM 4 (1985) WEEK 410 W0298100 float %23.0g vlW0298100 JOB NUM 4 (1985) WEEK 411 W0298500 float %23.0g vlW0298500 JOB NUM 4 (1985) WEEK 412 W0298900 float %23.0g vlW0298900 JOB NUM 4 (1985) WEEK 413 W0299300 float %23.0g vlW0299300 JOB NUM 4 (1985) WEEK 414 W0299700 float %23.0g vlW0299700 JOB NUM 4 (1985) WEEK 415 W0300100 float %23.0g vlW0300100 JOB NUM 4 (1985) WEEK 416 W0366300 float %23.0g vlW0366300 JOB NUM 4 (1987) WEEK 486 W0413800 float %23.0g vlW0413800 JOB NUM 4 (1988) WEEK 557 W0414200 float %23.0g vlW0414200 JOB NUM 4 (1988) WEEK 558 W0414600 float %23.0g vlW0414600 JOB NUM 4 (1988) WEEK 559 W0415000 float %23.0g vlW0415000 JOB NUM 4 (1988) WEEK 560 W0415400 float %23.0g vlW0415400 JOB NUM 4 (1988) WEEK 561 W0415800 float %23.0g vlW0415800 JOB NUM 4 (1988) WEEK 562 W0416200 float %23.0g vlW0416200 JOB NUM 4 (1988) WEEK 563 W0416600 float %23.0g vlW0416600 JOB NUM 4 (1988) WEEK 564 W0417000 float %23.0g vlW0417000 JOB NUM 4 (1988) WEEK 565 W0417400 float %23.0g vlW0417400 JOB NUM 4 (1988) WEEK 566 W0417800 float %23.0g vlW0417800 JOB NUM 4 (1988) WEEK 567 W0418200 float %23.0g vlW0418200 JOB NUM 4 (1988) WEEK 568 W0418600 float %23.0g vlW0418600 JOB NUM 4 (1988) WEEK 569 W0419000 float %23.0g vlW0419000 JOB NUM 4 (1988) WEEK 570 W0419400 float %23.0g vlW0419400 JOB NUM 4 (1988) WEEK 571 W0419800 float %23.0g vlW0419800 JOB NUM 4 (1988) WEEK 572 W0420200 float %23.0g vlW0420200 JOB NUM 4 (1988) WEEK 573 W0420600 float %23.0g vlW0420600 JOB NUM 4 (1988) WEEK 574 W0440200 float %23.0g vlW0440200 JOB NUM 4 (1989) WEEK 575 W0440600 float %23.0g vlW0440600 JOB NUM 4 (1989) WEEK 576 W0441000 float %23.0g vlW0441000 JOB NUM 4 (1989) WEEK 577 W0441400 float %23.0g vlW0441400 JOB NUM 4 (1989) WEEK 578 W0441800 float %23.0g vlW0441800 JOB NUM 4 (1989) WEEK 579 W0442200 float %23.0g vlW0442200 JOB NUM 4 (1989) WEEK 580 W0442600 float %23.0g vlW0442600 JOB NUM 4 (1989) WEEK 581 W0443000 float %23.0g vlW0443000 JOB NUM 4 (1989) WEEK 582 W0528500 float %23.0g vlW0528500 JOB NUM 4 (1991) WEEK 700 W0528900 float %23.0g vlW0528900 JOB NUM 4 (1991) WEEK 701 W0529300 float %23.0g vlW0529300 JOB NUM 4 (1991) WEEK 702 W0529700 float %23.0g vlW0529700 JOB NUM 4 (1991) WEEK 703 W0574400 float %23.0g vlW0574400 JOB NUM 4 (1992) WEEK 767 W0574800 float %23.0g vlW0574800 JOB NUM 4 (1992) WEEK 768 W0575200 float %23.0g vlW0575200 JOB NUM 4 (1992) WEEK 769 W0575600 float %23.0g vlW0575600 JOB NUM 4 (1992) WEEK 770 W0576000 float %23.0g vlW0576000 JOB NUM 4 (1992) WEEK 771 W0576400 float %23.0g vlW0576400 JOB NUM 4 (1992) WEEK 772 W0576800 float %23.0g vlW0576800 JOB NUM 4 (1992) WEEK 773 W0577200 float %23.0g vlW0577200 JOB NUM 4 (1992) WEEK 774 W0577600 float %23.0g vlW0577600 JOB NUM 4 (1992) WEEK 775 W0578000 float %23.0g vlW0578000 JOB NUM 4 (1992) WEEK 776 W0578400 float %23.0g vlW0578400 JOB NUM 4 (1992) WEEK 777 W0578800 float %23.0g vlW0578800 JOB NUM 4 (1992) WEEK 778 W0579200 float %23.0g vlW0579200 JOB NUM 4 (1992) WEEK 779 W0579600 float %23.0g vlW0579600 JOB NUM 4 (1992) WEEK 780 W0580000 float %23.0g vlW0580000 JOB NUM 4 (1992) WEEK 781 W0580400 float %23.0g vlW0580400 JOB NUM 4 (1992) WEEK 782 W0580800 float %23.0g vlW0580800 JOB NUM 4 (1992) WEEK 783 W0600300 float %23.0g vlW0600300 JOB NUM 4 (1993) WEEK 784 W0600700 float %23.0g vlW0600700 JOB NUM 4 (1993) WEEK 785 W0601100 float %23.0g vlW0601100 JOB NUM 4 (1993) WEEK 786 W0601500 float %23.0g vlW0601500 JOB NUM 4 (1993) WEEK 787 W0601900 float %23.0g vlW0601900 JOB NUM 4 (1993) WEEK 788 W0602300 float %23.0g vlW0602300 JOB NUM 4 (1993) WEEK 789 W0602700 float %23.0g vlW0602700 JOB NUM 4 (1993) WEEK 790 W0603100 float %23.0g vlW0603100 JOB NUM 4 (1993) WEEK 791 W0603900 float %23.0g vlW0603900 JOB NUM 4 (1993) WEEK 793 W0604300 float %23.0g vlW0604300 JOB NUM 4 (1993) WEEK 794 W0604700 float %23.0g vlW0604700 JOB NUM 4 (1993) WEEK 795 W0605100 float %23.0g vlW0605100 JOB NUM 4 (1993) WEEK 796 W0606300 float %23.0g vlW0606300 JOB NUM 4 (1993) WEEK 799 W0606700 float %23.0g vlW0606700 JOB NUM 4 (1993) WEEK 800 W0607100 float %23.0g vlW0607100 JOB NUM 4 (1993) WEEK 801 W0607500 float %23.0g vlW0607500 JOB NUM 4 (1993) WEEK 802 W0607900 float %23.0g vlW0607900 JOB NUM 4 (1993) WEEK 803 W0608300 float %23.0g vlW0608300 JOB NUM 4 (1993) WEEK 804 W0613900 float %23.0g vlW0613900 JOB NUM 4 (1993) WEEK 818 W0614300 float %23.0g vlW0614300 JOB NUM 4 (1993) WEEK 819 W0614700 float %23.0g vlW0614700 JOB NUM 4 (1993) WEEK 820 W0615100 float %23.0g vlW0615100 JOB NUM 4 (1993) WEEK 821 W0615500 float %23.0g vlW0615500 JOB NUM 4 (1993) WEEK 822 W0615900 float %23.0g vlW0615900 JOB NUM 4 (1993) WEEK 823 W0616300 float %23.0g vlW0616300 JOB NUM 4 (1993) WEEK 824 W0616700 float %23.0g vlW0616700 JOB NUM 4 (1993) WEEK 825 W0617100 float %23.0g vlW0617100 JOB NUM 4 (1993) WEEK 826 W0617500 float %23.0g vlW0617500 JOB NUM 4 (1993) WEEK 827 W0617900 float %23.0g vlW0617900 JOB NUM 4 (1993) WEEK 828 W0618300 float %23.0g vlW0618300 JOB NUM 4 (1993) WEEK 829 W0618700 float %23.0g vlW0618700 JOB NUM 4 (1993) WEEK 830 W0619100 float %23.0g vlW0619100 JOB NUM 4 (1993) WEEK 831 W0619500 float %23.0g vlW0619500 JOB NUM 4 (1993) WEEK 832 W0619900 float %23.0g vlW0619900 JOB NUM 4 (1993) WEEK 833 W0620300 float %23.0g vlW0620300 JOB NUM 4 (1993) WEEK 834 W0620700 float %23.0g vlW0620700 JOB NUM 4 (1993) WEEK 835 W0640200 float %23.0g vlW0640200 JOB NUM 4 (1994) WEEK 836 W0640600 float %23.0g vlW0640600 JOB NUM 4 (1994) WEEK 837 W0641000 float %23.0g vlW0641000 JOB NUM 4 (1994) WEEK 838 W0641400 float %23.0g vlW0641400 JOB NUM 4 (1994) WEEK 839 W0641800 float %23.0g vlW0641800 JOB NUM 4 (1994) WEEK 840 W0642200 float %23.0g vlW0642200 JOB NUM 4 (1994) WEEK 841 W0642600 float %23.0g vlW0642600 JOB NUM 4 (1994) WEEK 842 W0643000 float %23.0g vlW0643000 JOB NUM 4 (1994) WEEK 843 W0643400 float %23.0g vlW0643400 JOB NUM 4 (1994) WEEK 844 W0643800 float %23.0g vlW0643800 JOB NUM 4 (1994) WEEK 845 W0644200 float %23.0g vlW0644200 JOB NUM 4 (1994) WEEK 846 W0644600 float %23.0g vlW0644600 JOB NUM 4 (1994) WEEK 847 W0645000 float %23.0g vlW0645000 JOB NUM 4 (1994) WEEK 848 W0645400 float %23.0g vlW0645400 JOB NUM 4 (1994) WEEK 849 W0645800 float %23.0g vlW0645800 JOB NUM 4 (1994) WEEK 850 W0646200 float %23.0g vlW0646200 JOB NUM 4 (1994) WEEK 851 W0646600 float %23.0g vlW0646600 JOB NUM 4 (1994) WEEK 852 W0647000 float %23.0g vlW0647000 JOB NUM 4 (1994) WEEK 853 W0647400 float %23.0g vlW0647400 JOB NUM 4 (1994) WEEK 854 W0647800 float %23.0g vlW0647800 JOB NUM 4 (1994) WEEK 855 W0648200 float %23.0g vlW0648200 JOB NUM 4 (1994) WEEK 856 W0648600 float %23.0g vlW0648600 JOB NUM 4 (1994) WEEK 857 W0649000 float %23.0g vlW0649000 JOB NUM 4 (1994) WEEK 858 W0649400 float %23.0g vlW0649400 JOB NUM 4 (1994) WEEK 859 W0649800 float %23.0g vlW0649800 JOB NUM 4 (1994) WEEK 860 ---------------------------------------------------------------------------------------------------------------------------------- Sorted by: Note: Dataset has changed since last saved. . local myvar1 = r(varlist); . local myvar2 id sex race; . local myvar : list myvar1 - myvar2; . foreach vv of local myvar {; 2. mvdecode `vv', mv(-5=. \ -4=. \ -3=. \ -2=. \ -1=.); 3. assert `vv' >= 0 if !missing(`vv'); 4. local xx : variable label `vv'; 5. if regexm("`xx'","JOB NUM 4") {; 6. local wk = substr("`xx'",23,.); 7. }; 8. if regexm("`xx'","JOB NUMBER 4") {; 9. local wk = substr("`xx'",26,.); 10. }; 11. /* di "`wk'"; */ > rename `vv' status_`wk'; 12. }; W0085200: 6403 missing values generated (null assertion) W0086800: 6403 missing values generated (null assertion) W0087200: 6403 missing values generated (null assertion) W0087600: 6403 missing values generated (null assertion) W0088000: 6403 missing values generated (null assertion) W0088400: 6403 missing values generated (null assertion) W0088800: 6403 missing values generated (null assertion) W0089200: 6403 missing values generated (null assertion) W0089600: 6403 missing values generated (null assertion) W0090000: 6402 missing values generated W0090400: 6402 missing values generated W0090800: 6402 missing values generated W0160200: 6402 missing values generated W0160600: 6402 missing values generated W0162200: 6402 missing values generated W0283700: 6402 missing values generated W0284100: 6402 missing values generated W0284500: 6402 missing values generated W0284900: 6402 missing values generated W0285300: 6402 missing values generated W0285700: 6402 missing values generated W0286100: 6402 missing values generated W0286500: 6402 missing values generated W0286900: 6402 missing values generated W0287300: 6402 missing values generated W0295300: 6402 missing values generated W0295700: 6402 missing values generated W0296100: 6402 missing values generated W0296500: 6402 missing values generated W0296900: 6402 missing values generated W0297300: 6402 missing values generated W0297700: 6402 missing values generated W0298100: 6402 missing values generated W0298500: 6402 missing values generated W0298900: 6402 missing values generated W0299300: 6402 missing values generated W0299700: 6402 missing values generated W0300100: 6402 missing values generated W0366300: 6402 missing values generated W0413800: 6402 missing values generated W0414200: 6402 missing values generated W0414600: 6402 missing values generated W0415000: 6402 missing values generated W0415400: 6402 missing values generated W0415800: 6402 missing values generated W0416200: 6402 missing values generated W0416600: 6402 missing values generated W0417000: 6402 missing values generated W0417400: 6402 missing values generated W0417800: 6402 missing values generated W0418200: 6402 missing values generated W0418600: 6402 missing values generated W0419000: 6402 missing values generated W0419400: 6402 missing values generated W0419800: 6402 missing values generated W0420200: 6402 missing values generated W0420600: 6402 missing values generated W0440200: 6402 missing values generated W0440600: 6402 missing values generated W0441000: 6402 missing values generated W0441400: 6402 missing values generated W0441800: 6402 missing values generated W0442200: 6402 missing values generated W0442600: 6402 missing values generated W0443000: 6402 missing values generated W0528500: 6403 missing values generated (null assertion) W0528900: 6403 missing values generated (null assertion) W0529300: 6403 missing values generated (null assertion) W0529700: 6403 missing values generated (null assertion) W0574400: 6403 missing values generated (null assertion) W0574800: 6403 missing values generated (null assertion) W0575200: 6403 missing values generated (null assertion) W0575600: 6403 missing values generated (null assertion) W0576000: 6403 missing values generated (null assertion) W0576400: 6403 missing values generated (null assertion) W0576800: 6403 missing values generated (null assertion) W0577200: 6403 missing values generated (null assertion) W0577600: 6403 missing values generated (null assertion) W0578000: 6403 missing values generated (null assertion) W0578400: 6403 missing values generated (null assertion) W0578800: 6403 missing values generated (null assertion) W0579200: 6403 missing values generated (null assertion) W0579600: 6403 missing values generated (null assertion) W0580000: 6403 missing values generated (null assertion) W0580400: 6403 missing values generated (null assertion) W0580800: 6403 missing values generated (null assertion) W0600300: 6403 missing values generated (null assertion) W0600700: 6403 missing values generated (null assertion) W0601100: 6403 missing values generated (null assertion) W0601500: 6403 missing values generated (null assertion) W0601900: 6403 missing values generated (null assertion) W0602300: 6403 missing values generated (null assertion) W0602700: 6403 missing values generated (null assertion) W0603100: 6403 missing values generated (null assertion) W0603900: 6403 missing values generated (null assertion) W0604300: 6403 missing values generated (null assertion) W0604700: 6403 missing values generated (null assertion) W0605100: 6403 missing values generated (null assertion) W0606300: 6403 missing values generated (null assertion) W0606700: 6403 missing values generated (null assertion) W0607100: 6403 missing values generated (null assertion) W0607500: 6403 missing values generated (null assertion) W0607900: 6403 missing values generated (null assertion) W0608300: 6403 missing values generated (null assertion) W0613900: 6403 missing values generated (null assertion) W0614300: 6403 missing values generated (null assertion) W0614700: 6403 missing values generated (null assertion) W0615100: 6403 missing values generated (null assertion) W0615500: 6403 missing values generated (null assertion) W0615900: 6403 missing values generated (null assertion) W0616300: 6403 missing values generated (null assertion) W0616700: 6403 missing values generated (null assertion) W0617100: 6403 missing values generated (null assertion) W0617500: 6403 missing values generated (null assertion) W0617900: 6403 missing values generated (null assertion) W0618300: 6403 missing values generated (null assertion) W0618700: 6403 missing values generated (null assertion) W0619100: 6403 missing values generated (null assertion) W0619500: 6403 missing values generated (null assertion) W0619900: 6403 missing values generated (null assertion) W0620300: 6403 missing values generated (null assertion) W0620700: 6403 missing values generated (null assertion) W0640200: 6403 missing values generated (null assertion) W0640600: 6403 missing values generated (null assertion) W0641000: 6403 missing values generated (null assertion) W0641400: 6403 missing values generated (null assertion) W0641800: 6403 missing values generated (null assertion) W0642200: 6403 missing values generated (null assertion) W0642600: 6403 missing values generated (null assertion) W0643000: 6403 missing values generated (null assertion) W0643400: 6403 missing values generated (null assertion) W0643800: 6403 missing values generated (null assertion) W0644200: 6403 missing values generated (null assertion) W0644600: 6403 missing values generated (null assertion) W0645000: 6403 missing values generated (null assertion) W0645400: 6403 missing values generated (null assertion) W0645800: 6403 missing values generated (null assertion) W0646200: 6403 missing values generated (null assertion) W0646600: 6403 missing values generated (null assertion) W0647000: 6403 missing values generated (null assertion) W0647400: 6403 missing values generated (null assertion) W0647800: 6403 missing values generated (null assertion) W0648200: 6403 missing values generated (null assertion) W0648600: 6403 missing values generated (null assertion) W0649000: 6403 missing values generated (null assertion) W0649400: 6403 missing values generated (null assertion) W0649800: 6403 missing values generated (null assertion) . /*** break data up in the ranges: > 1 1000 > 1001 2000 > . . > . . > . . > 9001 10000 > 10001 11000 > 11001 12686 > ***/ > > forvalues ii = 0/10 {; 2. local lo = 1000*`ii'+1; 3. local hi = `lo' + 999; 4. di "Low:"; 5. di "`lo'"; 6. di "Hi:"; 7. di "`hi'"; 8. preserve; 9. keep if inrange(id,`lo',`hi'); 10. reshape long status, i(id race sex) j(junk) s; 11. gen week = substr(junk,2,.); 12. destring week, replace; 13. gen datew = yw(1978,1) + week - 1; 14. format datew %tw; 15. rename status status_`jobstatus'; 16. keep id race sex datew status_`jobstatus'; 17. /*** from cents to dollars ***/ > save `tempdata'`prg'_data_`lo'_`hi', replace; 18. restore; 19. }; Low: 1 Hi: 1000 (5,887 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 516 -> 75852 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_1_1000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_1_1000.dta saved Low: 1001 Hi: 2000 (5,935 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 468 -> 68796 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_1001_2000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_1001_2000.dta saved Low: 2001 Hi: 3000 (5,893 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 510 -> 74970 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_2001_3000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_2001_3000.dta saved Low: 3001 Hi: 4000 (5,923 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 480 -> 70560 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_3001_4000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_3001_4000.dta saved Low: 4001 Hi: 5000 (5,912 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 491 -> 72177 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_4001_5000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_4001_5000.dta saved Low: 5001 Hi: 6000 (5,910 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 493 -> 72471 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_5001_6000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_5001_6000.dta saved Low: 6001 Hi: 7000 (5,942 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 461 -> 67767 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_6001_7000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_6001_7000.dta saved Low: 7001 Hi: 8000 (5,934 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 469 -> 68943 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_7001_8000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_7001_8000.dta saved Low: 8001 Hi: 9000 (5,895 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 508 -> 74676 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_8001_9000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_8001_9000.dta saved Low: 9001 Hi: 10000 (5,894 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 509 -> 74823 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_9001_10000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_9001_10000.dta saved Low: 10001 Hi: 11000 (5,855 observations deleted) (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 548 -> 80556 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- week has all characters numeric; replaced as int (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data_10001_11000.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data_10001_11000.dta saved . keep if inrange(id,11001,12686); (5,453 observations deleted) . reshape long status, i(id race sex) j(junk) s; (note: j = _118 _122 _123 _124 _125 _126 _127 _128 _129 _130 _131 _132 _210 _211 _215 _375 _376 _377 _378 _379 _380 _381 _382 _383 > _384 _404 _405 _406 _407 _408 _409 _410 _411 _412 _413 _414 _415 _416 _486 _557 _558 _559 _560 _561 _562 _563 _564 _565 _566 _5 > 67 _568 _569 _570 _571 _572 _573 _574 _575 _576 _577 _578 _579 _580 _581 _582 _700 _701 _702 _703 _767 _768 _769 _770 _771 _772 > _773 _774 _775 _776 _777 _778 _779 _780 _781 _782 _783 _784 _785 _786 _787 _788 _789 _790 _791 _793 _794 _795 _796 _799 _800 _80 > 1 _802 _803 _804 _818 _819 _820 _821 _822 _823 _824 _825 _826 _827 _828 _829 _830 _831 _832 _833 _834 _835 _836 _837 _838 _839 _ > 840 _841 _842 _843 _844 _845 _846 _847 _848 _849 _850 _851 _852 _853 _854 _855 _856 _857 _858 _859 _860) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 950 -> 139650 Number of variables 150 -> 5 j variable (147 values) -> junk xij variables: status_118 status_122 ... status_860 -> status ----------------------------------------------------------------------------- . gen week = substr(junk,2,.); . destring week, replace; week has all characters numeric; replaced as int . gen datew = yw(1978,1) + week - 1; . format datew %tw; . rename status status_`jobstatus'; . keep id race sex datew status_`jobstatus'; . forvalues ii = 0/10 {; 2. local lo = 1000*`ii'+1; 3. local hi = `lo' + 999; 4. di "Low:"; 5. di "`lo'"; 6. di "Hi:"; 7. di "`hi'"; 8. append using `tempdata'`prg'_data_`lo'_`hi'; 9. }; Low: 1 Hi: 1000 (label vlR0214700 already defined) (label vlR0214800 already defined) (label vlW0649800 already defined) Low: 1001 Hi: 2000 (label vlW0649800 already defined) (label vlR0214800 already defined) (label vlR0214700 already defined) Low: 2001 Hi: 3000 (label vlR0214700 already defined) (label vlR0214800 already defined) (label vlW0649800 already defined) Low: 3001 Hi: 4000 (label vlW0649800 already defined) (label vlR0214800 already defined) (label vlR0214700 already defined) Low: 4001 Hi: 5000 (label vlR0214700 already defined) (label vlR0214800 already defined) (label vlW0649800 already defined) Low: 5001 Hi: 6000 (label vlW0649800 already defined) (label vlR0214800 already defined) (label vlR0214700 already defined) Low: 6001 Hi: 7000 (label vlR0214700 already defined) (label vlR0214800 already defined) (label vlW0649800 already defined) Low: 7001 Hi: 8000 (label vlW0649800 already defined) (label vlR0214800 already defined) (label vlR0214700 already defined) Low: 8001 Hi: 9000 (label vlR0214700 already defined) (label vlR0214800 already defined) (label vlW0649800 already defined) Low: 9001 Hi: 10000 (label vlW0649800 already defined) (label vlR0214800 already defined) (label vlR0214700 already defined) Low: 10001 Hi: 11000 (label vlR0214700 already defined) (label vlR0214800 already defined) (label vlW0649800 already defined) . save `tempdata'`prg'_data, replace; (note: file ../temp/JOB_WK_NUM_DUAL_JOB4_data.dta not found) file ../temp/JOB_WK_NUM_DUAL_JOB4_data.dta saved . end of do-file . do raw2dta_JOB_WK_NUM_DUAL_JOB3.do; . /********************************************************************* > Program: raw2dta_JOB_WK_NUM_DUAL_JOB3.do > Purpose: refers to variable name in NLSY79 data. > > Date Started: 10 Dec 2015 > Date Revised: 10 Dec 2015 > *********************************************************************/ . #delimit ; delimiter now ; . clear all; . set mo off; . set scheme s1color; . capture log close;