Support #855
closedDrinking variables in wave 2, adult self-completion
100%
Description
Dear USoc team,
I have a question with drinking variables in wave 2, adult self-completion. The variable value labelling seems odd to me.
I expect the variable b_sceverdrnk, ever had an alcoholic drink, to have values as "never had drink" or "had drink before". However, it is how the variable is labelled:
. labelbook b_sceverdrnk ------------------------------------------------------------------------------------------------------------------ value label b_sceverdrnk ------------------------------------------------------------------------------------------------------------------ values labels range: [-9,2] string length: [5,28] N: 7 unique at full length: yes gaps: yes unique at length 12: yes missing .*: 0 null string: no leading/trailing blanks: no numeric -> numeric: no definition -9 missing -8 inapplicable -7 proxy -2 refused -1 don't know 1 age provided 2 never had an alcoholic drink variables: b_sceverdrnk
I ran a cross-tabulation between b_sceverdrnk and b_scfalcdrnk, how often have you had an alcoholic drink. The results also seem odd. I expect that the inapplicable in b_scfalcdrnk could be partially explained by "never had drink" in b_sceverdrnk. But it is not the case.
tab b_sceverdrnk b_scfalcdrnk, m ever had an alcoholic | how often have you had an alcoholic drink during the last 12 months? drink | missing inapplica proxy don't kno almost ev five or s three or once or t once or t once ever once or t not at al not in la | Total ----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------+---------- missing | 8 0 0 217 3,118 2,116 5,673 11,822 6,635 3,975 3,782 1,404 2,804 | 41,554 inapplicable | 0 6,582 0 0 0 0 0 0 0 0 0 0 0 | 6,582 proxy | 0 0 3,882 0 0 0 0 0 0 0 0 0 0 | 3,882 don't know | 392 0 0 0 0 0 0 0 0 0 0 0 0 | 392 age provided | 2,186 0 0 0 0 0 0 0 0 0 0 1 0 | 2,187 ----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------+---------- Total | 2,586 6,582 3,882 217 3,118 2,116 5,673 11,822 6,635 3,975 3,782 1,405 2,804 | 54,597
I understand that the same issue was raised one year ago, https://www.understandingsociety.ac.uk/support/issues/511
But I do not think it has been fixed yet.
Could you please let me know what I can do to get correct records of whether the respondent has ever had alcoholic drink?
Many thanks.
Regards,
Min
Updated by Stephanie Auty about 7 years ago
- Category changed from Derived variables to Data documentation
- Status changed from New to In Progress
- Assignee changed from Gundi Knies to Stephanie Auty
- % Done changed from 0 to 10
- Private changed from Yes to No
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 about 7 years ago
- Status changed from In Progress to Feedback
- Assignee changed from Stephanie Auty to Min Zhang
- % Done changed from 10 to 80
Dear Min,
Thank you, we are aware of this problem and it is on the list of issues to deal with.
For the moment, you can relabel value 1 of b_sceverdrnk as “has never had a drink”. Then, to find the people who say they have had a drink, you need to use at b_age1drink to create a new variable, recoding any value greater than 0 as “has ever has a drink”.
You can see the questions on page 7 on the questionnaire to see how they fit together. Click wave 2 and then download the Adult self-completion pdf: https://www.understandingsociety.ac.uk/documentation/mainstage/questionnaires
Best wishes,
Stephanie Auty - Understanding Society User Support Officer
Updated by Stephanie Auty about 7 years ago
- Status changed from Feedback to Resolved
- % Done changed from 80 to 100
Updated by Stephanie Auty about 7 years ago
- Status changed from Resolved to Closed