---------------------------------------------------------------------------------------------------------------------------------- name: log: C:\Users\rwr\Dropbox\basu-house\build\code\../temp/raw2dta_C_SAMPWEIGHT.log log type: text opened on: 17 Jul 2016, 12:11:57 . /*****************************************************************************/ > 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" R0216101 "CROSS SECTIONAL SAMPLING WEIGHT 79" R0405201 "CROSS SECTIONAL SAMPLING WEIGHT 80" R0614601 "CROSS SECTIONAL SAMPLING WEIGHT 81" R0896701 "CROSS SECTIONAL SAMPLING WEIGHT 82" R1144401 "CROSS SECTIONAL SAMPLING WEIGHT 83" R1519601 "CROSS SECTIONAL SAMPLING WEIGHT 84" R1890201 "CROSS SECTIONAL SAMPLING WEIGHT 85" R2257301 "CROSS SECTIONAL SAMPLING WEIGHT 86" R2444501 "CROSS SECTIONAL SAMPLING WEIGHT 87" R2870001 "CROSS SECTIONAL SAMPLING WEIGHT 88" R3073801 "CROSS SECTIONAL SAMPLING WEIGHT 89" R3400201 "CROSS SECTIONAL SAMPLING WEIGHT 90" R3655801 "CROSS SECTIONAL SAMPLING WEIGHT 91" R4006301 "CROSS SECTIONAL SAMPLING WEIGHT 92" R4417401 "CROSS SECTIONAL SAMPLING WEIGHT 93" R5080401 "CROSS SECTIONAL SAMPLING WEIGHT 94" R5165701 "CROSS SECTIONAL SAMPLING WEIGHT 96" R6466301 "CROSS SECTIONAL SAMPLING WEIGHT 1998" R7006201 "CROSS SECTIONAL SAMPLING WEIGHT 2000" R7703401 "CROSS SECTIONAL SAMPLING WEIGHT 2002" R8495800 "CROSS SECTIONAL SAMPLING WEIGHT 2004" T0987400 "CROSS SECTIONAL SAMPLING WEIGHT 2006" T2209700 "CROSS SECTIONAL SAMPLING WEIGHT 2008" T3107500 "CROSS SECTIONAL SAMPLING WEIGHT 2010" T4112000 "CROSS SECTIONAL SAMPLING WEIGHT 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 vlR6466301 0 "0" . label values R6466301 vlR6466301 . label define vlR7006201 0 "0" . label values R7006201 vlR7006201 . label define vlR7703401 0 "0" . label values R7703401 vlR7703401 . label define vlR8495800 0 "0" . label values R8495800 vlR8495800 . label define vlT0987400 0 "0" . label values T0987400 vlT0987400 . label define vlT2209700 0 "0" . label values T2209700 vlT2209700 . label define vlT3107500 0 "0" . label values T3107500 vlT3107500 . label define vlT4112000 0 "0" . label values T4112000 vlT4112000 . /* 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 R0216101 C_SAMPWEIGHT_1979 > rename R0405201 C_SAMPWEIGHT_1980 > rename R0614601 C_SAMPWEIGHT_1981 > rename R0896701 C_SAMPWEIGHT_1982 > rename R1144401 C_SAMPWEIGHT_1983 > rename R1519601 C_SAMPWEIGHT_1984 > rename R1890201 C_SAMPWEIGHT_1985 > rename R2257301 C_SAMPWEIGHT_1986 > rename R2444501 C_SAMPWEIGHT_1987 > rename R2870001 C_SAMPWEIGHT_1988 > rename R3073801 C_SAMPWEIGHT_1989 > rename R3400201 C_SAMPWEIGHT_1990 > rename R3655801 C_SAMPWEIGHT_1991 > rename R4006301 C_SAMPWEIGHT_1992 > rename R4417401 C_SAMPWEIGHT_1993 > rename R5080401 C_SAMPWEIGHT_1994 > rename R5165701 C_SAMPWEIGHT_1996 > rename R6466301 C_SAMPWEIGHT_1998 > rename R7006201 C_SAMPWEIGHT_2000 > rename R7703401 C_SAMPWEIGHT_2002 > rename R8495800 C_SAMPWEIGHT_2004 > rename T0987400 C_SAMPWEIGHT_2006 > rename T2209700 C_SAMPWEIGHT_2008 > rename T3107500 C_SAMPWEIGHT_2010 > rename T4112000 C_SAMPWEIGHT_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 R0216101 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 79 R0405201 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 80 R0614601 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 81 R0896701 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 82 R1144401 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 83 R1519601 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 84 R1890201 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 85 R2257301 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 86 R2444501 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 87 R2870001 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 88 R3073801 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 89 R3400201 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 90 R3655801 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 91 R4006301 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 92 R4417401 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 93 R5080401 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 94 R5165701 float %9.0g CROSS SECTIONAL SAMPLING WEIGHT 96 R6466301 float %9.0g vlR6466301 CROSS SECTIONAL SAMPLING WEIGHT 1998 R7006201 float %9.0g vlR7006201 CROSS SECTIONAL SAMPLING WEIGHT 2000 R7703401 float %9.0g vlR7703401 CROSS SECTIONAL SAMPLING WEIGHT 2002 R8495800 float %9.0g vlR8495800 CROSS SECTIONAL SAMPLING WEIGHT 2004 T0987400 float %9.0g vlT0987400 CROSS SECTIONAL SAMPLING WEIGHT 2006 T2209700 float %9.0g vlT2209700 CROSS SECTIONAL SAMPLING WEIGHT 2008 T3107500 float %9.0g vlT3107500 CROSS SECTIONAL SAMPLING WEIGHT 2010 T4112000 float %9.0g vlT4112000 CROSS SECTIONAL SAMPLING WEIGHT 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' csampweight_`year'; 16. la val csampweight_`year' vl`vv'; 17. }; CROSS SECTIONAL SAMPLING WEIGHT 79 97 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 80 08 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 81 18 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 82 28 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 83 38 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 84 48 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 85 58 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 86 68 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 87 78 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 88 88 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 89 98 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 90 09 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 91 19 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 92 29 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 93 39 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 94 49 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 96 69 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 1998 8991 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 2000 0002 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 2002 2002 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 2004 4002 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 2006 6002 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 2008 8002 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 2010 0102 THGIEW GNILPMAS LANOITCES SSORC CROSS SECTIONAL SAMPLING WEIGHT 2012 2102 THGIEW GNILPMAS LANOITCES SSORC . reshape long csampweight, 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: csampweight_1979 csampweight_1980 ... csampweight_2012->csampweight ----------------------------------------------------------------------------- . gen year = substr(junk,2,4); . destring year, replace; year has all characters numeric; replaced as int . /*** there are two implied decimal places according to the documentation ***/ > replace csampweight = csampweight / 100; (60,468 real changes made) . keep id race sex year csampweight; . save `tempdata'`prg'_data, replace; (note: file ../temp/C_SAMPWEIGHT_data.dta not found) file ../temp/C_SAMPWEIGHT_data.dta saved . end of do-file . do raw2dta_DATE_OF_BIRTH.do; . /********************************************************************* > Program: raw2dta_DATE_OF_BIRTH.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;