Project

General

Profile

Support #1936

Missing/Inapplicable Data on Physical Activity

Added by Pengyu Li 10 months ago. Updated 6 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
-
Category:
Data documentation
Start date:
07/10/2023
% Done:

100%

Description

Dear Support Team,

Hello! I am currently looking into the data on people's physical activity. I see that in waves 7, 9, 11, and 12, the survey put all kinds of physical activities into three categories, namely walking, moderate, and vigorous activities. Data related to these categories are extremely helpful for my research.

However, a lot of these variables have so many missing/inapplicable data values that they are hardly usable. Some examples of such variables include wwmin, wwhrs, mwhrs, vwhrs, etc.

My questions are: 1) the reason why a majority of data values are missing/inapplicable, given that there is a "Don't know" option for people to choose; 2) do you have any suggestions on alternative variables I can look into on people's physical activities (ideally for more than 1 waves)?

Thank you very much for your help!

#1

Updated by Understanding Society User Support Team 10 months ago

  • Category set to Data documentation
  • Status changed from New to Feedback
  • % Done changed from 0 to 90

Hello,

The high number of missing values on the variables you listed is expected as these were asked only when the corresponding x dhrs and x dmin equaled -1 "don't know" (where x is m or w or v). Take wwhrs as an example, the universe for this variable is:

If (WDAY > 0) // R walked in last 7 days
And If (WDHRS = DK & WDMIN = DK) // Hours and minutes of walking is not known

So, the information on the usual weekly activity comes from a combination of wday, wdhrs and wdmin, and only when both wdhrs and wdmin equal -1, wwhrs is asked and can be used as a proxy.
Furthermore, these questions are part of the International Physical Activity Questionnaire (IPAQ), so you may want to read more about this tool, e.g. here: https://sites.google.com/view/ipaq/home?authuser=0

I hope this helps.

Best wishes,
Piotr Marzec
UKHLS User Support

#2

Updated by Understanding Society User Support Team 10 months ago

  • Private changed from Yes to No
#3

Updated by Pengyu Li 10 months ago

Dear Piotr,

Your answer is incredibly helpful.

Thank you very much for your kind help and support.

Best Wishes,

Pengyu Li

#4

Updated by Understanding Society User Support Team 6 months ago

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

Also available in: Atom PDF