Support #1807
openhadsymp and longcovid
100%
Description
Hi there,
I am trying to create a variable based on longcovid that matches the number of observations in hadsymp excluding individuals residing in Wales who responded in Welsh.
My understanding is that everyone who reported having symptoms of covid would have answered the longcovid question. However, based on the dictionary, the question is asked "...if previously reported having covid symptoms, and not reported having symptoms in current survey". Are individuals asked this question only once if they reported symptoms in the last survey or are they followed up in every survey? My goal is to create a new variable for longcovid where 0 covers individuals who never reported having covid symptoms and 1 if they report long-term symptoms. I attempted a version below (not excluding Welsh responses yet but I doubt this would account for a substantial number of observations) and would appreciate advice on how to properly do this.
gen covid = .
replace covid = 1 if hadsymp 1
replace covid = 0 if hadsymp 2
tab covid
covid | Freq. Percent Cum.
------------+-----------------------------------
0 | 115,704 94.03 94.03
1 | 7,343 5.97 100.00
------------+-----------------------------------
Total | 123,047 100.00
egen anycovid = max(covid 1), by(pidp)
replace anycovid = . if covid .
tab anycovid
anycovid | Freq. Percent Cum.
------------+-----------------------------------
0 | 89,451 72.70 72.70
1 | 33,596 27.30 100.00
------------+-----------------------------------
Total | 123,047 100.00
*1 is the number of observations that takes the value 1 at least once i.e, the individual reports covid in at least
*one wave
gen longcovid_main = .
replace longcovid_main = 1 if longcovid 1
replace longcovid_main = 0 if longcovid 2
replace longcovid_main = 0 if anycovid == 0
tab longcovid_main
longcovid_m |
ain | Freq. Percent Cum.
------------+-----------------------------------
0 | 90,113 92.34 92.34
1 | 7,474 7.66 100.00
------------+-----------------------------------
Total | 97,587 100.00
Many thanks
Karen
Updated by Understanding Society User Support Team about 2 years ago
- Status changed from New to Feedback
- % Done changed from 0 to 50
- Private changed from Yes to No
Dear Karen,
Please check the questionnaire to know who gets asked this question. Below each question you will see "Universe" which describes who gets asked that question. Please note the Universe may change across waves. If you find that the data does not match the routing/filtering rule please let us know (e.g., if some of the people who should have been a question based on the Universe rule were not asked that question). You can find the quesitonnaires here: https://www.understandingsociety.ac.uk/documentation/covid-19/questionnaires
If you find this problem please also let us know which Wave questionnaire & data you are referring to.
Hope this helps.
Best wishes,
Understanding Society User Support Team
Updated by Understanding Society User Support Team about 1 year ago
- Category set to COVID-19
- Status changed from Feedback to Resolved
- % Done changed from 50 to 100