Support #1085

Inapplicable and missing data

Added by Giorgio Piccitto over 5 years ago. Updated over 1 year ago.

Data documentation
Start date:
% Done:



Dear all,
I am working with an appended dataset of the 7 waves, and I noticed something weird.

Some 'basic' variables, such as sex and highest qualification (qfhigh) have too many missing values or 'not applicable'. Also, sometimes in the same pidp the variable sex in with a value in one year and missing in one other year.
Is there any procedure that should be done to report the value of these variables when missing? Why it is so?
Thanks, best, g


Updated by Stephanie Auty over 5 years ago

  • Category set to Data documentation
  • Status changed from New to In Progress
  • Assignee set to Stephanie Auty
  • Target version set to X M
  • % Done changed from 0 to 10

Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.

Best wishes,
Stephanie Auty - Understanding Society User Support Officer


Updated by Stephanie Auty over 5 years ago

  • Private changed from Yes to No

Updated by Stephanie Auty over 5 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Stephanie Auty to Giorgio Piccitto
  • % Done changed from 10 to 70

Dear Giorgio,

Which data files are you working with? I have checked w_sex in w_indresp and this does not seem to have many missing values. It may be inconsistent over time, as this variable is just based on what data is collected and is not edited. We produce a derived variable w_sex_dv, which is consistent over time and which we recommend should be used.

w_qfhigh has a high number of missing values because it is only asked of new entrants. Please use the variable w_qfhigh_dv which incorporates answers to w_qfhigh from previous waves and also new qualifications asked about since the respondent's first interview.

Best wishes,


Updated by Understanding Society User Support Team over 1 year ago

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

Also available in: Atom PDF