Support #843: w_englang is not part of xwavedat, but available for wave a, e, f - Understanding Society User Support

Custom queries

userforum_asset
userforum_debt
userforum_finance
userforum_wealth

Actions

Copy link

Support #843

closed

w_englang is not part of xwavedat, but available for wave a, e, f

Added by Nico Ochmann over 7 years ago. Updated over 1 year ago.

Status:

Closed

Priority:

Normal

Assignee:

Nico Ochmann

Category:

Data management

Start date:

08/26/2017

% Done:

100%

Description

Dear Alita,

if I understand the variable description correctly, englang is unfortunately not part of xwavedat. Whether English is first language is asked both immigrants and natives in wave one, and the IEMB in wave 6.
For wave 5, the englang variable appears as well. I want to use all six waves in USoc, for the years 2009-2015. For that purpose, I need to impute the information I have on englang to the missing waves/years.
So far, I have used the information from all three waves and generated a new variable englang_dv which I then merged m:1 pidp with the rest of the data set.
In broad terms, am I doing this correctly?
Thanks a lot!
Best wishes.

Nico

History
Notes
Property changes

Actions

Copy link

Updated by Alita Nandi over 7 years ago

Status changed from New to In Progress
Assignee changed from Alita Nandi to Nico Ochmann
% Done changed from 0 to 90

Hello Nico,

This was asked:
In Wave 1 - Everyone
In Wave 5 - Only those in the EMBoost, GP Comparison or LDA sample, or a recent immigrant, who did not have a valid response for this variable
In Wave 6 - IEMBS members only.

I am assuming you are doing the following, in which case it is correct:

use pidp a_englang using a_indresp, clear
merge 1:1 pidp using e_indresp,keepus(e_englang) nogen
merge 1:1 pidp using f_indresp,keepus(f_englang) nogen

generat emglang_dv=-9
replace emglang_dv=a_englang if a_englang>0 & a_englang<.
replace emglang_dv=a_englang if e_englang>0 & e_englang<. & (englang_dv==.|englangv<0)
replace emglang_dv=f_englang if f_englang>0 & f_englang<. & (englang_dv==.|englang_dv<0)

keep pidp englang_dv
merge 1:m pidp using indresp_long

Best wishes,
Altia

Actions

Copy link

Updated by Alita Nandi over 7 years ago

Private changed from Yes to No

Actions

Copy link

Updated by Nico Ochmann over 7 years ago

Dear Alita,

thank you very much for your reply.
In order to learn, I would like to share with you how I have done it.
The devil lies in the detail as usual, so I do not think our two codes match 1:1. I still would love to hear your opinion on the following:

foreach w in a e f {
use pidp `w'_englang using "$Stata11_se/`w'_indresp_protect",clear
mvdecode _all, mv(-1 -2 -10 -11 -20)
save $Mergeddata_master2016/`w', replace
}

use $Mergeddata_master2016/a, clear
foreach w in e f {
merge 1:1 pidp using $Mergeddata_master2016/`w'
drop _merge
}
generate englang_dv=-9
foreach w in a e f {
replace englang_dv=`w'_englang if `w'_englang>-7 & `w'_englang<. & englang_dv==-9
}

merge 1:m pidp using $Mergeddata_master2016/englang_dv, force generate(_wemerge_9)

**later on I try to impute by making every UK born person a native speaker

gen adjustlang = englang_dv
replace adjustlang = 1 if adjustlang==-9 & ukb==1 // where ukb ==1 if ukborn

As usual, short comments from you are very welcome.

Thanks.

Nico

Actions

Copy link

Updated by Stephanie Auty over 7 years ago

Status changed from In Progress to Feedback

Dear Nico,

We have noticed a couple of typos in the syntax above. The second section of the code should have been:
generate englang_dv=-9
replace englang_dv=a_englang if a_englang>0 & a_englang<.
replace englang_dv=e_englang if e_englang>0 & e_englang<. & (englang_dv==. | englang_dv<0)
replace englang_dv=f_englang if f_englang>0 & f_englang<. & (englang_dv==. | englang_dv<0)

However, our remit at the User Forum is to answer queries related to Understanding Society data and provide general advice about how to manage the data. Given the number of users we have I'm afraid we cannot advise on individual users' analysis syntax specifically. If you can validate the syntax yourself then using loops will mean it is more expandable in the future.

Whether you decide to impute by making every UK born person a native speaker will depend on your research question and whether this imputation is valid for your analysis and research purposes. For example, a person could be born here but brought up with parents speaking another language so they may not have learned much English until they started nursery or school.

Best wishes,
Stephanie Auty - Understanding Society User Support Officer

Actions

Copy link