Commuting to work (jsttwt)
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!
#1 Updated by Stephanie Auty 9 months ago
- Private changed from Yes to No
- % Done changed from 0 to 30
- Target version set to X M
- Assignee set to Maddalena Ronchi
- Status changed from New to Feedback
- Category set to Data inconsistency
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.
#2 Updated by Maddalena Ronchi 9 months ago
Dear Stephanie, thanks a lot for your quick reply!
I have tried redowloading the data before wirting to the support center and I have dowloaded them from this link: https://beta.ukdataservice.ac.uk/datacatalogue/studies/study?id=5151
Is this correct?
#3 Updated by Maddalena Ronchi 9 months ago
I have also just re-downloaded the following dta: https://beta.ukdataservice.ac.uk/datacatalogue/studies/study?id=6614
If i try to use bhps_w18>br_indresp and then I tab br_jsttwtb I get a value different from (i) inapplicable; (ii) proxy; (iii) don't know onlu slightly less than 4% of the times..
#4 Updated by Maddalena Ronchi 9 months ago
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?
#5 Updated by Stephanie Auty 9 months ago
- % Done changed from 30 to 70
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.