The following STATA chunk imports and describes the sociodemographic NHANES dataset:
import sasxport5 "data/2005-2006/DEMO_D.XPT"
save "temp/2005-2006/DEMO_D.dta",replace
de
clearfile temp/2005-2006/DEMO_D.dta saved
Contains data from temp/2005-2006/DEMO_D.dta
obs: 10,348
vars: 43 6 Aug 2021 15:28
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
sddsrvyr double %10.0g Data Release Number
ridstatr double %10.0g Interview/Examination Status
ridexmon double %10.0g Six month time period
riagendr double %10.0g Gender
ridageyr double %10.0g Age at Screening Adjudicated -
Recode
ridagemn double %10.0g Age in Months - Recode
ridageex double %10.0g Exam Age in Months - Recode
ridreth1 double %10.0g Race/Ethnicity - Recode
dmqmilit double %10.0g Veteran/Military Status
dmdborn double %10.0g Country of Birth - Recode
dmdcitzn double %10.0g Citizenship Status
dmdyrsus double %10.0g Length of time in US
dmdeduc3 double %10.0g Education Level - Children/Youth
6-19
dmdeduc2 double %10.0g Education Level - Adults 20+
dmdschol double %10.0g Now attending school?
dmdmartl double %10.0g Marital Status
dmdhhsiz double %10.0g Total number of people in the
Household
dmdfmsiz double %10.0g Total number of people in the
Family
indhhinc double %10.0g Annual Household Income
indfminc double %10.0g Annual Family Income
indfmpir double %10.0g Family PIR
ridexprg double %10.0g Pregnancy Status at Exam - Recode
dmdhrgnd double %10.0g HH Ref Person Gender
dmdhrage double %10.0g HH Ref Person Age
dmdhrbrn double %10.0g HH Ref Person Country of Birth
dmdhredu double %10.0g HH Ref Person Education Level
dmdhrmar double %10.0g HH Ref Person Marital Status
dmdhsedu double %10.0g HH Ref Person's Spouse Education
Level
sialang double %10.0g Language of SP Interview
siaproxy double %10.0g Proxy used in SP Interview?
siaintrp double %10.0g Interpreter used in SP Interview?
fialang double %10.0g Language of Family Interview
fiaproxy double %10.0g Proxy used in Family Interview?
fiaintrp double %10.0g Interpreter used in Family
Interview?
mialang double %10.0g Language of MEC Interview
miaproxy double %10.0g Proxy used in MEC Interview?
miaintrp double %10.0g Interpreter used in MEC
Interview?
aialang double %10.0g Language of ACASI Interview
wtint2yr double %10.0g Full Sample 2 Year Interview
Weight
wtmec2yr double %10.0g Full Sample 2 Year MEC Exam
Weight
sdmvpsu double %10.0g Masked Variance Pseudo-PSU
sdmvstra double %10.0g Masked Variance Pseudo-Stratum
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2005-2006/DUQ_D.XPT"
keep seqn duq200 duq220q duq220u duq230 duq210
save "temp/2005-2006/DUQ_D.dta",replace
de
clearfile temp/2005-2006/DUQ_D.dta saved
Contains data from temp/2005-2006/DUQ_D.dta
obs: 3,285
vars: 6 6 Aug 2021 15:28
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
duq200 double %10.0g Ever used marijuana or hashish
duq210 double %10.0g Age when first tried marijuana
duq220q double %10.0g Last time used marijuana or
hashish
duq220u double %10.0g Last time used marijuana or
hashish/unit
duq230 double %10.0g # days used marijuana or
hashish/month
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2005-2006/BPX_D.XPT"
keep seqn bpxsy1 bpxsy2 bpxsy3 bpxsy4 bpxdi1 bpxdi2 bpxdi3 bpxdi4
save "temp/2005-2006/BPX_D.dta",replace
de
clearfile temp/2005-2006/BPX_D.dta saved
Contains data from temp/2005-2006/BPX_D.dta
obs: 9,950
vars: 9 6 Aug 2021 15:28
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bpxsy1 double %10.0g Systolic: Blood pres (1st rdg)
mm Hg
bpxdi1 double %10.0g Diastolic: Blood pres (1st rdg)
mm Hg
bpxsy2 double %10.0g Systolic: Blood pres (2nd rdg)
mm Hg
bpxdi2 double %10.0g Diastolic: Blood pres (2nd rdg)
mm Hg
bpxsy3 double %10.0g Systolic: Blood pres (3rd rdg)
mm Hg
bpxdi3 double %10.0g Diastolic: Blood pres (3rd rdg)
mm Hg
bpxsy4 double %10.0g Systolic: Blood pres (4th rdg) mm
Hg
bpxdi4 double %10.0g Diastolic: Blood pres (4th rdg)
mm Hg
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2005-2006/BMX_D.XPT"
keep seqn bmxwt bmxbmi bmxht bmxwaist
save "temp/2005-2006/BMX_D.dta",replace
de
clearfile temp/2005-2006/BMX_D.dta saved
Contains data from temp/2005-2006/BMX_D.dta
obs: 9,950
vars: 5 6 Aug 2021 15:28
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bmxwt double %10.0g Weight (kg)
bmxht double %10.0g Standing Height (cm)
bmxbmi double %10.0g Body Mass Index (kg/m**2)
bmxwaist double %10.0g Waist Circumference (cm)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2005-2006/SMQ_D.XPT"
keep seqn smq020 smq040 smd650
save "temp/2005-2006/SMQ_D.dta",replace
de
clearfile temp/2005-2006/SMQ_D.dta saved
Contains data from temp/2005-2006/SMQ_D.dta
obs: 7,186
vars: 4 6 Aug 2021 15:28
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
smq020 double %10.0g Smoked at least 100 cigarettes in
life
smq040 double %10.0g Do you now smoke cigarettes
smd650 double %10.0g Avg # cigarettes/day during past
30 days
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2005-2006/ALQ_D.XPT"
keep seqn alq101 alq130
save "temp/2005-2006/ALQ_D.dta",replace
de
clearfile temp/2005-2006/ALQ_D.dta saved
Contains data from temp/2005-2006/ALQ_D.dta
obs: 4,773
vars: 3 6 Aug 2021 15:28
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
alq101 double %10.0g Had at least 12 alcohol drinks/1
yr?
alq130 double %10.0g Avg # alcoholic drinks/day -past
12 mos
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2005-2006/DR1TOT_D.XPT"
keep seqn dr1tkcal
save "temp/2005-2006/DR1TOT_D.dta",replace
de
clearfile temp/2005-2006/DR1TOT_D.dta saved
Contains data from temp/2005-2006/DR1TOT_D.dta
obs: 9,950
vars: 2 6 Aug 2021 15:28
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr1tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2005-2006/DR2TOT_D.XPT"
keep seqn dr2tkcal
save "temp/2005-2006/DR2TOT_D.dta",replace
de
clearfile temp/2005-2006/DR2TOT_D.dta saved
Contains data from temp/2005-2006/DR2TOT_D.dta
obs: 9,950
vars: 2 6 Aug 2021 15:28
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr2tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: The following STATA chunk imports and describes the sociodemographic NHANES dataset:
import sasxport5 "data/2007-2008/DEMO_E.XPT"
save "temp/2007-2008/DEMO_E.dta",replace
de
clearfile temp/2007-2008/DEMO_E.dta saved
Contains data from temp/2007-2008/DEMO_E.dta
obs: 10,149
vars: 43 6 Aug 2021 15:28
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
sddsrvyr double %10.0g Data Release Number
ridstatr double %10.0g Interview/Examination Status
ridexmon double %10.0g Six month time period
riagendr double %10.0g Gender
ridageyr double %10.0g Age at Screening Adjudicated -
Recode
ridagemn double %10.0g Age in Months at Screening -
Recode
ridageex double %10.0g Age in Months at Exam - Recode
ridreth1 double %10.0g Race/Ethnicity - Recode
dmqmilit double %10.0g Served in the US Armed Forces
dmdborn2 double %10.0g Country of Birth - Recode
dmdcitzn double %10.0g Citizenship Status
dmdyrsus double %10.0g Length of time in US
dmdeduc3 double %10.0g Education Level - Children/Youth
6-19
dmdeduc2 double %10.0g Education Level - Adults 20+
dmdschol double %10.0g Now attending school?
dmdmartl double %10.0g Marital Status
dmdhhsiz double %10.0g Total number of people in the
Household
dmdfmsiz double %10.0g Total number of people in the
Family
indhhin2 double %10.0g Annual Household Income
indfmin2 double %10.0g Annual Family Income
indfmpir double %10.0g Ratio of family income to poverty
ridexprg double %10.0g Pregnancy Status at Exam - Recode
dmdhrgnd double %10.0g HH Ref Person Gender
dmdhrage double %10.0g HH Ref Person Age
dmdhrbr2 double %10.0g HH Ref Person Country of Birth
dmdhredu double %10.0g HH Ref Person Education Level
dmdhrmar double %10.0g HH Ref Person Marital Status
dmdhsedu double %10.0g HH Ref Person's Spouse Education
Level
sialang double %10.0g Language of SP Interview
siaproxy double %10.0g Proxy used in SP Interview?
siaintrp double %10.0g Interpreter used in SP Interview?
fialang double %10.0g Language of Family Interview
fiaproxy double %10.0g Proxy used in Family Interview?
fiaintrp double %10.0g Interpreter used in Family
Interview?
mialang double %10.0g Language of MEC Interview
miaproxy double %10.0g Proxy used in MEC Interview?
miaintrp double %10.0g Interpreter used in MEC
Interview?
aialang double %10.0g Language of ACASI Interview
wtint2yr double %10.0g Full Sample 2 Year Interview
Weight
wtmec2yr double %10.0g Full Sample 2 Year MEC Exam
Weight
sdmvpsu double %10.0g Masked Variance Pseudo-PSU
sdmvstra double %10.0g Masked Variance Pseudo-Stratum
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2007-2008/DUQ_E.XPT"
keep seqn duq200 duq220q duq220u duq230 duq210
save "temp/2007-2008/DUQ_E.dta",replace
de
clearfile temp/2007-2008/DUQ_E.dta saved
Contains data from temp/2007-2008/DUQ_E.dta
obs: 4,625
vars: 6 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
duq200 double %10.0g Ever used marijuana or hashish
duq210 double %10.0g Age when first tried marijuana
duq220q double %10.0g Last time used marijuana or
hashish
duq220u double %10.0g Last time used marijuana or
hashish/unit
duq230 double %10.0g # days used marijuana or
hashish/month
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2007-2008/BPX_E.XPT"
keep seqn bpxsy1 bpxsy2 bpxsy3 bpxsy4 bpxdi1 bpxdi2 bpxdi3 bpxdi4
save "temp/2007-2008/BPX_E.dta",replace
de
clearfile temp/2007-2008/BPX_E.dta saved
Contains data from temp/2007-2008/BPX_E.dta
obs: 9,762
vars: 9 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bpxsy1 double %10.0g Systolic: Blood pres (1st rdg)
mm Hg
bpxdi1 double %10.0g Diastolic: Blood pres (1st rdg)
mm Hg
bpxsy2 double %10.0g Systolic: Blood pres (2nd rdg)
mm Hg
bpxdi2 double %10.0g Diastolic: Blood pres (2nd rdg)
mm Hg
bpxsy3 double %10.0g Systolic: Blood pres (3rd rdg)
mm Hg
bpxdi3 double %10.0g Diastolic: Blood pres (3rd rdg)
mm Hg
bpxsy4 double %10.0g Systolic: Blood pres (4th rdg) mm
Hg
bpxdi4 double %10.0g Diastolic: Blood pres (4th rdg)
mm Hg
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2007-2008/BMX_E.XPT"
keep seqn bmxwt bmxbmi bmxht bmxwaist
save "temp/2007-2008/BMX_E.dta",replace
de
clearfile temp/2007-2008/BMX_E.dta saved
Contains data from temp/2007-2008/BMX_E.dta
obs: 9,762
vars: 5 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bmxwt double %10.0g Weight (kg)
bmxht double %10.0g Standing Height (cm)
bmxbmi double %10.0g Body Mass Index (kg/m**2)
bmxwaist double %10.0g Waist Circumference (cm)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2007-2008/SMQ_E.XPT"
keep seqn smq020 smq040 smd650
save "temp/2007-2008/SMQ_E.dta",replace
de
clearfile temp/2007-2008/SMQ_E.dta saved
Contains data from temp/2007-2008/SMQ_E.dta
obs: 7,145
vars: 4 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
smq020 double %10.0g Smoked at least 100 cigarettes in
life
smq040 double %10.0g Do you now smoke cigarettes
smd650 double %10.0g Avg # cigarettes/day during past
30 days
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2007-2008/ALQ_E.XPT"
keep seqn alq101 alq130
save "temp/2007-2008/ALQ_E.dta",replace
de
clearfile temp/2007-2008/ALQ_E.dta saved
Contains data from temp/2007-2008/ALQ_E.dta
obs: 5,707
vars: 3 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
alq101 double %10.0g Had at least 12 alcohol drinks/1
yr?
alq130 double %10.0g Avg # alcoholic drinks/day -past
12 mos
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2007-2008/DR1TOT_E.XPT"
keep seqn dr1tkcal
save "temp/2007-2008/DR1TOT_E.dta",replace
de
clearfile temp/2007-2008/DR1TOT_E.dta saved
Contains data from temp/2007-2008/DR1TOT_E.dta
obs: 9,762
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr1tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2007-2008/DR2TOT_E.XPT"
keep seqn dr2tkcal
save "temp/2007-2008/DR2TOT_E.dta",replace
de
clearfile temp/2007-2008/DR2TOT_E.dta saved
Contains data from temp/2007-2008/DR2TOT_E.dta
obs: 9,762
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr2tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: The following STATA chunk imports and describes the sociodemographic NHANES dataset:
import sasxport5 "data/2009-2010/DEMO_F.XPT"
save "temp/2009-2010/DEMO_F.dta",replace
de
clearfile temp/2009-2010/DEMO_F.dta saved
Contains data from temp/2009-2010/DEMO_F.dta
obs: 10,537
vars: 43 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
sddsrvyr double %10.0g Data Release Number
ridstatr double %10.0g Interview/Examination Status
ridexmon double %10.0g Six month time period
riagendr double %10.0g Gender
ridageyr double %10.0g Age at Screening Adjudicated -
Recode
ridagemn double %10.0g Age in Months at Screening -
Recode
ridageex double %10.0g Age in Months at Exam - Recode
ridreth1 double %10.0g Race/Ethnicity - Recode
dmqmilit double %10.0g Served in the US Armed Forces
dmdborn2 double %10.0g Country of Birth - Recode
dmdcitzn double %10.0g Citizenship Status
dmdyrsus double %10.0g Length of time in US
dmdeduc3 double %10.0g Education Level - Children/Youth
6-19
dmdeduc2 double %10.0g Education Level - Adults 20+
dmdschol double %10.0g Now attending school?
dmdmartl double %10.0g Marital Status
dmdhhsiz double %10.0g Total number of people in the
Household
dmdfmsiz double %10.0g Total number of people in the
Family
indhhin2 double %10.0g Annual Household Income
indfmin2 double %10.0g Annual Family Income
indfmpir double %10.0g Ratio of family income to poverty
ridexprg double %10.0g Pregnancy Status at Exam - Recode
dmdhrgnd double %10.0g HH Ref Person Gender
dmdhrage double %10.0g HH Ref Person Age
dmdhrbr2 double %10.0g HH Ref Person Country of Birth
dmdhredu double %10.0g HH Ref Person Education Level
dmdhrmar double %10.0g HH Ref Person Marital Status
dmdhsedu double %10.0g HH Ref Person's Spouse Education
Level
sialang double %10.0g Language of SP Interview
siaproxy double %10.0g Proxy used in SP Interview?
siaintrp double %10.0g Interpreter used in SP Interview?
fialang double %10.0g Language of Family Interview
fiaproxy double %10.0g Proxy used in Family Interview?
fiaintrp double %10.0g Interpreter used in Family
Interview?
mialang double %10.0g Language of MEC Interview
miaproxy double %10.0g Proxy used in MEC Interview?
miaintrp double %10.0g Interpreter used in MEC
Interview?
aialang double %10.0g Language of ACASI Interview
wtint2yr double %10.0g Full Sample 2 Year Interview
Weight
wtmec2yr double %10.0g Full Sample 2 Year MEC Exam
Weight
sdmvpsu double %10.0g Masked Variance Pseudo-PSU
sdmvstra double %10.0g Masked Variance Pseudo-Stratum
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2009-2010/DUQ_F.XPT"
keep seqn duq200 duq220q duq220u duq230 duq210
save "temp/2009-2010/DUQ_F.dta",replace
de
clearfile temp/2009-2010/DUQ_F.dta saved
Contains data from temp/2009-2010/DUQ_F.dta
obs: 5,302
vars: 6 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
duq200 double %10.0g Ever used marijuana or hashish
duq210 double %10.0g Age when first tried marijuana
duq220q double %10.0g Last time used marijuana or
hashish
duq220u double %10.0g Last time used marijuana or
hashish/unit
duq230 double %10.0g # days used marijuana or
hashish/month
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2009-2010/BPX_F.XPT"
keep seqn bpxsy1 bpxsy2 bpxsy3 bpxsy4 bpxdi1 bpxdi2 bpxdi3 bpxdi4
save "temp/2009-2010/BPX_F.dta",replace
de
clearfile temp/2009-2010/BPX_F.dta saved
Contains data from temp/2009-2010/BPX_F.dta
obs: 10,253
vars: 9 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bpxsy1 double %10.0g Systolic: Blood pres (1st rdg) mm
Hg
bpxdi1 double %10.0g Diastolic: Blood pres (1st rdg)
mm Hg
bpxsy2 double %10.0g Systolic: Blood pres (2nd rdg) mm
Hg
bpxdi2 double %10.0g Diastolic: Blood pres (2nd rdg)
mm Hg
bpxsy3 double %10.0g Systolic: Blood pres (3rd rdg) mm
Hg
bpxdi3 double %10.0g Diastolic: Blood pres (3rd rdg)
mm Hg
bpxsy4 double %10.0g Systolic: Blood pres (4th rdg) mm
Hg
bpxdi4 double %10.0g Diastolic: Blood pres (4th rdg)
mm Hg
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2009-2010/BMX_F.XPT"
keep seqn bmxwt bmxbmi bmxht bmxwaist
save "temp/2009-2010/BMX_F.dta",replace
de
clearfile temp/2009-2010/BMX_F.dta saved
Contains data from temp/2009-2010/BMX_F.dta
obs: 10,253
vars: 5 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bmxwt double %10.0g Weight (kg)
bmxht double %10.0g Standing Height (cm)
bmxbmi double %10.0g Body Mass Index (kg/m**2)
bmxwaist double %10.0g Waist Circumference (cm)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2009-2010/SMQ_F.XPT"
keep seqn smq020 smq040 smd650
save "temp/2009-2010/SMQ_F.dta",replace
de
clearfile temp/2009-2010/SMQ_F.dta saved
Contains data from temp/2009-2010/SMQ_F.dta
obs: 7,528
vars: 4 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
smq020 double %10.0g Smoked at least 100 cigarettes in
life
smq040 double %10.0g Do you now smoke cigarettes
smd650 double %10.0g Avg # cigarettes/day during past
30 days
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2009-2010/ALQ_F.XPT"
keep seqn alq101 alq130
save "temp/2009-2010/ALQ_F.dta",replace
de
clearfile temp/2009-2010/ALQ_F.dta saved
Contains data from temp/2009-2010/ALQ_F.dta
obs: 6,059
vars: 3 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
alq101 double %10.0g Had at least 12 alcohol drinks/1
yr?
alq130 double %10.0g Avg # alcoholic drinks/day -past
12 mos
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2009-2010/DR1TOT_F.XPT"
keep seqn dr1tkcal
save "temp/2009-2010/DR1TOT_F.dta",replace
de
clearfile temp/2009-2010/DR1TOT_F.dta saved
Contains data from temp/2009-2010/DR1TOT_F.dta
obs: 10,253
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr1tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2009-2010/DR2TOT_F.XPT"
keep seqn dr2tkcal
save "temp/2009-2010/DR2TOT_F.dta",replace
de
clearfile temp/2009-2010/DR2TOT_F.dta saved
Contains data from temp/2009-2010/DR2TOT_F.dta
obs: 10,253
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr2tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: The following STATA chunk imports and describes the sociodemographic NHANES dataset:
import sasxport5 "data/2011-2012/DEMO_G.XPT"
save "temp/2011-2012/DEMO_G.dta",replace
de
clearfile temp/2011-2012/DEMO_G.dta saved
Contains data from temp/2011-2012/DEMO_G.dta
obs: 9,756
vars: 48 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
sddsrvyr double %10.0g Data release cycle
ridstatr double %10.0g Interview/Examination status
riagendr double %10.0g Gender
ridageyr double %10.0g Age in years at screening
ridagemn double %10.0g Age in months at screening - 0 to
24 mos
ridreth1 double %10.0g Race/Hispanic origin
ridreth3 double %10.0g Race/Hispanic origin w/ NH Asian
ridexmon double %10.0g Six month time period
ridexagy double %10.0g Age in years at exam - 2 to 19
years
ridexagm double %10.0g Age in months at exam - 0 to 19
years
dmqmiliz double %10.0g Served active duty in US Armed
Forces
dmqadfc double %10.0g Served in a foreign country
dmdborn4 double %10.0g Country of birth
dmdcitzn double %10.0g Citizenship status
dmdyrsus double %10.0g Length of time in US
dmdeduc3 double %10.0g Education level - Children/Youth
6-19
dmdeduc2 double %10.0g Education level - Adults 20+
dmdmartl double %10.0g Marital status
ridexprg double %10.0g Pregnancy status at exam
sialang double %10.0g Language of SP Interview
siaproxy double %10.0g Proxy used in SP Interview?
siaintrp double %10.0g Interpreter used in SP Interview?
fialang double %10.0g Language of Family Interview
fiaproxy double %10.0g Proxy used in Family Interview?
fiaintrp double %10.0g Interpreter used in Family
Interview?
mialang double %10.0g Language of MEC Interview
miaproxy double %10.0g Proxy used in MEC Interview?
miaintrp double %10.0g Interpreter used in MEC
Interview?
aialanga double %10.0g Language of ACASI Interview
wtint2yr double %10.0g Full sample 2 year interview
weight
wtmec2yr double %10.0g Full sample 2 year MEC exam
weight
sdmvpsu double %10.0g Masked variance pseudo-PSU
sdmvstra double %10.0g Masked variance pseudo-stratum
indhhin2 double %10.0g Annual household income
indfmin2 double %10.0g Annual family income
indfmpir double %10.0g Ratio of family income to poverty
dmdhhsiz double %10.0g Total number of people in the
Household
dmdfmsiz double %10.0g Total number of people in the
Family
dmdhhsza double %10.0g # of children 5 years or younger
in HH
dmdhhszb double %10.0g # of children 6-17 years old in
HH
dmdhhsze double %10.0g # of adults 60 years or older in
HH
dmdhrgnd double %10.0g HH ref person's gender
dmdhrage double %10.0g HH ref person's age in years
dmdhrbr4 double %10.0g HH ref person's country of birth
dmdhredu double %10.0g HH ref person's education level
dmdhrmar double %10.0g HH ref person's marital status
dmdhsedu double %10.0g HH ref person's spouse's
education level
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2011-2012/DUQ_G.XPT"
keep seqn duq200 duq220q duq220u duq230 duq210
save "temp/2011-2012/DUQ_G.dta",replace
de
clearfile temp/2011-2012/DUQ_G.dta saved
Contains data from temp/2011-2012/DUQ_G.dta
obs: 4,796
vars: 6 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
duq200 double %10.0g Ever used marijuana or hashish
duq210 double %10.0g Age when first tried marijuana
duq220q double %10.0g Last time used marijuana or
hashish
duq220u double %10.0g Last time used marijuana or
hashish/unit
duq230 double %10.0g # days used marijuana or
hashish/month
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2011-2012/BPX_G.XPT"
keep seqn bpxsy1 bpxsy2 bpxsy3 bpxsy4 bpxdi1 bpxdi2 bpxdi3 bpxdi4
save "temp/2011-2012/BPX_G.dta",replace
de
clearfile temp/2011-2012/BPX_G.dta saved
Contains data from temp/2011-2012/BPX_G.dta
obs: 9,338
vars: 9 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bpxsy1 double %10.0g Systolic: Blood pres (1st rdg) mm
Hg
bpxdi1 double %10.0g Diastolic: Blood pres (1st rdg)
mm Hg
bpxsy2 double %10.0g Systolic: Blood pres (2nd rdg) mm
Hg
bpxdi2 double %10.0g Diastolic: Blood pres (2nd rdg)
mm Hg
bpxsy3 double %10.0g Systolic: Blood pres (3rd rdg) mm
Hg
bpxdi3 double %10.0g Diastolic: Blood pres (3rd rdg)
mm Hg
bpxsy4 double %10.0g Systolic: Blood pres (4th rdg) mm
Hg
bpxdi4 double %10.0g Diastolic: Blood pres (4th rdg)
mm Hg
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2011-2012/BMX_G.XPT"
keep seqn bmxwt bmxbmi bmxht bmxwaist
save "temp/2011-2012/BMX_G.dta",replace
de
clearfile temp/2011-2012/BMX_G.dta saved
Contains data from temp/2011-2012/BMX_G.dta
obs: 9,338
vars: 5 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bmxwt double %10.0g Weight (kg)
bmxht double %10.0g Standing Height (cm)
bmxbmi double %10.0g Body Mass Index (kg/m**2)
bmxwaist double %10.0g Waist Circumference (cm)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2011-2012/SMQ_G.XPT"
keep seqn smq020 smq040 smd650
save "temp/2011-2012/SMQ_G.dta",replace
de
clearfile temp/2011-2012/SMQ_G.dta saved
Contains data from temp/2011-2012/SMQ_G.dta
obs: 6,790
vars: 4 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
smq020 double %10.0g Smoked at least 100 cigarettes in
life
smq040 double %10.0g Do you now smoke cigarettes
smd650 double %10.0g Avg # cigarettes/day during past
30 days
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2011-2012/ALQ_G.XPT"
keep seqn alq101 alq130
save "temp/2011-2012/ALQ_G.dta",replace
de
clearfile temp/2011-2012/ALQ_G.dta saved
Contains data from temp/2011-2012/ALQ_G.dta
obs: 5,615
vars: 3 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
alq101 double %10.0g Had at least 12 alcohol drinks/1
yr?
alq130 double %10.0g Avg # alcoholic drinks/day - past
12 mos
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2011-2012/DR1TOT_G.XPT"
keep seqn dr1tkcal
save "temp/2011-2012/DR1TOT_G.dta",replace
de
clearfile temp/2011-2012/DR1TOT_G.dta saved
Contains data from temp/2011-2012/DR1TOT_G.dta
obs: 9,338
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr1tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2011-2012/DR2TOT_G.XPT"
keep seqn dr2tkcal
save "temp/2011-2012/DR2TOT_G.dta",replace
de
clearfile temp/2011-2012/DR2TOT_G.dta saved
Contains data from temp/2011-2012/DR2TOT_G.dta
obs: 9,338
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr2tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: The following STATA chunk imports and describes the sociodemographic NHANES dataset:
import sasxport5 "data/2013-2014/DEMO_H.XPT"
save "temp/2013-2014/DEMO_H.dta",replace
de
clearfile temp/2013-2014/DEMO_H.dta saved
Contains data from temp/2013-2014/DEMO_H.dta
obs: 10,175
vars: 47 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
sddsrvyr double %10.0g Data release cycle
ridstatr double %10.0g Interview/Examination status
riagendr double %10.0g Gender
ridageyr double %10.0g Age in years at screening
ridagemn double %10.0g Age in months at screening - 0 to
24 mos
ridreth1 double %10.0g Race/Hispanic origin
ridreth3 double %10.0g Race/Hispanic origin w/ NH Asian
ridexmon double %10.0g Six month time period
ridexagm double %10.0g Age in months at exam - 0 to 19
years
dmqmiliz double %10.0g Served active duty in US Armed
Forces
dmqadfc double %10.0g Served in a foreign country
dmdborn4 double %10.0g Country of birth
dmdcitzn double %10.0g Citizenship status
dmdyrsus double %10.0g Length of time in US
dmdeduc3 double %10.0g Education level - Children/Youth
6-19
dmdeduc2 double %10.0g Education level - Adults 20+
dmdmartl double %10.0g Marital status
ridexprg double %10.0g Pregnancy status at exam
sialang double %10.0g Language of SP Interview
siaproxy double %10.0g Proxy used in SP Interview?
siaintrp double %10.0g Interpreter used in SP Interview?
fialang double %10.0g Language of Family Interview
fiaproxy double %10.0g Proxy used in Family Interview?
fiaintrp double %10.0g Interpreter used in Family
Interview?
mialang double %10.0g Language of MEC Interview
miaproxy double %10.0g Proxy used in MEC Interview?
miaintrp double %10.0g Interpreter used in MEC
Interview?
aialanga double %10.0g Language of ACASI Interview
dmdhhsiz double %10.0g Total number of people in the
Household
dmdfmsiz double %10.0g Total number of people in the
Family
dmdhhsza double %10.0g # of children 5 years or younger
in HH
dmdhhszb double %10.0g # of children 6-17 years old in
HH
dmdhhsze double %10.0g # of adults 60 years or older in
HH
dmdhrgnd double %10.0g HH ref person's gender
dmdhrage double %10.0g HH ref person's age in years
dmdhrbr4 double %10.0g HH ref person's country of birth
dmdhredu double %10.0g HH ref person's education level
dmdhrmar double %10.0g HH ref person's marital status
dmdhsedu double %10.0g HH ref person's spouse's
education level
wtint2yr double %10.0g Full sample 2 year interview
weight
wtmec2yr double %10.0g Full sample 2 year MEC exam
weight
sdmvpsu double %10.0g Masked variance pseudo-PSU
sdmvstra double %10.0g Masked variance pseudo-stratum
indhhin2 double %10.0g Annual household income
indfmin2 double %10.0g Annual family income
indfmpir double %10.0g Ratio of family income to poverty
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2013-2014/DUQ_H.XPT"
keep seqn duq200 duq220q duq220u duq230 duq210
save "temp/2013-2014/DUQ_H.dta",replace
de
clearfile temp/2013-2014/DUQ_H.dta saved
Contains data from temp/2013-2014/DUQ_H.dta
obs: 5,057
vars: 6 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
duq200 double %10.0g Ever used marijuana or hashish
duq210 double %10.0g Age when first tried marijuana
duq220q double %10.0g Last time used marijuana or
hashish
duq220u double %10.0g Last time used marijuana or
hashish/unit
duq230 double %10.0g # days used marijuana or
hashish/month
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2013-2014/BPX_H.XPT"
keep seqn bpxsy1 bpxsy2 bpxsy3 bpxsy4 bpxdi1 bpxdi2 bpxdi3 bpxdi4
save "temp/2013-2014/BPX_H.dta",replace
de
clearfile temp/2013-2014/BPX_H.dta saved
Contains data from temp/2013-2014/BPX_H.dta
obs: 9,813
vars: 9 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bpxsy1 double %10.0g Systolic: Blood pres (1st rdg) mm
Hg
bpxdi1 double %10.0g Diastolic: Blood pres (1st rdg)
mm Hg
bpxsy2 double %10.0g Systolic: Blood pres (2nd rdg) mm
Hg
bpxdi2 double %10.0g Diastolic: Blood pres (2nd rdg)
mm Hg
bpxsy3 double %10.0g Systolic: Blood pres (3rd rdg) mm
Hg
bpxdi3 double %10.0g Diastolic: Blood pres (3rd rdg)
mm Hg
bpxsy4 double %10.0g Systolic: Blood pres (4th rdg) mm
Hg
bpxdi4 double %10.0g Diastolic: Blood pres (4th rdg)
mm Hg
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2013-2014/BMX_H.XPT"
keep seqn bmxwt bmxbmi bmxht bmxwaist
save "temp/2013-2014/BMX_H.dta",replace
de
clearfile temp/2013-2014/BMX_H.dta saved
Contains data from temp/2013-2014/BMX_H.dta
obs: 9,813
vars: 5 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bmxwt double %10.0g Weight (kg)
bmxht double %10.0g Standing Height (cm)
bmxbmi double %10.0g Body Mass Index (kg/m**2)
bmxwaist double %10.0g Waist Circumference (cm)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2013-2014/SMQ_H.XPT"
keep seqn smq020 smq040 smd650
save "temp/2013-2014/SMQ_H.dta",replace
de
clearfile temp/2013-2014/SMQ_H.dta saved
Contains data from temp/2013-2014/SMQ_H.dta
obs: 7,168
vars: 4 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
smq020 double %10.0g Smoked at least 100 cigarettes in
life
smq040 double %10.0g Do you now smoke cigarettes
smd650 double %10.0g Avg # cigarettes/day during past
30 days
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2013-2014/ALQ_H.XPT"
keep seqn alq101 alq130
save "temp/2013-2014/ALQ_H.dta",replace
de
clearfile temp/2013-2014/ALQ_H.dta saved
Contains data from temp/2013-2014/ALQ_H.dta
obs: 5,924
vars: 3 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
alq101 double %10.0g Had at least 12 alcohol drinks/1
yr?
alq130 double %10.0g Avg # alcoholic drinks/day - past
12 mos
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2013-2014/DR1TOT_H.XPT"
keep seqn dr1tkcal
save "temp/2013-2014/DR1TOT_H.dta",replace
de
clearfile temp/2013-2014/DR1TOT_H.dta saved
Contains data from temp/2013-2014/DR1TOT_H.dta
obs: 9,813
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr1tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2013-2014/DR2TOT_H.XPT"
keep seqn dr2tkcal
save "temp/2013-2014/DR2TOT_H.dta",replace
de
clearfile temp/2013-2014/DR2TOT_H.dta saved
Contains data from temp/2013-2014/DR2TOT_H.dta
obs: 9,813
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr2tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: The following STATA chunk imports and describes the sociodemographic NHANES dataset:
import sasxport5 "data/2015-2016/DEMO_I.XPT"
save "temp/2015-2016/DEMO_I.dta",replace
de
clearfile temp/2015-2016/DEMO_I.dta saved
Contains data from temp/2015-2016/DEMO_I.dta
obs: 9,971
vars: 47 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
sddsrvyr double %10.0g Data release cycle
ridstatr double %10.0g Interview/Examination status
riagendr double %10.0g Gender
ridageyr double %10.0g Age in years at screening
ridagemn double %10.0g Age in months at screening - 0 to
24 mos
ridreth1 double %10.0g Race/Hispanic origin
ridreth3 double %10.0g Race/Hispanic origin w/ NH Asian
ridexmon double %10.0g Six month time period
ridexagm double %10.0g Age in months at exam - 0 to 19
years
dmqmiliz double %10.0g Served active duty in US Armed
Forces
dmqadfc double %10.0g Served in a foreign country
dmdborn4 double %10.0g Country of birth
dmdcitzn double %10.0g Citizenship status
dmdyrsus double %10.0g Length of time in US
dmdeduc3 double %10.0g Education level - Children/Youth
6-19
dmdeduc2 double %10.0g Education level - Adults 20+
dmdmartl double %10.0g Marital status
ridexprg double %10.0g Pregnancy status at exam
sialang double %10.0g Language of SP Interview
siaproxy double %10.0g Proxy used in SP Interview?
siaintrp double %10.0g Interpreter used in SP Interview?
fialang double %10.0g Language of Family Interview
fiaproxy double %10.0g Proxy used in Family Interview?
fiaintrp double %10.0g Interpreter used in Family
Interview?
mialang double %10.0g Language of MEC Interview
miaproxy double %10.0g Proxy used in MEC Interview?
miaintrp double %10.0g Interpreter used in MEC
Interview?
aialanga double %10.0g Language of ACASI Interview
dmdhhsiz double %10.0g Total number of people in the
Household
dmdfmsiz double %10.0g Total number of people in the
Family
dmdhhsza double %10.0g # of children 5 years or younger
in HH
dmdhhszb double %10.0g # of children 6-17 years old in
HH
dmdhhsze double %10.0g # of adults 60 years or older in
HH
dmdhrgnd double %10.0g HH ref person's gender
dmdhrage double %10.0g HH ref person's age in years
dmdhrbr4 double %10.0g HH ref person's country of birth
dmdhredu double %10.0g HH ref person's education level
dmdhrmar double %10.0g HH ref person's marital status
dmdhsedu double %10.0g HH ref person's spouse's
education level
wtint2yr double %10.0g Full sample 2 year interview
weight
wtmec2yr double %10.0g Full sample 2 year MEC exam
weight
sdmvpsu double %10.0g Masked variance pseudo-PSU
sdmvstra double %10.0g Masked variance pseudo-stratum
indhhin2 double %10.0g Annual household income
indfmin2 double %10.0g Annual family income
indfmpir double %10.0g Ratio of family income to poverty
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2015-2016/DUQ_I.XPT"
keep seqn duq200 duq220q duq220u duq230 duq210
save "temp/2015-2016/DUQ_I.dta",replace
de
clearfile temp/2015-2016/DUQ_I.dta saved
Contains data from temp/2015-2016/DUQ_I.dta
obs: 4,843
vars: 6 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
duq200 double %10.0g Ever used marijuana or hashish
duq210 double %10.0g Age when first tried marijuana
duq220q double %10.0g Last time used marijuana or
hashish
duq220u double %10.0g Last time used marijuana or
hashish/unit
duq230 double %10.0g # days used marijuana or
hashish/month
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2015-2016/BPX_I.XPT"
keep seqn bpxsy1 bpxsy2 bpxsy3 bpxsy4 bpxdi1 bpxdi2 bpxdi3 bpxdi4
save "temp/2015-2016/BPX_I.dta",replace
de
clearfile temp/2015-2016/BPX_I.dta saved
Contains data from temp/2015-2016/BPX_I.dta
obs: 9,544
vars: 9 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bpxsy1 double %10.0g Systolic: Blood pres (1st rdg) mm
Hg
bpxdi1 double %10.0g Diastolic: Blood pres (1st rdg)
mm Hg
bpxsy2 double %10.0g Systolic: Blood pres (2nd rdg) mm
Hg
bpxdi2 double %10.0g Diastolic: Blood pres (2nd rdg)
mm Hg
bpxsy3 double %10.0g Systolic: Blood pres (3rd rdg) mm
Hg
bpxdi3 double %10.0g Diastolic: Blood pres (3rd rdg)
mm Hg
bpxsy4 double %10.0g Systolic: Blood pres (4th rdg) mm
Hg
bpxdi4 double %10.0g Diastolic: Blood pres (4th rdg)
mm Hg
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2015-2016/BMX_I.XPT"
keep seqn bmxwt bmxbmi bmxht bmxwaist
save "temp/2015-2016/BMX_I.dta",replace
de
clearfile temp/2015-2016/BMX_I.dta saved
Contains data from temp/2015-2016/BMX_I.dta
obs: 9,544
vars: 5 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bmxwt double %10.0g Weight (kg)
bmxht double %10.0g Standing Height (cm)
bmxbmi double %10.0g Body Mass Index (kg/m**2)
bmxwaist double %10.0g Waist Circumference (cm)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2015-2016/SMQ_I.XPT"
keep seqn smq020 smq040 smd650
save "temp/2015-2016/SMQ_I.dta",replace
de
clearfile temp/2015-2016/SMQ_I.dta saved
Contains data from temp/2015-2016/SMQ_I.dta
obs: 7,001
vars: 4 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
smq020 double %10.0g Smoked at least 100 cigarettes in
life
smq040 double %10.0g Do you now smoke cigarettes?
smd650 double %10.0g Avg # cigarettes/day during past
30 days
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2015-2016/ALQ_I.XPT"
keep seqn alq101 alq130
save "temp/2015-2016/ALQ_I.dta",replace
de
clearfile temp/2015-2016/ALQ_I.dta saved
Contains data from temp/2015-2016/ALQ_I.dta
obs: 5,735
vars: 3 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
alq101 double %10.0g Had at least 12 alcohol drinks/1
yr?
alq130 double %10.0g Avg # alcoholic drinks/day - past
12 mos
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2015-2016/DR1TOT_I.XPT"
keep seqn dr1tkcal
save "temp/2015-2016/DR1TOT_I.dta",replace
de
clearfile temp/2015-2016/DR1TOT_I.dta saved
Contains data from temp/2015-2016/DR1TOT_I.dta
obs: 9,544
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr1tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2015-2016/DR2TOT_I.XPT"
keep seqn dr2tkcal
save "temp/2015-2016/DR2TOT_I.dta",replace
de
clearfile temp/2015-2016/DR2TOT_I.dta saved
Contains data from temp/2015-2016/DR2TOT_I.dta
obs: 9,544
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr2tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: The following STATA chunk imports and describes the sociodemographic NHANES dataset:
import sasxport5 "data/2017-2018/DEMO_J.XPT"
save "temp/2017-2018/DEMO_J.dta",replace
de
clearfile temp/2017-2018/DEMO_J.dta saved
Contains data from temp/2017-2018/DEMO_J.dta
obs: 9,254
vars: 46 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
sddsrvyr double %10.0g Data release cycle
ridstatr double %10.0g Interview/Examination status
riagendr double %10.0g Gender
ridageyr double %10.0g Age in years at screening
ridagemn double %10.0g Age in months at screening - 0 to
24 mos
ridreth1 double %10.0g Race/Hispanic origin
ridreth3 double %10.0g Race/Hispanic origin w/ NH Asian
ridexmon double %10.0g Six month time period
ridexagm double %10.0g Age in months at exam - 0 to 19
years
dmqmiliz double %10.0g Served active duty in US Armed
Forces
dmqadfc double %10.0g Served in a foreign country
dmdborn4 double %10.0g Country of birth
dmdcitzn double %10.0g Citizenship status
dmdyrsus double %10.0g Length of time in US
dmdeduc3 double %10.0g Education level - Children/Youth
6-19
dmdeduc2 double %10.0g Education level - Adults 20+
dmdmartl double %10.0g Marital status
ridexprg double %10.0g Pregnancy status at exam
sialang double %10.0g Language of SP Interview
siaproxy double %10.0g Proxy used in SP Interview?
siaintrp double %10.0g Interpreter used in SP Interview?
fialang double %10.0g Language of Family Interview
fiaproxy double %10.0g Proxy used in Family Interview?
fiaintrp double %10.0g Interpreter used in Family
Interview?
mialang double %10.0g Language of MEC Interview
miaproxy double %10.0g Proxy used in MEC Interview?
miaintrp double %10.0g Interpreter used in MEC
Interview?
aialanga double %10.0g Language of ACASI Interview
dmdhhsiz double %10.0g Total number of people in the
Household
dmdfmsiz double %10.0g Total number of people in the
Family
dmdhhsza double %10.0g # of children 5 years or younger
in HH
dmdhhszb double %10.0g # of children 6-17 years old in
HH
dmdhhsze double %10.0g # of adults 60 years or older in
HH
dmdhrgnd double %10.0g HH ref person's gender
dmdhragz double %10.0g HH ref person's age in years
dmdhredz double %10.0g HH ref person's education level
dmdhrmaz double %10.0g HH ref person's marital status
dmdhsedz double %10.0g HH ref person's spouse's
education level
wtint2yr double %10.0g Full sample 2 year interview
weight
wtmec2yr double %10.0g Full sample 2 year MEC exam
weight
sdmvpsu double %10.0g Masked variance pseudo-PSU
sdmvstra double %10.0g Masked variance pseudo-stratum
indhhin2 double %10.0g Annual household income
indfmin2 double %10.0g Annual family income
indfmpir double %10.0g Ratio of family income to poverty
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2017-2018/DUQ_J.XPT"
keep seqn duq200 duq220q duq220u duq230 duq210
save "temp/2017-2018/DUQ_J.dta",replace
de
clearfile temp/2017-2018/DUQ_J.dta saved
Contains data from temp/2017-2018/DUQ_J.dta
obs: 4,572
vars: 6 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
duq200 double %10.0g Ever used marijuana or hashish
duq210 double %10.0g Age when first tried marijuana
duq220q double %10.0g Last time used marijuana or
hashish
duq220u double %10.0g Last time used marijuana or
hashish/unit
duq230 double %10.0g # days used marijuana or
hashish/month
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2017-2018/BPX_J.XPT"
keep seqn bpxsy1 bpxsy2 bpxsy3 bpxsy4 bpxdi1 bpxdi2 bpxdi3 bpxdi4
save "temp/2017-2018/BPX_J.dta",replace
de
clearfile temp/2017-2018/BPX_J.dta saved
Contains data from temp/2017-2018/BPX_J.dta
obs: 8,704
vars: 9 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bpxsy1 double %10.0g Systolic: Blood pres (1st rdg) mm
Hg
bpxdi1 double %10.0g Diastolic: Blood pres (1st rdg)
mm Hg
bpxsy2 double %10.0g Systolic: Blood pres (2nd rdg) mm
Hg
bpxdi2 double %10.0g Diastolic: Blood pres (2nd rdg)
mm Hg
bpxsy3 double %10.0g Systolic: Blood pres (3rd rdg) mm
Hg
bpxdi3 double %10.0g Diastolic: Blood pres (3rd rdg)
mm Hg
bpxsy4 double %10.0g Systolic: Blood pres (4th rdg) mm
Hg
bpxdi4 double %10.0g Diastolic: Blood pres (4th rdg)
mm Hg
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2017-2018/BMX_J.XPT"
keep seqn bmxwt bmxbmi bmxht bmxwaist
save "temp/2017-2018/BMX_J.dta",replace
de
clearfile temp/2017-2018/BMX_J.dta saved
Contains data from temp/2017-2018/BMX_J.dta
obs: 8,704
vars: 5 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
bmxwt double %10.0g Weight (kg)
bmxht double %10.0g Standing Height (cm)
bmxbmi double %10.0g Body Mass Index (kg/m**2)
bmxwaist double %10.0g Waist Circumference (cm)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2017-2018/SMQ_J.XPT"
keep seqn smq020 smq040 smd650
save "temp/2017-2018/SMQ_J.dta",replace
de
clearfile temp/2017-2018/SMQ_J.dta saved
Contains data from temp/2017-2018/SMQ_J.dta
obs: 6,724
vars: 4 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
smq020 double %10.0g Smoked at least 100 cigarettes in
life
smq040 double %10.0g Do you now smoke cigarettes?
smd650 double %10.0g Avg # cigarettes/day during past
30 days
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2017-2018/ALQ_J.XPT"
keep seqn alq111 alq121 alq130
save "temp/2017-2018/ALQ_J.dta",replace
de
clearfile temp/2017-2018/ALQ_J.dta saved
Contains data from temp/2017-2018/ALQ_J.dta
obs: 5,533
vars: 4 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
alq111 double %10.0g Ever had a drink of any kind of
alcohol
alq121 double %10.0g Past 12 mo how often have alcohol
drink
alq130 double %10.0g Avg # alcohol drinks/day - past
12 mos
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2017-2018/DR1TOT_J.XPT"
keep seqn dr1tkcal
save "temp/2017-2018/DR1TOT_J.dta",replace
de
clearfile temp/2017-2018/DR1TOT_J.dta saved
Contains data from temp/2017-2018/DR1TOT_J.dta
obs: 8,704
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr1tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: import sasxport5 "data/2017-2018/DR2TOT_J.XPT"
keep seqn dr2tkcal
save "temp/2017-2018/DR2TOT_J.dta",replace
de
clearfile temp/2017-2018/DR2TOT_J.dta saved
Contains data from temp/2017-2018/DR2TOT_J.dta
obs: 8,704
vars: 2 6 Aug 2021 15:29
-------------------------------------------------------------------------------
storage display value
variable name type format label variable label
-------------------------------------------------------------------------------
seqn double %10.0g Respondent sequence number
dr2tkcal double %10.0g Energy (kcal)
-------------------------------------------------------------------------------
Sorted by: Starting with the demographics file.
use "temp\2005-2006\DEMO_D.dta", clear
save "data\NHANES0506_merged.dta",replace
merge 1:1 seqn using "temp\2005-2006\BMX_D.dta"
rename _merge Merge_BM
tab Merge_BM
duplicates report seqn
save,replacefile data\NHANES0506_merged.dta saved
Result # of obs.
-----------------------------------------
not matched 398
from master 398 (_merge==1)
from using 0 (_merge==2)
matched 9,950 (_merge==3)
-----------------------------------------
Merge_BM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 398 3.85 3.85
matched (3) | 9,950 96.15 100.00
------------------------+-----------------------------------
Total | 10,348 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10348 0
--------------------------------------
file data\NHANES0506_merged.dta saveduse "data\NHANES0506_merged.dta", clear
merge 1:1 seqn using "temp\2005-2006\ALQ_D.dta"
rename _merge Merge_AL
tab Merge_AL
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 5,575
from master 5,575 (_merge==1)
from using 0 (_merge==2)
matched 4,773 (_merge==3)
-----------------------------------------
Merge_AL | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 5,575 53.88 53.88
matched (3) | 4,773 46.12 100.00
------------------------+-----------------------------------
Total | 10,348 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10348 0
--------------------------------------
file data\NHANES0506_merged.dta saveduse "data\NHANES0506_merged.dta", clear
merge 1:1 seqn using "temp\2005-2006\BPX_D.dta"
rename _merge Merge_BP
tab Merge_BP
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 398
from master 398 (_merge==1)
from using 0 (_merge==2)
matched 9,950 (_merge==3)
-----------------------------------------
Merge_BP | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 398 3.85 3.85
matched (3) | 9,950 96.15 100.00
------------------------+-----------------------------------
Total | 10,348 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10348 0
--------------------------------------
file data\NHANES0506_merged.dta saveduse "data\NHANES0506_merged.dta", clear
merge 1:1 seqn using "temp\2005-2006\DUQ_D.dta"
rename _merge Merge_DU
tab Merge_DU
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 7,063
from master 7,063 (_merge==1)
from using 0 (_merge==2)
matched 3,285 (_merge==3)
-----------------------------------------
Merge_DU | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 7,063 68.25 68.25
matched (3) | 3,285 31.75 100.00
------------------------+-----------------------------------
Total | 10,348 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10348 0
--------------------------------------
file data\NHANES0506_merged.dta saveduse "data\NHANES0506_merged.dta", clear
merge 1:1 seqn using "temp\2005-2006\SMQ_D.dta"
rename _merge Merge_SM
tab Merge_SM
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 3,162
from master 3,162 (_merge==1)
from using 0 (_merge==2)
matched 7,186 (_merge==3)
-----------------------------------------
Merge_SM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 3,162 30.56 30.56
matched (3) | 7,186 69.44 100.00
------------------------+-----------------------------------
Total | 10,348 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10348 0
--------------------------------------
file data\NHANES0506_merged.dta saveduse "data\NHANES0506_merged.dta", clear
merge 1:1 seqn using "temp\2005-2006\DR1TOT_D.dta"
rename _merge Merge_D1
tab Merge_D1
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 398
from master 398 (_merge==1)
from using 0 (_merge==2)
matched 9,950 (_merge==3)
-----------------------------------------
Merge_D1 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 398 3.85 3.85
matched (3) | 9,950 96.15 100.00
------------------------+-----------------------------------
Total | 10,348 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10348 0
--------------------------------------
file data\NHANES0506_merged.dta saveduse "data\NHANES0506_merged.dta", clear
merge 1:1 seqn using "temp\2005-2006\DR2TOT_D.dta"
rename _merge Merge_D2
tab Merge_D2
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 398
from master 398 (_merge==1)
from using 0 (_merge==2)
matched 9,950 (_merge==3)
-----------------------------------------
Merge_D2 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 398 3.85 3.85
matched (3) | 9,950 96.15 100.00
------------------------+-----------------------------------
Total | 10,348 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10348 0
--------------------------------------
file data\NHANES0506_merged.dta savedStarting with the demographics file.
use "temp\2007-2008\DEMO_E.dta", clear
save "data\NHANES0708_merged.dta",replace
merge 1:1 seqn using "temp\2007-2008\BMX_E.dta"
rename _merge Merge_BM
tab Merge_BM
duplicates report seqn
save,replacefile data\NHANES0708_merged.dta saved
Result # of obs.
-----------------------------------------
not matched 387
from master 387 (_merge==1)
from using 0 (_merge==2)
matched 9,762 (_merge==3)
-----------------------------------------
Merge_BM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 387 3.81 3.81
matched (3) | 9,762 96.19 100.00
------------------------+-----------------------------------
Total | 10,149 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10149 0
--------------------------------------
file data\NHANES0708_merged.dta saveduse "data\NHANES0708_merged.dta", clear
merge 1:1 seqn using "temp\2007-2008\ALQ_E.dta"
rename _merge Merge_AL
tab Merge_AL
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 4,442
from master 4,442 (_merge==1)
from using 0 (_merge==2)
matched 5,707 (_merge==3)
-----------------------------------------
Merge_AL | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 4,442 43.77 43.77
matched (3) | 5,707 56.23 100.00
------------------------+-----------------------------------
Total | 10,149 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10149 0
--------------------------------------
file data\NHANES0708_merged.dta saveduse "data\NHANES0708_merged.dta", clear
merge 1:1 seqn using "temp\2007-2008\BPX_E.dta"
rename _merge Merge_BP
tab Merge_BP
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 387
from master 387 (_merge==1)
from using 0 (_merge==2)
matched 9,762 (_merge==3)
-----------------------------------------
Merge_BP | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 387 3.81 3.81
matched (3) | 9,762 96.19 100.00
------------------------+-----------------------------------
Total | 10,149 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10149 0
--------------------------------------
file data\NHANES0708_merged.dta saveduse "data\NHANES0708_merged.dta", clear
merge 1:1 seqn using "temp\2007-2008\DUQ_E.dta"
rename _merge Merge_DU
tab Merge_DU
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 5,524
from master 5,524 (_merge==1)
from using 0 (_merge==2)
matched 4,625 (_merge==3)
-----------------------------------------
Merge_DU | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 5,524 54.43 54.43
matched (3) | 4,625 45.57 100.00
------------------------+-----------------------------------
Total | 10,149 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10149 0
--------------------------------------
file data\NHANES0708_merged.dta saveduse "data\NHANES0708_merged.dta", clear
merge 1:1 seqn using "temp\2007-2008\SMQ_E.dta"
rename _merge Merge_SM
tab Merge_SM
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 3,004
from master 3,004 (_merge==1)
from using 0 (_merge==2)
matched 7,145 (_merge==3)
-----------------------------------------
Merge_SM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 3,004 29.60 29.60
matched (3) | 7,145 70.40 100.00
------------------------+-----------------------------------
Total | 10,149 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10149 0
--------------------------------------
file data\NHANES0708_merged.dta saveduse "data\NHANES0708_merged.dta", clear
merge 1:1 seqn using "temp\2007-2008\DR1TOT_E.dta"
rename _merge Merge_D1
tab Merge_D1
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 387
from master 387 (_merge==1)
from using 0 (_merge==2)
matched 9,762 (_merge==3)
-----------------------------------------
Merge_D1 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 387 3.81 3.81
matched (3) | 9,762 96.19 100.00
------------------------+-----------------------------------
Total | 10,149 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10149 0
--------------------------------------
file data\NHANES0708_merged.dta saveduse "data\NHANES0708_merged.dta", clear
merge 1:1 seqn using "temp\2007-2008\DR2TOT_E.dta"
rename _merge Merge_D2
tab Merge_D2
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 387
from master 387 (_merge==1)
from using 0 (_merge==2)
matched 9,762 (_merge==3)
-----------------------------------------
Merge_D2 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 387 3.81 3.81
matched (3) | 9,762 96.19 100.00
------------------------+-----------------------------------
Total | 10,149 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10149 0
--------------------------------------
file data\NHANES0708_merged.dta savedStarting with the demographics file.
use "temp\2009-2010\DEMO_F.dta", clear
save "data\NHANES0910_merged.dta",replace
merge 1:1 seqn using "temp\2009-2010\BMX_F.dta"
rename _merge Merge_BM
tab Merge_BM
duplicates report seqn
save,replacefile data\NHANES0910_merged.dta saved
Result # of obs.
-----------------------------------------
not matched 284
from master 284 (_merge==1)
from using 0 (_merge==2)
matched 10,253 (_merge==3)
-----------------------------------------
Merge_BM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 284 2.70 2.70
matched (3) | 10,253 97.30 100.00
------------------------+-----------------------------------
Total | 10,537 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10537 0
--------------------------------------
file data\NHANES0910_merged.dta saveduse "data\NHANES0910_merged.dta", clear
merge 1:1 seqn using "temp\2009-2010\ALQ_F.dta"
rename _merge Merge_AL
tab Merge_AL
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 4,478
from master 4,478 (_merge==1)
from using 0 (_merge==2)
matched 6,059 (_merge==3)
-----------------------------------------
Merge_AL | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 4,478 42.50 42.50
matched (3) | 6,059 57.50 100.00
------------------------+-----------------------------------
Total | 10,537 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10537 0
--------------------------------------
file data\NHANES0910_merged.dta saveduse "data\NHANES0910_merged.dta", clear
merge 1:1 seqn using "temp\2009-2010\BPX_F.dta"
rename _merge Merge_BP
tab Merge_BP
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 284
from master 284 (_merge==1)
from using 0 (_merge==2)
matched 10,253 (_merge==3)
-----------------------------------------
Merge_BP | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 284 2.70 2.70
matched (3) | 10,253 97.30 100.00
------------------------+-----------------------------------
Total | 10,537 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10537 0
--------------------------------------
file data\NHANES0910_merged.dta saveduse "data\NHANES0910_merged.dta", clear
merge 1:1 seqn using "temp\2009-2010\DUQ_F.dta"
rename _merge Merge_DU
tab Merge_DU
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 5,235
from master 5,235 (_merge==1)
from using 0 (_merge==2)
matched 5,302 (_merge==3)
-----------------------------------------
Merge_DU | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 5,235 49.68 49.68
matched (3) | 5,302 50.32 100.00
------------------------+-----------------------------------
Total | 10,537 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10537 0
--------------------------------------
file data\NHANES0910_merged.dta saveduse "data\NHANES0910_merged.dta", clear
merge 1:1 seqn using "temp\2009-2010\SMQ_F.dta"
rename _merge Merge_SM
tab Merge_SM
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 3,009
from master 3,009 (_merge==1)
from using 0 (_merge==2)
matched 7,528 (_merge==3)
-----------------------------------------
Merge_SM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 3,009 28.56 28.56
matched (3) | 7,528 71.44 100.00
------------------------+-----------------------------------
Total | 10,537 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10537 0
--------------------------------------
file data\NHANES0910_merged.dta saveduse "data\NHANES0910_merged.dta", clear
merge 1:1 seqn using "temp\2009-2010\DR1TOT_F.dta"
rename _merge Merge_D1
tab Merge_D1
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 284
from master 284 (_merge==1)
from using 0 (_merge==2)
matched 10,253 (_merge==3)
-----------------------------------------
Merge_D1 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 284 2.70 2.70
matched (3) | 10,253 97.30 100.00
------------------------+-----------------------------------
Total | 10,537 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10537 0
--------------------------------------
file data\NHANES0910_merged.dta saveduse "data\NHANES0910_merged.dta", clear
merge 1:1 seqn using "temp\2009-2010\DR2TOT_F.dta"
rename _merge Merge_D2
tab Merge_D2
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 284
from master 284 (_merge==1)
from using 0 (_merge==2)
matched 10,253 (_merge==3)
-----------------------------------------
Merge_D2 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 284 2.70 2.70
matched (3) | 10,253 97.30 100.00
------------------------+-----------------------------------
Total | 10,537 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10537 0
--------------------------------------
file data\NHANES0910_merged.dta savedStarting with the demographics file.
use "temp\2011-2012\DEMO_G.dta", clear
save "data\NHANES1112_merged.dta",replace
merge 1:1 seqn using "temp\2011-2012\BMX_G.dta"
rename _merge Merge_BM
tab Merge_BM
duplicates report seqn
save,replacefile data\NHANES1112_merged.dta saved
Result # of obs.
-----------------------------------------
not matched 418
from master 418 (_merge==1)
from using 0 (_merge==2)
matched 9,338 (_merge==3)
-----------------------------------------
Merge_BM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 418 4.28 4.28
matched (3) | 9,338 95.72 100.00
------------------------+-----------------------------------
Total | 9,756 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9756 0
--------------------------------------
file data\NHANES1112_merged.dta saveduse "data\NHANES1112_merged.dta", clear
merge 1:1 seqn using "temp\2011-2012\ALQ_G.dta"
rename _merge Merge_AL
tab Merge_AL
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 4,141
from master 4,141 (_merge==1)
from using 0 (_merge==2)
matched 5,615 (_merge==3)
-----------------------------------------
Merge_AL | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 4,141 42.45 42.45
matched (3) | 5,615 57.55 100.00
------------------------+-----------------------------------
Total | 9,756 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9756 0
--------------------------------------
file data\NHANES1112_merged.dta saveduse "data\NHANES1112_merged.dta", clear
merge 1:1 seqn using "temp\2011-2012\BPX_G.dta"
rename _merge Merge_BP
tab Merge_BP
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 418
from master 418 (_merge==1)
from using 0 (_merge==2)
matched 9,338 (_merge==3)
-----------------------------------------
Merge_BP | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 418 4.28 4.28
matched (3) | 9,338 95.72 100.00
------------------------+-----------------------------------
Total | 9,756 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9756 0
--------------------------------------
file data\NHANES1112_merged.dta saveduse "data\NHANES1112_merged.dta", clear
merge 1:1 seqn using "temp\2011-2012\DUQ_G.dta"
rename _merge Merge_DU
tab Merge_DU
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 4,960
from master 4,960 (_merge==1)
from using 0 (_merge==2)
matched 4,796 (_merge==3)
-----------------------------------------
Merge_DU | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 4,960 50.84 50.84
matched (3) | 4,796 49.16 100.00
------------------------+-----------------------------------
Total | 9,756 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9756 0
--------------------------------------
file data\NHANES1112_merged.dta saveduse "data\NHANES1112_merged.dta", clear
merge 1:1 seqn using "temp\2011-2012\SMQ_G.dta"
rename _merge Merge_SM
tab Merge_SM
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 2,966
from master 2,966 (_merge==1)
from using 0 (_merge==2)
matched 6,790 (_merge==3)
-----------------------------------------
Merge_SM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 2,966 30.40 30.40
matched (3) | 6,790 69.60 100.00
------------------------+-----------------------------------
Total | 9,756 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9756 0
--------------------------------------
file data\NHANES1112_merged.dta saveduse "data\NHANES1112_merged.dta", clear
merge 1:1 seqn using "temp\2011-2012\DR1TOT_G.dta"
rename _merge Merge_D1
tab Merge_D1
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 418
from master 418 (_merge==1)
from using 0 (_merge==2)
matched 9,338 (_merge==3)
-----------------------------------------
Merge_D1 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 418 4.28 4.28
matched (3) | 9,338 95.72 100.00
------------------------+-----------------------------------
Total | 9,756 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9756 0
--------------------------------------
file data\NHANES1112_merged.dta saveduse "data\NHANES1112_merged.dta", clear
merge 1:1 seqn using "temp\2011-2012\DR2TOT_G.dta"
rename _merge Merge_D2
tab Merge_D2
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 418
from master 418 (_merge==1)
from using 0 (_merge==2)
matched 9,338 (_merge==3)
-----------------------------------------
Merge_D2 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 418 4.28 4.28
matched (3) | 9,338 95.72 100.00
------------------------+-----------------------------------
Total | 9,756 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9756 0
--------------------------------------
file data\NHANES1112_merged.dta savedStarting with the demographics file.
use "temp\2013-2014\DEMO_H.dta", clear
save "data\NHANES1314_merged.dta",replace
merge 1:1 seqn using "temp\2013-2014\BMX_H.dta"
rename _merge Merge_BM
tab Merge_BM
duplicates report seqn
save,replacefile data\NHANES1314_merged.dta saved
Result # of obs.
-----------------------------------------
not matched 362
from master 362 (_merge==1)
from using 0 (_merge==2)
matched 9,813 (_merge==3)
-----------------------------------------
Merge_BM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 362 3.56 3.56
matched (3) | 9,813 96.44 100.00
------------------------+-----------------------------------
Total | 10,175 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10175 0
--------------------------------------
file data\NHANES1314_merged.dta saveduse "data\NHANES1314_merged.dta", clear
merge 1:1 seqn using "temp\2013-2014\ALQ_H.dta"
rename _merge Merge_AL
tab Merge_AL
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 4,251
from master 4,251 (_merge==1)
from using 0 (_merge==2)
matched 5,924 (_merge==3)
-----------------------------------------
Merge_AL | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 4,251 41.78 41.78
matched (3) | 5,924 58.22 100.00
------------------------+-----------------------------------
Total | 10,175 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10175 0
--------------------------------------
file data\NHANES1314_merged.dta saveduse "data\NHANES1314_merged.dta", clear
merge 1:1 seqn using "temp\2013-2014\BPX_H.dta"
rename _merge Merge_BP
tab Merge_BP
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 362
from master 362 (_merge==1)
from using 0 (_merge==2)
matched 9,813 (_merge==3)
-----------------------------------------
Merge_BP | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 362 3.56 3.56
matched (3) | 9,813 96.44 100.00
------------------------+-----------------------------------
Total | 10,175 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10175 0
--------------------------------------
file data\NHANES1314_merged.dta saveduse "data\NHANES1314_merged.dta", clear
merge 1:1 seqn using "temp\2013-2014\DUQ_H.dta"
rename _merge Merge_DU
tab Merge_DU
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 5,118
from master 5,118 (_merge==1)
from using 0 (_merge==2)
matched 5,057 (_merge==3)
-----------------------------------------
Merge_DU | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 5,118 50.30 50.30
matched (3) | 5,057 49.70 100.00
------------------------+-----------------------------------
Total | 10,175 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10175 0
--------------------------------------
file data\NHANES1314_merged.dta saveduse "data\NHANES1314_merged.dta", clear
merge 1:1 seqn using "temp\2013-2014\SMQ_H.dta"
rename _merge Merge_SM
tab Merge_SM
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 3,007
from master 3,007 (_merge==1)
from using 0 (_merge==2)
matched 7,168 (_merge==3)
-----------------------------------------
Merge_SM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 3,007 29.55 29.55
matched (3) | 7,168 70.45 100.00
------------------------+-----------------------------------
Total | 10,175 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10175 0
--------------------------------------
file data\NHANES1314_merged.dta saveduse "data\NHANES1314_merged.dta", clear
merge 1:1 seqn using "temp\2013-2014\DR1TOT_H.dta"
rename _merge Merge_D1
tab Merge_D1
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 362
from master 362 (_merge==1)
from using 0 (_merge==2)
matched 9,813 (_merge==3)
-----------------------------------------
Merge_D1 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 362 3.56 3.56
matched (3) | 9,813 96.44 100.00
------------------------+-----------------------------------
Total | 10,175 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10175 0
--------------------------------------
file data\NHANES1314_merged.dta saveduse "data\NHANES1314_merged.dta", clear
merge 1:1 seqn using "temp\2013-2014\DR2TOT_H.dta"
rename _merge Merge_D2
tab Merge_D2
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 362
from master 362 (_merge==1)
from using 0 (_merge==2)
matched 9,813 (_merge==3)
-----------------------------------------
Merge_D2 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 362 3.56 3.56
matched (3) | 9,813 96.44 100.00
------------------------+-----------------------------------
Total | 10,175 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 10175 0
--------------------------------------
file data\NHANES1314_merged.dta savedStarting with the demographics file.
use "temp\2015-2016\DEMO_I.dta", clear
save "data\NHANES1516_merged.dta",replace
merge 1:1 seqn using "temp\2015-2016\BMX_I.dta"
rename _merge Merge_BM
tab Merge_BM
duplicates report seqn
save,replacefile data\NHANES1516_merged.dta saved
Result # of obs.
-----------------------------------------
not matched 427
from master 427 (_merge==1)
from using 0 (_merge==2)
matched 9,544 (_merge==3)
-----------------------------------------
Merge_BM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 427 4.28 4.28
matched (3) | 9,544 95.72 100.00
------------------------+-----------------------------------
Total | 9,971 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9971 0
--------------------------------------
file data\NHANES1516_merged.dta saveduse "data\NHANES1516_merged.dta", clear
merge 1:1 seqn using "temp\2015-2016\ALQ_I.dta"
rename _merge Merge_AL
tab Merge_AL
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 4,236
from master 4,236 (_merge==1)
from using 0 (_merge==2)
matched 5,735 (_merge==3)
-----------------------------------------
Merge_AL | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 4,236 42.48 42.48
matched (3) | 5,735 57.52 100.00
------------------------+-----------------------------------
Total | 9,971 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9971 0
--------------------------------------
file data\NHANES1516_merged.dta saveduse "data\NHANES1516_merged.dta", clear
merge 1:1 seqn using "temp\2015-2016\BPX_I.dta"
rename _merge Merge_BP
tab Merge_BP
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 427
from master 427 (_merge==1)
from using 0 (_merge==2)
matched 9,544 (_merge==3)
-----------------------------------------
Merge_BP | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 427 4.28 4.28
matched (3) | 9,544 95.72 100.00
------------------------+-----------------------------------
Total | 9,971 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9971 0
--------------------------------------
file data\NHANES1516_merged.dta saveduse "data\NHANES1516_merged.dta", clear
merge 1:1 seqn using "temp\2015-2016\DUQ_I.dta"
rename _merge Merge_DU
tab Merge_DU
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 5,128
from master 5,128 (_merge==1)
from using 0 (_merge==2)
matched 4,843 (_merge==3)
-----------------------------------------
Merge_DU | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 5,128 51.43 51.43
matched (3) | 4,843 48.57 100.00
------------------------+-----------------------------------
Total | 9,971 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9971 0
--------------------------------------
file data\NHANES1516_merged.dta saveduse "data\NHANES1516_merged.dta", clear
merge 1:1 seqn using "temp\2015-2016\SMQ_I.dta"
rename _merge Merge_SM
tab Merge_SM
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 2,970
from master 2,970 (_merge==1)
from using 0 (_merge==2)
matched 7,001 (_merge==3)
-----------------------------------------
Merge_SM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 2,970 29.79 29.79
matched (3) | 7,001 70.21 100.00
------------------------+-----------------------------------
Total | 9,971 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9971 0
--------------------------------------
file data\NHANES1516_merged.dta saveduse "data\NHANES1516_merged.dta", clear
merge 1:1 seqn using "temp\2015-2016\DR1TOT_I.dta"
rename _merge Merge_D1
tab Merge_D1
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 427
from master 427 (_merge==1)
from using 0 (_merge==2)
matched 9,544 (_merge==3)
-----------------------------------------
Merge_D1 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 427 4.28 4.28
matched (3) | 9,544 95.72 100.00
------------------------+-----------------------------------
Total | 9,971 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9971 0
--------------------------------------
file data\NHANES1516_merged.dta saveduse "data\NHANES1516_merged.dta", clear
merge 1:1 seqn using "temp\2015-2016\DR2TOT_I.dta"
rename _merge Merge_D2
tab Merge_D2
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 427
from master 427 (_merge==1)
from using 0 (_merge==2)
matched 9,544 (_merge==3)
-----------------------------------------
Merge_D2 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 427 4.28 4.28
matched (3) | 9,544 95.72 100.00
------------------------+-----------------------------------
Total | 9,971 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9971 0
--------------------------------------
file data\NHANES1516_merged.dta savedStarting with the demographics file, DEMO_J, and merging with the body measures file, BMX_J
use "temp\2017-2018\DEMO_J.dta", clear
save "data\NHANES1718_merged.dta",replace
merge 1:1 seqn using "temp\2017-2018\BMX_J.dta"
rename _merge Merge_BM
tab Merge_BM
duplicates report seqn
save,replacefile data\NHANES1718_merged.dta saved
Result # of obs.
-----------------------------------------
not matched 550
from master 550 (_merge==1)
from using 0 (_merge==2)
matched 8,704 (_merge==3)
-----------------------------------------
Merge_BM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 550 5.94 5.94
matched (3) | 8,704 94.06 100.00
------------------------+-----------------------------------
Total | 9,254 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9254 0
--------------------------------------
file data\NHANES1718_merged.dta saveduse "data\NHANES1718_merged.dta", clear
merge 1:1 seqn using "temp\2017-2018\ALQ_J.dta"
rename _merge Merge_AL
tab Merge_AL
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 3,721
from master 3,721 (_merge==1)
from using 0 (_merge==2)
matched 5,533 (_merge==3)
-----------------------------------------
Merge_AL | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 3,721 40.21 40.21
matched (3) | 5,533 59.79 100.00
------------------------+-----------------------------------
Total | 9,254 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9254 0
--------------------------------------
file data\NHANES1718_merged.dta saveduse "data\NHANES1718_merged.dta", clear
merge 1:1 seqn using "temp\2017-2018\BPX_J.dta"
rename _merge Merge_BP
tab Merge_BP
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 550
from master 550 (_merge==1)
from using 0 (_merge==2)
matched 8,704 (_merge==3)
-----------------------------------------
Merge_BP | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 550 5.94 5.94
matched (3) | 8,704 94.06 100.00
------------------------+-----------------------------------
Total | 9,254 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9254 0
--------------------------------------
file data\NHANES1718_merged.dta saveduse "data\NHANES1718_merged.dta", clear
merge 1:1 seqn using "temp\2017-2018\DUQ_J.dta"
rename _merge Merge_DU
tab Merge_DU
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 4,682
from master 4,682 (_merge==1)
from using 0 (_merge==2)
matched 4,572 (_merge==3)
-----------------------------------------
Merge_DU | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 4,682 50.59 50.59
matched (3) | 4,572 49.41 100.00
------------------------+-----------------------------------
Total | 9,254 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9254 0
--------------------------------------
file data\NHANES1718_merged.dta saveduse "data\NHANES1718_merged.dta", clear
merge 1:1 seqn using "temp\2017-2018\SMQ_J.dta"
rename _merge Merge_SM
tab Merge_SM
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 2,530
from master 2,530 (_merge==1)
from using 0 (_merge==2)
matched 6,724 (_merge==3)
-----------------------------------------
Merge_SM | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 2,530 27.34 27.34
matched (3) | 6,724 72.66 100.00
------------------------+-----------------------------------
Total | 9,254 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9254 0
--------------------------------------
file data\NHANES1718_merged.dta saveduse "data\NHANES1718_merged.dta", clear
merge 1:1 seqn using "temp\2017-2018\DR1TOT_J.dta"
rename _merge Merge_D1
tab Merge_D1
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 550
from master 550 (_merge==1)
from using 0 (_merge==2)
matched 8,704 (_merge==3)
-----------------------------------------
Merge_D1 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 550 5.94 5.94
matched (3) | 8,704 94.06 100.00
------------------------+-----------------------------------
Total | 9,254 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9254 0
--------------------------------------
file data\NHANES1718_merged.dta saveduse "data\NHANES1718_merged.dta", clear
merge 1:1 seqn using "temp\2017-2018\DR2TOT_J.dta"
rename _merge Merge_D2
tab Merge_D2
duplicates report seqn
save,replace Result # of obs.
-----------------------------------------
not matched 550
from master 550 (_merge==1)
from using 0 (_merge==2)
matched 8,704 (_merge==3)
-----------------------------------------
Merge_D2 | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 550 5.94 5.94
matched (3) | 8,704 94.06 100.00
------------------------+-----------------------------------
Total | 9,254 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 9254 0
--------------------------------------
file data\NHANES1718_merged.dta saveduse "data\NHANES0506_merged.dta", clear
save "data\NHANES0518.dta",replace
append using "data\NHANES0708_merged.dta"
append using "data\NHANES0910_merged.dta"
append using "data\NHANES1112_merged.dta"
append using "data\NHANES1314_merged.dta"
append using "data\NHANES1516_merged.dta"
append using "data\NHANES1718_merged.dta"
duplicates report seqn
save,replacefile data\NHANES0518.dta saved
(label _merge already defined)
(label _merge already defined)
(label _merge already defined)
(label _merge already defined)
(label _merge already defined)
(label _merge already defined)
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 70190 0
--------------------------------------
file data\NHANES0518.dta saveduse "data\NHANES0518.dta", clear
merge 1:1 seqn using "data\HEI2015R_00518.dta", keep(match master)
rename _merge Merge_HEI
tab Merge_HEI
duplicates report seqn
save, replace Result # of obs.
-----------------------------------------
not matched 13,023
from master 13,023 (_merge==1)
from using 0 (_merge==2)
matched 57,167 (_merge==3)
-----------------------------------------
Merge_HEI | Freq. Percent Cum.
------------------------+-----------------------------------
master only (1) | 13,023 18.55 18.55
matched (3) | 57,167 81.45 100.00
------------------------+-----------------------------------
Total | 70,190 100.00
Duplicates in terms of seqn
--------------------------------------
copies | observations surplus
----------+---------------------------
1 | 70190 0
--------------------------------------
file data\NHANES0518.dta saved