Support #615

Derived variables

Added by Hannah Fountain over 7 years ago. Updated over 7 years ago.

Data documentation
Start date:
% Done:



Hi. Is there anywhere I can see a list of derived variables and their definitions? I'm search across the site and in the User Manuals but can't seem to find anything. The variable Search function doesn't seem to respond to a search for derived variables, "dv" or anything similar.


dv_search.jpg (120 KB) dv_search.jpg screen print search *_dv Gundi Knies, 08/10/2016 11:52 AM
US screenshots.docx (1.15 MB) US screenshots.docx Hannah Fountain, 08/10/2016 12:17 PM

Updated by Gundi Knies over 7 years ago

  • Category set to Data documentation
  • Status changed from New to Feedback
  • Assignee set to Hannah Fountain
  • Target version set to X M
  • % Done changed from 0 to 90

Hi Hannah,

to find derived variables that end on "dv", try looking for "*_dv", or to find pointers look for "*pno" or "*pid" in the online dataset documentation (i.e., make use of the wild card "*").
As a rule of thumb, derived variables are added last to our data files and they will sit at the bottom in your Stata variable listing. All variables should be documentated in the variable view of the online data set documentation. To find variables that are derived during the interview, you can search the questionnaire for terms such as "compute".

Hope this helps,


Updated by Hannah Fountain over 7 years ago

Thank you for your quick reply.
The tip about the dv files being at the end is useful, thanks, though I was ideally hoping to identify the variables I need before running Stata (being a bit of a novice with that programme and a bit overwhelmed by the number of data points!)

However, I can't get the variable search function to work as you suggest. Using "*_dv", "*dv" or any other combinations returns no results. Even if you use the exact name of the variable, the variable search function frequently returns no results - e.g. "jbstat", "*jbstat", "*_jbstat" all return 0 results. The search function can pick up the questions associated with these variables (and then, if you go through via the question you can follow the link through to the full variable description from the bottom of that page) but it can't seem to find the variable directly, even when using the exact name. It's rather frustrating and makes me wonder if the search function is working correctly?



Updated by Gundi Knies over 7 years ago

Hi Hannah,
searching for *_dv does work fine in my Internet browser, see jpeg attached. I am not sure why it does not work at your end. Which browser are you using?


Updated by Gundi Knies over 7 years ago

  • File deleted (dv_search.dib)

Updated by Hannah Fountain over 7 years ago

Screenshots attached...


Updated by Gundi Knies over 7 years ago

it looks like you included " " in the search term. Have you tried searching for just the following: *_dv


Updated by Hannah Fountain over 7 years ago

You're right... just me being an idiot then. Sorry.
Thanks for your help and patience.



Updated by Victoria Nolan over 7 years ago

  • Status changed from Feedback to Closed
  • % Done changed from 90 to 100
  • Private changed from Yes to No

Also available in: Atom PDF