---------------------------------------------------------------------------------------------------------------------------------- name: log: C:\Users\rwr\Dropbox\basu-house\build\code\../temp/raw2dta_RNI.log log type: text opened on: 17 Jul 2016, 13:16:19 . /*****************************************************************************/ > 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" R0406310 "REASON FOR NONINT 80" R0618810 "REASON FOR NONINT 81" R0898510 "REASON FOR NONINT 82" R1144710 "REASON FOR NONINT 83" R1519910 "REASON FOR NONINT 84" R1890300 "REASON FOR NONINT 85" R2257400 "REASON FOR NONINT 86" R2444600 "REASON FOR NONINT 87" R2870100 "REASON FOR NONINT 88" R3073900 "REASON FOR NONINT 89" R3400500 "REASON FOR NONINT 90" R3655900 "REASON FOR NONINT 91" R4006400 "REASON FOR NONINT 92" R4417500 "REASONS FOR NON-INT 93" R5080500 "REASONS FOR NON-INT 94" R5165800 "REASONS FOR NON-INT 96" R6478500 "REASONS FOR NON-INT 1998" R7006300 "REASONS FOR NON-INT 2000" R7703500 "REASONS FOR NON-INT 2002" R8495900 "REASONS FOR NON-INT 2004" T0987500 "REASONS FOR NON-INT 2006" T2209800 "REASONS FOR NON-INT 2008" T3107600 "REASONS FOR NON-INT 2010" T4112100 "REASONS FOR NON-INT 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 vlR0406310 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT AND YOUTH REFUSAL/BREAKOFF" 63 > "UNABLE TO LOCATE FAMILY UNIT AND YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" . label values R0406310 vlR0406310 . label define vlR0618810 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT AND YOUTH REFUSAL/BREAKOFF" 63 > "UNABLE TO LOCATE FAMILY UNIT AND YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" . label values R0618810 vlR0618810 . label define vlR0898510 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" . label values R0898510 vlR0898510 . label define vlR1144710 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" . label values R1144710 vlR1144710 . label define vlR1519910 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" . label values R1519910 vlR1519910 . label define vlR1890300 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" 68 "MILITARY SAMPLE DROPPED" . label values R1890300 vlR1890300 . label define vlR2257400 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" 68 "MILITARY SAMPLE DROPPED" . label values R2257400 vlR2257400 . label define vlR2444600 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" 68 "MILITARY SAMPLE DROPPED" . label values R2444600 vlR2444600 . label define vlR2870100 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" 68 "MILITARY SAMPLE DROPPED" . label values R2870100 vlR2870100 . label define vlR3073900 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" 68 "MILITARY SAMPLE DROPPED" . label values R3073900 vlR3073900 . label define vlR3400500 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" 68 "MILITARY SAMPLE DROPPED" . label values R3400500 vlR3400500 . label define vlR3655900 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" 68 "MILITARY SAMPLE DROPPED" 69 "SUPPLEMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "SUPPLEMENTAL FEMALE POOR WHITE SAM > PLE DROPPED" . label values R3655900 vlR3655900 . label define vlR4006400 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" 68 "MILITARY SAMPLE DROPPED" 69 "SUPPLEMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "SUPPLEMENTAL FEMALE POOR WHITE SAM > PLE DROPPED" . label values R4006400 vlR4006400 . label define vlR4417500 60 "PARENT REFUSAL/BREAKOFF" 61 "YOUTH REFUSAL/BREAKOFF" 62 "PARENT & YOUTH REFUSAL/BREAKOFF" 63 "U > NABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "UNABLE TO LOCATE YOUTH" 65 "DECEASED" 66 "OTHER" 67 "DO NOT REFIELD (VERY DIFFICULT > CASES)" 68 "MILITARY SAMPLE DROPPED" 69 "SUPPLEMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "SUPPLEMENTAL FEMALE POOR WHITE SAM > PLE DROPPED" . label values R4417500 vlR4417500 . label define vlR5080500 60 "60: 60 PARENT REFUSAL/BREAKOFF" 61 "61: 61 YOUTH REFUSAL/BREAKOFF" 62 "62: 62 PARENT & YOUTH > REFUSAL/BREAKOFF" 63 "63: 63 UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: 64 UNABLE TO LOCATE YOUTH" 65 "65: 65 DECEASED" > 66 "66: 66 OTHER" 67 "67: 67 DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: 68 MILITARY SAMPLE DROPPED" 69 "69: 69 SUPPL > EMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "70: 70 SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" . label values R5080500 vlR5080500 . label define vlR5165800 60 "60: PARENT REFUSAL/BREAKOFF" 61 "61: YOUTH REFUSAL/BREAKOFF" 62 "62: PARENT & YOUTH REFUSAL/BREA > KOFF" 63 "63: UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: UNABLE TO LOCATE YOUTH" 65 "65: DECEASED" 66 "66: OTHER" 67 "67 > : DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: MILITARY SAMPLE DROPPED" 69 "69: SUPPLEMENTAL MALE POOR WHITE SAMPLE DROPPED" > 70 "70: SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" . label values R5165800 vlR5165800 . label define vlR6478500 60 "60: 60 PARENT REFUSAL/BREAKOFF" 61 "61: 61 YOUTH REFUSAL/BREAKOFF" 62 "62: 62 PARENT & YOUTH > REFUSAL/BREAKOFF" 63 "63: 63 UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: 64 UNABLE TO LOCATE YOUTH" 65 "65: 65 DECEASED" > 66 "66: 66 OTHER" 67 "67: 67 DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: 68 MILITARY SAMPLE DROPPED" 69 "69: 69 SUPPL > EMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "70: 70 SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" . label values R6478500 vlR6478500 . label define vlR7006300 60 "60: PARENT REFUSAL/BREAKOFF" 61 "61: YOUTH REFUSAL/BREAKOFF" 62 "62: PARENT & YOUTH REFUSAL/BREA > KOFF" 63 "63: UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: UNABLE TO LOCATE YOUTH" 65 "65: DECEASED" 66 "66: OTHER" 67 "67 > : DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: MILITARY SAMPLE DROPPED" 69 "69: SUPPLEMENTAL MALE POOR WHITE SAMPLE DROPPED" > 70 "70: SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" 71 "71: YOUTH REFUSAL - VERY DIFFICULT CASE" . label values R7006300 vlR7006300 . label define vlR7703500 60 "60: 60 PARENT REFUSAL/BREAKOFF" 61 "61: 61 YOUTH REFUSAL/BREAKOFF" 62 "62: 62 PARENT & YOUTH > REFUSAL/BREAKOFF" 63 "63: 63 UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: 64 UNABLE TO LOCATE YOUTH" 65 "65: 65 DECEASED" > 66 "66: 66 OTHER" 67 "67: 67 DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: 68 MILITARY SAMPLE DROPPED" 69 "69: 69 SUPPL > EMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "70: 70 SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" 71 "71: 71 YOUTH REFUSAL - > VERY DIFFICULT CASE" 72 "72: 72 NOT FIELDED IN CURRENT SURVEY YEAR - VERY DIFFICULT CASE" . label values R7703500 vlR7703500 . label define vlR8495900 60 "60: 60 PARENT REFUSAL/BREAKOFF" 61 "61: 61 YOUTH REFUSAL/BREAKOFF" 62 "62: 62 PARENT & YOUTH > REFUSAL/BREAKOFF" 63 "63: 63 UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: 64 UNABLE TO LOCATE YOUTH" 65 "65: 65 DECEASED" > 66 "66: 66 OTHER" 67 "67: 67 DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: 68 MILITARY SAMPLE DROPPED" 69 "69: 69 SUPPL > EMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "70: 70 SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" 71 "71: 71 YOUTH REFUSAL - > VERY DIFFICULT CASE" 72 "72: 72 NOT FIELDED IN CURRENT SURVEY YEAR - VERY DIFFICULT CASE" 73 "73: 73 NOT INTERVIEWED - INCA > RCERATED" 74 "74: 74 NOT INTERVIEWED - IN MILITARY" . label values R8495900 vlR8495900 . label define vlT0987500 60 "60: 60 PARENT REFUSAL/BREAKOFF" 61 "61: 61 YOUTH REFUSAL/BREAKOFF" 62 "62: 62 PARENT & YOUTH > REFUSAL/BREAKOFF" 63 "63: 63 UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: 64 UNABLE TO LOCATE YOUTH" 65 "65: 65 DECEASED" > 66 "66: 66 OTHER" 67 "67: 67 DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: 68 MILITARY SAMPLE DROPPED" 69 "69: 69 SUPPL > EMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "70: 70 SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" 71 "71: 71 YOUTH REFUSAL - > VERY DIFFICULT CASE" 72 "72: 72 NOT FIELDED IN CURRENT SURVEY YEAR - VERY DIFFICULT CASE" 73 "73: 73 NOT INTERVIEWED - INCA > RCERATED" 74 "74: 74 NOT INTERVIEWED - IN MILITARY" . label values T0987500 vlT0987500 . label define vlT2209800 60 "60: 60 PARENT REFUSAL/BREAKOFF" 61 "61: 61 YOUTH REFUSAL/BREAKOFF" 62 "62: 62 PARENT & YOUTH > REFUSAL/BREAKOFF" 63 "63: 63 UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: 64 UNABLE TO LOCATE YOUTH" 65 "65: 65 DECEASED" > 66 "66: 66 OTHER" 67 "67: 67 DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: 68 MILITARY SAMPLE DROPPED" 69 "69: 69 SUPPL > EMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "70: 70 SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" 71 "71: 71 YOUTH REFUSAL - > VERY DIFFICULT CASE" 72 "72: 72 NOT FIELDED IN CURRENT SURVEY YEAR - VERY DIFFICULT CASE" 73 "73: 73 NOT INTERVIEWED - INCA > RCERATED" 74 "74: 74 NOT INTERVIEWED - IN MILITARY" . label values T2209800 vlT2209800 . label define vlT3107600 60 "60: 60 PARENT REFUSAL/BREAKOFF" 61 "61: 61 YOUTH REFUSAL/BREAKOFF" 62 "62: 62 PARENT & YOUTH > REFUSAL/BREAKOFF" 63 "63: 63 UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: 64 UNABLE TO LOCATE YOUTH" 65 "65: 65 DECEASED" > 66 "66: 66 OTHER" 67 "67: 67 DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: 68 MILITARY SAMPLE DROPPED" 69 "69: 69 SUPPL > EMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "70: 70 SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" 71 "71: 71 YOUTH REFUSAL - > VERY DIFFICULT CASE" 72 "72: 72 NOT FIELDED IN CURRENT SURVEY YEAR - VERY DIFFICULT CASE" 73 "73: 73 NOT INTERVIEWED - INCA > RCERATED" 74 "74: 74 NOT INTERVIEWED - IN MILITARY" . label values T3107600 vlT3107600 . label define vlT4112100 60 "60: 60 PARENT REFUSAL/BREAKOFF" 61 "61: 61 YOUTH REFUSAL/BREAKOFF" 62 "62: 62 PARENT & YOUTH > REFUSAL/BREAKOFF" 63 "63: 63 UNABLE TO LOCATE FAMILY UNIT & YOUTH" 64 "64: 64 UNABLE TO LOCATE YOUTH" 65 "65: 65 DECEASED" > 66 "66: 66 OTHER" 67 "67: 67 DO NOT REFIELD (VERY DIFFICULT CASE)" 68 "68: 68 MILITARY SAMPLE DROPPED" 69 "69: 69 SUPPL > EMENTAL MALE POOR WHITE SAMPLE DROPPED" 70 "70: 70 SUPPLEMENTAL FEMALE POOR WHITE SAMPLE DROPPED" 71 "71: 71 YOUTH REFUSAL - > VERY DIFFICULT CASE" 72 "72: 72 NOT FIELDED IN CURRENT SURVEY YEAR - VERY DIFFICULT CASE" 73 "73: 73 NOT INTERVIEWED - INCA > RCERATED" 74 "74: 74 NOT INTERVIEWED - IN MILITARY" . label values T4112100 vlT4112100 . /* 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 R0406310 RNI_1980 > rename R0618810 RNI_1981 > rename R0898510 RNI_1982 > rename R1144710 RNI_1983 > rename R1519910 RNI_1984 > rename R1890300 RNI_1985 > rename R2257400 RNI_1986 > rename R2444600 RNI_1987 > rename R2870100 RNI_1988 > rename R3073900 RNI_1989 > rename R3400500 RNI_1990 > rename R3655900 RNI_1991 > rename R4006400 RNI_1992 > rename R4417500 RNI_1993 > rename R5080500 RNI_1994 > rename R5165800 RNI_1996 > rename R6478500 RNI_1998 > rename R7006300 RNI_2000 > rename R7703500 RNI_2002 > rename R8495900 RNI_2004 > rename T0987500 RNI_2006 > rename T2209800 RNI_2008 > rename T3107600 RNI_2010 > rename T4112100 RNI_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; . d, varlist; Contains data obs: 12,686 vars: 27 size: 1,370,088 ---------------------------------------------------------------------------------------------------------------------------------- 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 R0406310 float %38.0g vlR0406310 REASON FOR NONINT 80 R0618810 float %38.0g vlR0618810 REASON FOR NONINT 81 R0898510 float %37.0g vlR0898510 REASON FOR NONINT 82 R1144710 float %37.0g vlR1144710 REASON FOR NONINT 83 R1519910 float %37.0g vlR1519910 REASON FOR NONINT 84 R1890300 float %37.0g vlR1890300 REASON FOR NONINT 85 R2257400 float %37.0g vlR2257400 REASON FOR NONINT 86 R2444600 float %37.0g vlR2444600 REASON FOR NONINT 87 R2870100 float %37.0g vlR2870100 REASON FOR NONINT 88 R3073900 float %37.0g vlR3073900 REASON FOR NONINT 89 R3400500 float %37.0g vlR3400500 REASON FOR NONINT 90 R3655900 float %45.0g vlR3655900 REASON FOR NONINT 91 R4006400 float %45.0g vlR4006400 REASON FOR NONINT 92 R4417500 float %45.0g vlR4417500 REASONS FOR NON-INT 93 R5080500 float %53.0g vlR5080500 REASONS FOR NON-INT 94 R5165800 float %49.0g vlR5165800 REASONS FOR NON-INT 96 R6478500 float %53.0g vlR6478500 REASONS FOR NON-INT 1998 R7006300 float %49.0g vlR7006300 REASONS FOR NON-INT 2000 R7703500 float %64.0g vlR7703500 REASONS FOR NON-INT 2002 R8495900 float %64.0g vlR8495900 REASONS FOR NON-INT 2004 T0987500 float %64.0g vlT0987500 REASONS FOR NON-INT 2006 T2209800 float %64.0g vlT2209800 REASONS FOR NON-INT 2008 T3107600 float %64.0g vlT3107600 REASONS FOR NON-INT 2010 T4112100 float %64.0g vlT4112100 REASONS FOR NON-INT 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' rni_`year'; 16. la val rni_`year' vl`vv'; 17. }; R0406310: 12141 missing values generated REASON FOR NONINT 80 08 TNINON ROF NOSAER R0618810: 12195 missing values generated REASON FOR NONINT 81 18 TNINON ROF NOSAER R0898510: 12123 missing values generated REASON FOR NONINT 82 28 TNINON ROF NOSAER R1144710: 12221 missing values generated REASON FOR NONINT 83 38 TNINON ROF NOSAER R1519910: 12069 missing values generated REASON FOR NONINT 84 48 TNINON ROF NOSAER R1890300: 10894 missing values generated REASON FOR NONINT 85 58 TNINON ROF NOSAER R2257400: 10655 missing values generated REASON FOR NONINT 86 68 TNINON ROF NOSAER R2444600: 10485 missing values generated REASON FOR NONINT 87 78 TNINON ROF NOSAER R2870100: 10465 missing values generated REASON FOR NONINT 88 88 TNINON ROF NOSAER R3073900: 10605 missing values generated REASON FOR NONINT 89 98 TNINON ROF NOSAER R3400500: 10436 missing values generated REASON FOR NONINT 90 09 TNINON ROF NOSAER R3655900: 9018 missing values generated REASON FOR NONINT 91 19 TNINON ROF NOSAER R4006400: 9016 missing values generated REASON FOR NONINT 92 29 TNINON ROF NOSAER R4417500: 9011 missing values generated REASONS FOR NON-INT 93 39 TNI-NON ROF SNOSAER R5080500: 8891 missing values generated REASONS FOR NON-INT 94 49 TNI-NON ROF SNOSAER R5165800: 8636 missing values generated REASONS FOR NON-INT 96 69 TNI-NON ROF SNOSAER R6478500: 8399 missing values generated REASONS FOR NON-INT 1998 8991 TNI-NON ROF SNOSAER R7006300: 8033 missing values generated REASONS FOR NON-INT 2000 0002 TNI-NON ROF SNOSAER R7703500: 7724 missing values generated REASONS FOR NON-INT 2002 2002 TNI-NON ROF SNOSAER R8495900: 7661 missing values generated REASONS FOR NON-INT 2004 4002 TNI-NON ROF SNOSAER T0987500: 7654 missing values generated REASONS FOR NON-INT 2006 6002 TNI-NON ROF SNOSAER T2209800: 7757 missing values generated REASONS FOR NON-INT 2008 8002 TNI-NON ROF SNOSAER T3107600: 7565 missing values generated REASONS FOR NON-INT 2010 0102 TNI-NON ROF SNOSAER T4112100: 7301 missing values generated REASONS FOR NON-INT 2012 2102 TNI-NON ROF SNOSAER . reshape long rni, i(id race sex) j(junk) s; (note: j = _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. 12686 -> 304464 Number of variables 27 -> 5 j variable (24 values) -> junk xij variables: rni_1980 rni_1981 ... rni_2012 -> rni ----------------------------------------------------------------------------- . gen year = substr(junk,2,4); . destring year, replace; year has all characters numeric; replaced as int . gen military_samp_temp = (rni==68) if !missing(rni); (230,955 missing values generated) . by id: egen military_samp = max(military_samp_temp); (120312 missing values generated) . la var military_samp "=1 if military sample"; . gen disadvantaged_samp_temp = (rni==69 | rni==70) if !missing(rni); (230,955 missing values generated) . /* men and women */ > by id: egen disadvantaged_samp = max(disadvantaged_samp_temp); (120312 missing values generated) . unique id if military_samp==1; Number of unique values of id is 1079 Number of records is 25896 . local check = r(sum); . /* See "The NLSY79 Sample: An Introduction" > https://www.nlsinfo.org/content/cohorts/nlsy79/intro-to-the-sample/nlsy79-sample-introduction > */ > assert `check'==1079; . unique id if disadvantaged_samp==1; Number of unique values of id is 1621 Number of records is 38904 . local check = r(sum); . /* See "Important Information" section of "The NLSY79 Sample: An Introduction" about disadvantaged sample > https://www.nlsinfo.org/content/cohorts/nlsy79/intro-to-the-sample/nlsy79-sample-introduction > */ > assert `check'==1621; . /*** only men -- usually up at the top ***/ > keep if sex=="MALE":vlR0214800; (150,792 observations deleted) . keep id race sex year rni military_samp disadvantaged_samp; . save `tempdata'`prg'_data, replace; (note: file ../temp/RNI_data.dta not found) file ../temp/RNI_data.dta saved . end of do-file . do raw2dta_EMPLOYERS_ALL_NUM_ARRAY.do; . /********************************************************************* > Program: raw2dta_EMPLOYERS_ALL_NUM_ARRAY.do > Purpose: refers to variable name in NLSY79 data. > > Date Started: 13 Dec 2015 > Date Revised: 14 Jul 2016 > *********************************************************************/ . #delimit ; delimiter now ; . clear all; . set mo off; . set scheme s1color; . capture log close;