|
//wave 1 dataset
|
|
use "C:\Users\evieg\OneDrive\Documents\Understranding society analysis\Stata datasets\a_indresp.dta"
|
|
(Substantive data for responding adults (16+), incl. proxies) //open wave 1 dataset
|
|
|
|
rename pidp cwID //Rename variables
|
|
|
|
. rename a_hidp w1hID
|
|
|
|
. rename a_pno w1pno
|
|
|
|
. rename a_hhorig w1horig
|
|
|
|
. rename a_memorig w1indorig
|
|
|
|
. rename a_psu w1psu
|
|
|
|
. rename a_strata w1strata
|
|
|
|
. rename a_sampst w1sampstat
|
|
|
|
. rename a_ivfio w1intcomp
|
|
|
|
. rename a_ioutcome w1intoutcome
|
|
|
|
. rename a_dvage w1age_dv
|
|
|
|
. rename a_ukborn w1ukborn
|
|
|
|
. rename a_racel w1race
|
|
|
|
. rename a_racelo_code w1racecode
|
|
|
|
. rename a_racel_dv w1race_dv
|
|
|
|
. rename a_spaid w1eifather
|
|
|
|
. rename a_smaid w1eimother
|
|
|
|
. drop a_formdif
|
|
|
|
. rename a_oprlg2 w1relattend
|
|
|
|
. rename a_oprlg3 w1relsalience
|
|
|
|
. rename a_resunsafew1_1_3 w1unsafeethn1
|
|
|
|
. rename a_resunsafew1_1_6 w1unsafenat1
|
|
|
|
. rename a_resunsafew1_2_3 w1unsafeethn2
|
|
|
|
. rename a_resunsafew1_2_6 w1unsafenat2
|
|
|
|
. rename a_resunsafew1_3_3 w1unsafethn3
|
|
|
|
. rename a_resunsafew1_3_6 w1unsafenat3
|
|
|
|
. rename a_resunsafew1_4_3 w1unsafeethn4
|
|
|
|
. rename a_resunsafew1_4_6 w1unsafenat4
|
|
|
|
. rename a_resunsafew1_5_3 w1unsafeethn5
|
|
|
|
. rename a_resunsafew1_5_6 w1unsafenat5
|
|
|
|
. rename a_resunsafew1_6_3 w1unsafethn6
|
|
|
|
. rename a_resunsafew1_6_6 w1unsafenat6
|
|
|
|
. rename a_resunsafew1_7_3 w1unsafeethnc7
|
|
|
|
. rename a_resunsafew1_7_6 w1unsafenat7
|
|
|
|
. rename a_resunsafew1_97_3 w1unsafethn8
|
|
|
|
. rename a_resunsafew1_97_6 w1unsafenat8
|
|
|
|
. rename a_resavoidw1_1_3 w1avoidethn1
|
|
|
|
. rename a_resavoidw1_1_6 w1avoidnat1
|
|
|
|
. rename a_resavoidw1_2_3 w1avoidethn2
|
|
|
|
. rename a_resavoidw1_2_6 w1avoidnat2
|
|
|
|
. rename a_resavoidw1_3_3 w1avoidethn3
|
|
|
|
. rename a_resavoidw1_3_6 w1avoidnat3
|
|
|
|
. rename a_resavoidw1_4_3 w1avoidethn4
|
|
|
|
. rename a_resavoidw1_4_6 w1avoidnat4
|
|
|
|
. rename a_resavoidw1_5_3 w1avoidethn5
|
|
|
|
. rename a_resavoidw1_5_6 w1avoidnat5
|
|
|
|
. rename a_resavoidw1_6_3 w1avoidethn6
|
|
|
|
. rename a_resavoidw1_6_6 w1avoidnat6
|
|
|
|
. rename a_resavoidw1_7_3 w1avoidethn7
|
|
|
|
. rename a_resavoidw1_7_6 w1avoidnat7
|
|
|
|
. rename a_resavoidw1_97_3 w1avoidethn8
|
|
|
|
. rename a_resavoidw1_97_6 w1avoidnat8
|
|
|
|
. rename a_resinsultedw1_1_3 w1insultethn1
|
|
|
|
. rename a_resinsultedw1_1_6 w1insultnat1
|
|
|
|
. rename a_resinsultedw1_2_3 w1insultethn2
|
|
|
|
. rename a_resinsultedw1_2_6 w1insultnat2
|
|
|
|
. rename a_resinsultedw1_3_3 w1insultethn3
|
|
|
|
. rename a_resinsultedw1_3_6 w1insultnat3
|
|
|
|
. rename a_resinsultedw1_4_3 w1insultethn4
|
|
|
|
. rename a_resinsultedw1_4_6 w1insultnat4
|
|
|
|
. rename a_resinsultedw1_5_3 w1insultethn5
|
|
|
|
. rename a_resinsultedw1_5_6 w1insultnat5
|
|
|
|
. rename a_resinsultedw1_6_3 w1insultethn6
|
|
|
|
. rename a_resinsultedw1_6_6 w1insultnat6
|
|
|
|
. rename a_resinsultedw1_7_3 w1insultethn7
|
|
|
|
. rename a_resinsultedw1_7_6 w1insultnat7
|
|
|
|
. rename a_resinsultedw1_97_3 w1insultethn8
|
|
|
|
. rename a_resinsultedw1_97_6 w1insultnat8
|
|
|
|
. rename a_resattackedw1_1_3 w1attackethn1
|
|
|
|
. rename a_resattackedw1_1_6 w1attacknat1
|
|
|
|
. rename a_resattackedw1_2_3 w1attackethn2
|
|
|
|
. rename a_resattackedw1_2_6 w1attacknat2
|
|
|
|
. rename a_resattackedw1_3_3 w1attackethn3
|
|
|
|
. rename a_resattackedw1_3_6 w1attacknat3
|
|
|
|
. rename a_resattackedw1_4_3 w1attackethn4
|
|
|
|
. rename a_resattackedw1_4_6 w1attacknat4
|
|
|
|
. rename a_resattackedw1_5_3 w1attackethn5
|
|
|
|
. rename a_resattackedw1_5_6 w1attacknat5
|
|
|
|
. rename a_resattackedw1_6_3 w1attackethn6
|
|
|
|
. rename a_resattackedw1_6_6 w1attacknat6
|
|
|
|
. rename a_resattackedw1_7_3 w1attackethn7
|
|
|
|
. rename a_resattackedw1_7_6 w1attacknat7
|
|
|
|
. rename a_resattackedw1_97_3 w1attackethn8
|
|
|
|
. rename a_resattackedw1_97_6 w1attacknat8
|
|
|
|
. rename a_marstat w1legalmarstat
|
|
|
|
. rename a_fimnlabgrs_dv w1labincome
|
|
|
|
. rename a_sex_dv w1sex_dv
|
|
|
|
. rename a_age_dv w1age_dv
|
|
variable w1age_dv already defined
|
|
r(110);
|
|
|
|
. rename a_age_dv w1age_dv1
|
|
|
|
. rename a_marstat_dv w1marstat_defact_dv
|
|
|
|
. rename a_ethn_dv w1ethnicity_dv
|
|
|
|
. rename a_country w1country
|
|
|
|
. drop a_gor_dv
|
|
|
|
. rename a_urban_dv w1urban_dv
|
|
|
|
. rename a_xtra5min_dv w1xtra5min_dv
|
|
|
|
. drop a_mastat_dv
|
|
|
|
. rename a_qfhigh_dv w1higheq
|
|
|
|
. rename a_jbseg_dv w1SESgroup
|
|
|
|
. rename a_jbnssec8_dv w1NCSEC8
|
|
|
|
. rename a_jbnssec5_dv w1NCSEC5
|
|
|
|
. rename a_jbnssec3_dv w1NCSEC3
|
|
|
|
. rename a_attacked_dv w1attack
|
|
|
|
. rename a_avoided_dv w1avoid
|
|
|
|
. rename a_insulted_dv w1insult
|
|
|
|
. rename a_unsafe_dv w1unsafe
|
|
|
|
drop if a_ethn_dv <= 4 //Remove all non-ethnic minority participants from dataset
|
|
(40,436 observations deleted)
|
|
rop if w1attack == -8.0 & w1insult == -8.0 & w1avoid ==-8.0 & w1unsafe ==-8.0
|
|
(2,970 observations deleted) //Drop observations who have N/A for unsafe, avoid, insult and attack questions
|
|
drop if w1attack == -7.0 & w1insult == -7.0 & w1avoid ==-7.0 & w1unsafe ==-7.0
|
|
(943 observations deleted) //Drop observations who have proxy interview for these questions
|
|
drop if w1attack == -2.0 & w1insult == -2.0 & w1avoid ==-2.0 & w1unsafe ==-2.0
|
|
(7 observations deleted) //Drop observations who have refused to answer these questions
|
|
drop if w1attack == -1.0 & w1insult == -1.0 & w1avoid ==-1.0 & w1unsafe ==-1.0
|
|
(9 observations deleted) //Drop observations who have responded dont know for these questions
|
|
|
|
//Wave 2 datatset
|
|
use "C:\Users\evieg\OneDrive\Documents\Understranding society analysis\Stata datasets\b_indresp.dta"
|
|
(Substantive data for responding adults (16+), incl. proxies) //Open wave 2 dataset
|
|
|
|
rename b_hidp w2HID //Rename variables
|
|
|
|
. rename b_pno w2pno
|
|
|
|
. rename b_hhorig w2horig
|
|
|
|
. rename b_memorig w2indorig
|
|
|
|
. rename b_psu w2psu
|
|
|
|
. rename b_strata w2strata
|
|
|
|
. rename b_sampst w2sampstat
|
|
|
|
. rename b_ivfio w2intcomp
|
|
|
|
. rename b_ioutcome w2intoutcome
|
|
|
|
. rename b_dvage w2age
|
|
|
|
. rename b_newper w2newpp
|
|
|
|
. rename b_ukborn w2ukborn
|
|
|
|
. rename b_racel w2race
|
|
|
|
. rename b_racel_dv w2racedv
|
|
|
|
. rename b_sceverdrnk w2everdrank
|
|
|
|
. rename b_scage1drink w2agedrink
|
|
|
|
. rename b_scfalcdrnk w2drinkfreq12
|
|
|
|
. rename b_scalcl7d w2drankpastweek
|
|
|
|
. rename b_scnalcl7d w2drinkfreqpastweek
|
|
|
|
. rename b_scnalcpint w2maxpints
|
|
|
|
. rename b_scnalcshot w2maxspirits
|
|
|
|
. rename b_scnalcwine w2maxwine
|
|
|
|
. rename b_scnalcpops w2maxalcopop
|
|
|
|
. rename b_fimnlabgrs_dv w2labourincome_monthly_dv
|
|
|
|
. rename b_age_dv w2age_dv
|
|
|
|
. rename b_ethn_dv w2ethnicity_dv
|
|
|
|
. rename b_marstat_dv w2marstat
|
|
|
|
. rename b_country w2country
|
|
|
|
. rename b_urban_dv w2urban
|
|
|
|
. rename b_xtra5min_dv w2xtra5mincross
|
|
|
|
. rename b_xtra5minosm_dv w2extra5minlong
|
|
|
|
. rename b_qfhigh_dv w2higheq
|
|
|
|
. rename b_nqfhigh_dv w2higheqnew
|
|
|
|
. rename b_jbnssec8_dv w2NS_SEC8
|
|
|
|
. rename b_jbnssec5_dv w2NS_SEC5
|
|
|
|
. rename b_jbnssec3_dv w2NS_SEC3
|
|
drop if w2ethnicity_dv <= 4 //Remove all non ethnic minorities
|
|
|
|
//Combined wave 1 and 2 dataset
|
|
merge 1:1 cwID using "C:\Users\evieg\OneDrive\Documents\Understranding society analysis\Stata datasets\Data cle
|
|
> aning - new\Wave 2 EM only.dta" //
|
|
|
|
Result Number of obs
|
|
-----------------------------------------
|
|
Not matched 6,251
|
|
from master 2,115 (_merge==1)
|
|
from using 4,136 (_merge==2)
|
|
|
|
Matched 4,514 (_merge==3) //Merge wave 1 and wave 2 datasets (ethnic minorities only)
|
|
-----------------------------------------
|
|
|
|
. drop if _merge == 2 | _merge == 1 //Drop observations who participated in wave 1 or wave 2 only
|
|
(6,251 observations deleted)
|
|
. drop if w2everdrank == 2 //Remove pp's who said 'no' to ever drinking
|
|
(697 observations deleted)
|
|
|
|
. drop if w2everdrank == -8.0 //Remove pp's who have N.A for ever drinking
|
|
(951 observations deleted)
|
|
|
|
. drop if w2everdrank == -7.0 //Remove pp's who had proxy interview for ever drinking
|
|
(153 observations deleted)
|
|
|
|
|
|
//Accounting for complex survey design
|
|
vyset w1psu [pweight = b_ind5mus_lw], strata(w1strata) singleunit(centered) //Inform stata of survey design
|
|
|
|
Sampling weights: b_ind5mus_lw
|
|
VCE: linearized
|
|
Single unit: centered
|
|
Strata 1: w1strata
|
|
Sampling unit 1: w1psu
|
|
FPC 1: <zero>
|
|
|
|
svy: mean w1age_dv1 //Example of population size issue
|
|
(running mean on estimation sample)
|
|
|
|
Survey: Mean estimation
|
|
|
|
Number of strata = 465 Number of obs = 956
|
|
Number of PSUs = 828 Population size = 123.329484
|
|
Design df = 363
|
|
|
|
--------------------------------------------------------------
|
|
| Linearized
|
|
| Mean std. err. [95% conf. interval]
|
|
-------------+------------------------------------------------
|
|
w1age_dv1 | 36.9141 .6628386 35.61062 38.21759
|
|
--------------------------------------------------------------
|
|
Note: Strata with single sampling unit centered at overall
|