Project

General

Profile

Support #1233

Commuting to work (jsttwt)

Added by Maddalena Ronchi 11 months ago. Updated 11 months ago.

Status:
Resolved
Priority:
Urgent
Category:
Data inconsistency
Target version:
Start date:
08/28/2019
Due date:
% Done:

100%

Estimated time:

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

History

#1 Updated by Stephanie Auty 11 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

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

#2 Updated by Maddalena Ronchi 11 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?
Thanks!
Maddalena

#3 Updated by Maddalena Ronchi 11 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 11 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?

thanks again,
Maddalena

#5 Updated by Stephanie Auty 11 months ago

  • % 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

#6 Updated by Gundi Knies 11 months ago

  • % Done changed from 70 to 100
  • Status changed from Feedback to Resolved

Also available in: Atom PDF