Project

General

Profile

Support #855

Drinking variables in wave 2, adult self-completion

Added by Min Zhang over 2 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
Category:
Data documentation
Target version:
Start date:
09/22/2017
Due date:
% Done:

100%

Estimated time:

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

History

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

#2 Updated by Stephanie Auty over 2 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

#3 Updated by Stephanie Auty over 2 years ago

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

#4 Updated by Stephanie Auty about 2 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF