---------------------------------------------------------------------------------------------------------------------------------- name: log: C:\Users\rwr\Dropbox\basu-house\build\code\../temp/raw2dta_HGCREV.log log type: text opened on: 17 Jul 2016, 12:11:59 . /*****************************************************************************/ > 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" R0216701 "HIGHEST GRADE COMPLTD (REV) 79" R0406401 "HIGHEST GRADE COMPLTD (REV) 80" R0618901 "HIGHEST GRADE COMPLTD (REV) 81" R0898201 "HIGHEST GRADE COMPLTD (REV) 82" R1145001 "HIGHEST GRADE COMPLTD (REV) 83" R1520201 "HIGHEST GRADE COMPLTD (REV) 84" R1890901 "HIGHEST GRADE COMPLTD (REV) 85" R2258001 "HIGHEST GRADE COMPLTD (REV) 86" R2445401 "HIGHEST GRADE COMPLTD (REV) 87" R2871101 "HIGHEST GRADE COMPLTD (REV) 88" R3074801 "HIGHEST GRADE COMPLTD (REV) 89" R3401501 "HIGHEST GRADE COMPLTD (REV) 90" R3656901 "HIGHEST GRADE COMPLTD (REV) 91" R4007401 "HIGHEST GRADE COMPLTD (REV) 92" R4418501 "HIGHEST GRADE COMPLTD (REV) 93" R5103900 "HIGHEST GRADE COMPLTD (REV) 94" R5166901 "HIGHEST GRADE COMPLTD (REV) 96" R6479600 "HIGHEST GRADE COMPLTD (REV) 1998" R7007300 "HIGHEST GRADE COMPLTD (REV) 2000" R7704600 "HIGHEST GRADE COMPLTD (REV) 2002" R8497000 "HIGHEST GRADE COMPLTD (REV) 2004" T0988800 "HIGHEST GRADE COMPLTD (REV) 2006" T2210700 "HIGHEST GRADE COMPLTD (REV) 2008" T3108600 "HIGHEST GRADE COMPLTD (REV) 2010" T4113100 "HIGHEST GRADE COMPLTD (REV) 2012" } (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 vlR0216701 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R0216701 vlR0216701 . label define vlR0406401 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R0406401 vlR0406401 . label define vlR0618901 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R0618901 vlR0618901 . label define vlR0898201 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R0898201 vlR0898201 . label define vlR1145001 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R1145001 vlR1145001 . label define vlR1520201 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R1520201 vlR1520201 . label define vlR1890901 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R1890901 vlR1890901 . label define vlR2258001 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R2258001 vlR2258001 . label define vlR2445401 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R2445401 vlR2445401 . label define vlR2871101 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R2871101 vlR2871101 . label define vlR3074801 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R3074801 vlR3074801 . label define vlR3401501 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R3401501 vlR3401501 . label define vlR3656901 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R3656901 vlR3656901 . label define vlR4007401 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R4007401 vlR4007401 . label define vlR4418501 0 "NONE" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4TH GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 > "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH GRADE" 13 "1ST YR COL" 14 "2ND YR COL" > 15 "3RD YR COL" 16 "4TH YR COL" 17 "5TH YR COL" 18 "6TH YR COL" 19 "7TH YR COL" 20 "8TH YR COL OR MORE" 95 "UNGRADED" . label values R4418501 vlR4418501 . label define vlR5103900 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values R5103900 vlR5103900 . label define vlR5166901 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values R5166901 vlR5166901 . label define vlR6479600 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values R6479600 vlR6479600 . label define vlR7007300 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values R7007300 vlR7007300 . label define vlR7704600 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values R7704600 vlR7704600 . label define vlR8497000 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values R8497000 vlR8497000 . label define vlT0988800 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values T0988800 vlT0988800 . label define vlT2210700 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values T2210700 vlT2210700 . label define vlT3108600 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values T3108600 vlT3108600 . label define vlT4113100 0 "NONE" 93 "PRE-KINDERGARTEN" 94 "KINDERGARTEN" 1 "1ST GRADE" 2 "2ND GRADE" 3 "3RD GRADE" 4 "4T > H GRADE" 5 "5TH GRADE" 6 "6TH GRADE" 7 "7TH GRADE" 8 "8TH GRADE" 9 "9TH GRADE" 10 "10TH GRADE" 11 "11TH GRADE" 12 "12TH > GRADE" 13 "1ST YEAR COLLEGE" 14 "2ND YEAR COLLEGE" 15 "3RD YEAR COLLEGE" 16 "4TH YEAR COLLEGE" 17 "5TH YEAR COLLEGE" 18 "6 > TH YEAR COLLEGE" 19 "7TH YEAR COLLEGE" 20 "8TH YEAR COLLEGE OR MORE" 95 "UNGRADED" . label values T4113100 vlT4113100 . /* 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 R0216701 HGCREV79_1979 > rename R0406401 HGCREV80_1980 > rename R0618901 HGCREV81_1981 > rename R0898201 HGCREV82_1982 > rename R1145001 HGCREV83_1983 > rename R1520201 HGCREV84_1984 > rename R1890901 HGCREV85_1985 > rename R2258001 HGCREV86_1986 > rename R2445401 HGCREV87_1987 > rename R2871101 HGCREV88_1988 > rename R3074801 HGCREV89_1989 > rename R3401501 HGCREV90_1990 > rename R3656901 HGCREV91_1991 > rename R4007401 HGCREV92_1992 > rename R4418501 HGCREV93_1993 > rename R5103900 HGCREV94_1994 > rename R5166901 HGCREV96_1996 > rename R6479600 HGCREV98_1998 > rename R7007300 HGCREV00_2000 > rename R7704600 HGCREV02_2002 > rename R8497000 HGCREV04_2004 > rename T0988800 HGCREV06_2006 > rename T2210700 HGCREV08_2008 > rename T3108600 HGCREV10_2010 > rename T4113100 HGCREV12_2012 > */ . /* *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: 28 size: 717,136 ---------------------------------------------------------------------------------------------------------------------------------- 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 R0216701 float %18.0g vlR0216701 HIGHEST GRADE COMPLTD (REV) 79 R0406401 float %18.0g vlR0406401 HIGHEST GRADE COMPLTD (REV) 80 R0618901 float %18.0g vlR0618901 HIGHEST GRADE COMPLTD (REV) 81 R0898201 float %18.0g vlR0898201 HIGHEST GRADE COMPLTD (REV) 82 R1145001 float %18.0g vlR1145001 HIGHEST GRADE COMPLTD (REV) 83 R1520201 float %18.0g vlR1520201 HIGHEST GRADE COMPLTD (REV) 84 R1890901 float %18.0g vlR1890901 HIGHEST GRADE COMPLTD (REV) 85 R2258001 float %18.0g vlR2258001 HIGHEST GRADE COMPLTD (REV) 86 R2445401 float %18.0g vlR2445401 HIGHEST GRADE COMPLTD (REV) 87 R2871101 float %18.0g vlR2871101 HIGHEST GRADE COMPLTD (REV) 88 R3074801 float %18.0g vlR3074801 HIGHEST GRADE COMPLTD (REV) 89 R3401501 float %18.0g vlR3401501 HIGHEST GRADE COMPLTD (REV) 90 R3656901 float %18.0g vlR3656901 HIGHEST GRADE COMPLTD (REV) 91 R4007401 float %18.0g vlR4007401 HIGHEST GRADE COMPLTD (REV) 92 R4418501 float %18.0g vlR4418501 HIGHEST GRADE COMPLTD (REV) 93 R5103900 float %24.0g vlR5103900 HIGHEST GRADE COMPLTD (REV) 94 R5166901 float %24.0g vlR5166901 HIGHEST GRADE COMPLTD (REV) 96 R6479600 float %24.0g vlR6479600 HIGHEST GRADE COMPLTD (REV) 1998 R7007300 float %24.0g vlR7007300 HIGHEST GRADE COMPLTD (REV) 2000 R7704600 float %24.0g vlR7704600 HIGHEST GRADE COMPLTD (REV) 2002 R8497000 float %24.0g vlR8497000 HIGHEST GRADE COMPLTD (REV) 2004 T0988800 float %24.0g vlT0988800 HIGHEST GRADE COMPLTD (REV) 2006 T2210700 float %24.0g vlT2210700 HIGHEST GRADE COMPLTD (REV) 2008 T3108600 float %24.0g vlT3108600 HIGHEST GRADE COMPLTD (REV) 2010 T4113100 float %24.0g vlT4113100 HIGHEST GRADE COMPLTD (REV) 2012 ---------------------------------------------------------------------------------------------------------------------------------- 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. /* When start/stop=0, then job started in a week prior to 1978 */ > assert `vv' >= 0 if !missing(`vv'); 4. local xx : variable label `vv'; 5. di "`xx'"; 6. local rxx = strreverse("`xx'"); 7. di "`rxx'"; 8. if regexm("`rxx'","^[0-9][0-9] ") {; 9. local temp = substr("`xx'",-2,2); 10. local year = 1900 + `temp'; 11. }; 12. if regexm("`rxx'","^[0-9][0-9][0-9][0-9] ") {; 13. local year = substr("`xx'",-4,4); 14. }; 15. rename `vv' hgc_`year'; 16. la val hgc_`year' vl`vv'; 17. }; R0216701: 4 missing values generated HIGHEST GRADE COMPLTD (REV) 79 97 )VER( DTLPMOC EDARG TSEHGIH R0406401: 311 missing values generated HIGHEST GRADE COMPLTD (REV) 80 08 )VER( DTLPMOC EDARG TSEHGIH R0618901: 278 missing values generated HIGHEST GRADE COMPLTD (REV) 81 18 )VER( DTLPMOC EDARG TSEHGIH R0898201: 336 missing values generated HIGHEST GRADE COMPLTD (REV) 82 28 )VER( DTLPMOC EDARG TSEHGIH R1145001: 278 missing values generated HIGHEST GRADE COMPLTD (REV) 83 38 )VER( DTLPMOC EDARG TSEHGIH R1520201: 362 missing values generated HIGHEST GRADE COMPLTD (REV) 84 48 )VER( DTLPMOC EDARG TSEHGIH R1890901: 1046 missing values generated HIGHEST GRADE COMPLTD (REV) 85 58 )VER( DTLPMOC EDARG TSEHGIH R2258001: 1189 missing values generated HIGHEST GRADE COMPLTD (REV) 86 68 )VER( DTLPMOC EDARG TSEHGIH R2445401: 1310 missing values generated HIGHEST GRADE COMPLTD (REV) 87 78 )VER( DTLPMOC EDARG TSEHGIH R2871101: 1267 missing values generated HIGHEST GRADE COMPLTD (REV) 88 88 )VER( DTLPMOC EDARG TSEHGIH R3074801: 1223 missing values generated HIGHEST GRADE COMPLTD (REV) 89 98 )VER( DTLPMOC EDARG TSEHGIH R3401501: 1309 missing values generated HIGHEST GRADE COMPLTD (REV) 90 09 )VER( DTLPMOC EDARG TSEHGIH R3656901: 1940 missing values generated HIGHEST GRADE COMPLTD (REV) 91 19 )VER( DTLPMOC EDARG TSEHGIH R4007401: 1925 missing values generated HIGHEST GRADE COMPLTD (REV) 92 29 )VER( DTLPMOC EDARG TSEHGIH R4418501: 1939 missing values generated HIGHEST GRADE COMPLTD (REV) 93 39 )VER( DTLPMOC EDARG TSEHGIH R5103900: 1994 missing values generated HIGHEST GRADE COMPLTD (REV) 94 49 )VER( DTLPMOC EDARG TSEHGIH R5166901: 2128 missing values generated HIGHEST GRADE COMPLTD (REV) 96 69 )VER( DTLPMOC EDARG TSEHGIH R6479600: 2303 missing values generated HIGHEST GRADE COMPLTD (REV) 1998 8991 )VER( DTLPMOC EDARG TSEHGIH R7007300: 2483 missing values generated HIGHEST GRADE COMPLTD (REV) 2000 0002 )VER( DTLPMOC EDARG TSEHGIH R7704600: 2634 missing values generated HIGHEST GRADE COMPLTD (REV) 2002 2002 )VER( DTLPMOC EDARG TSEHGIH R8497000: 2726 missing values generated HIGHEST GRADE COMPLTD (REV) 2004 4002 )VER( DTLPMOC EDARG TSEHGIH T0988800: 2665 missing values generated HIGHEST GRADE COMPLTD (REV) 2006 6002 )VER( DTLPMOC EDARG TSEHGIH T2210700: 2621 missing values generated HIGHEST GRADE COMPLTD (REV) 2008 8002 )VER( DTLPMOC EDARG TSEHGIH T3108600: 2734 missing values generated HIGHEST GRADE COMPLTD (REV) 2010 0102 )VER( DTLPMOC EDARG TSEHGIH T4113100: 2879 missing values generated HIGHEST GRADE COMPLTD (REV) 2012 2102 )VER( DTLPMOC EDARG TSEHGIH . reshape long hgc, i(id race sex) j(junk) s; (note: j = _1979 _1980 _1981 _1982 _1983 _1984 _1985 _1986 _1987 _1988 _1989 _1990 _1991 _1992 _1993 _1994 _1996 _1998 _2000 _2002 > _2004 _2006 _2008 _2010 _2012) Data wide -> long ----------------------------------------------------------------------------- Number of obs. 6403 -> 160075 Number of variables 28 -> 5 j variable (25 values) -> junk xij variables: hgc_1979 hgc_1980 ... hgc_2012 -> hgc ----------------------------------------------------------------------------- . gen year = substr(junk,2,4); . destring year, replace; year has all characters numeric; replaced as int . local myvlabel : value label hgc; . di "`myvlabel'"; vlT4113100 . rename hgc hgc_raw; . la var hgc_raw "unedited highest grade completed"; . gen hgc = hgc_raw; (39,884 missing values generated) . di "`myvlabel'"; vlT4113100 . label val hgc `myvlabel'; . xtset id year; panel variable: id (strongly balanced) time variable: year, 1979 to 2012, but with gaps delta: 1 unit . by id: replace hgc = L1.hgc if missing(hgc) & !missing(L1.hgc) & _n != 1 & year <= 1994; (16,689 real changes made) . by id: replace hgc = L2.hgc if missing(hgc) & !missing(L2.hgc) & _n != 1 & year > 1994; (23,173 real changes made) . by id: gen yikes = (hgc < L.hgc) if !missing(hgc) & !missing(L.hgc) & _n!=1 & year <= 1994; (64,052 missing values generated) . by id: replace yikes = 1 if hgc < L2.hgc & !missing(hgc) & !missing(L2.hgc) & _n!=1 & year > 1994; (49 real changes made) . by id: egen bad = max(yikes); . replace hgc = . if bad == 1; (1,575 real changes made, 1,575 to missing) . keep id race sex year hgc hgc_raw; . save `tempdata'`prg'_data, replace; (note: file ../temp/HGCREV_data.dta not found) file ../temp/HGCREV_data.dta saved . end of do-file . do raw2dta_EMPLOYERS_ALL_UNION.do; . /********************************************************************* > Program: raw2dta_EMPLOYERS_ALL_UNION.do > Purpose: refers to variable name in NLSY79 data. > > Date Started: 21 Dec 2015 > Date Revised: 14 Jul 2016 > *********************************************************************/ . #delimit ; delimiter now ; . clear all; . set mo off; . set scheme s1color; . capture log close;