Support #1233
open
Commuting to work (jsttwt)
Added by Maddalena Ronchi over 5 years ago.
Updated over 5 years ago.
Category:
Data inconsistency
Description
Hello,
I want to use the variable jsttwt="minutes spent travelling to work" in the BHPS/UKHLS but I am experiencing some problems. In particular, I find that on average more than 95% of the times the variable is "missing" (i.e. takes values equal to inapplicable, proxy, dont know, etc).
However, if I look at the database and variables description online, the understanding society website reports very different figures! For example, for the last wave of the BHPS online it is reported that the variable is different from missing 46.26% of the times (see: https://www.understandingsociety.ac.uk/documentation/mainstage/dataset-documentation/wave/b18/datafile/br_indresp/variable/br_jbttwt) while in the inderesp_r dta I have downloaded the percentage of nonmissing values is considerably smaller - while the number of observations is the same so I am pretty sure I am looking at the right dta.
Can you please help me clarifying the matter?
Thanks a lot for your support!
Maddalena
- Category set to Data inconsistency
- Status changed from New to Feedback
- Assignee set to Maddalena Ronchi
- Target version set to X M
- % Done changed from 0 to 30
- Private changed from Yes to No
Dear Maddalena,
I have checked several waves of data, including the one you mention here, and I find that the data does match the online documentation. Could you check whether you are using the most recent version of the data, and try redownloading a fresh copy?
Please let us know if this does not resolve the issue.
Best wishes,
Stephanie
Dear Staphanie, I have found the problem: my questions refers to the variable jsttwt, but I have copied for you the link referring to the variable jbttwt, sorry for the confusion!
If I tab the variable jbttwt I do indeed get the right figures. May I just ask what is the difference between the two variables then?
thanks again,
Maddalena
- % Done changed from 30 to 70
Dear Maddalena,
If you are using BHPS and Understanding Society together it is better to use https://beta.ukdataservice.ac.uk/datacatalogue/studies/study?id=6614 as this is the harmonised dataset.
w_jbttwt is the variable which records travel time to work for employed people (w_jbsemp==1), w_jsttwt is whether a self employed person (w_jbsemp==2) has answered a number of minutes or it doesn't apply to them, and w_jsttwtb is the number of minutes of travel time for a self employed person, if that does apply.
Best wishes,
Stephanie
- Status changed from Feedback to Resolved
- % Done changed from 70 to 100
Also available in: Atom
PDF
Updated by Stephanie Auty 
Updated by 
Updated by Gundi Knies