Support #2107
open
Query related to Understanding society data (UKHLS)
Added by Saddaf Naaz Akhtar 7 months ago.
Updated 5 months ago.
Description
Dear Madam/Sir,
I hope this mail finds you well.
My name is Dr Saddaf Naaz Akhtar, a research fellow at the University of Southampton. I would like to inform you that I am using the understanding society data. I have two queries are as follow:
1. In the wave 6, the variable "jbpen": (pension-employer runs a pension scheme), the proportion of employer runs a pension scheme is very low compared to the all there wave. In case of trend analysis, there is a striking drop down in the wave 6. Can you please explain why? or any possible reasons. Is there any change in survey design?
2. The variable total earrings "prearn" shows more than 98% inapplicable categories in all the wave. Can you please explain why? And I want to calculate the average earnings annually and average earnings weekly.
Thank you.
Kind regards,
Saddaf
Files
Dear Piotr,
Thank you very much for the quick response.
1. I have added filter with the variable "jbpen": (pension-employer runs a pension scheme).
jbhas==1 (Those who are in paid work last week)
then
jbsemp==1 (Those who are paid in last week and employee)
and then...
jbpen==1
then I am cross tabulating with waves (sorting by ethnicity).
The trend line says that there is a drop in wave 6
Dear Piotr,
I forgot to inform you that I am looking for 45-64 years adults. Please use this filter too.
Thank you.
- Private changed from Yes to No
Dear Saddaf,
Would you be able to share with me your output and the code creating it, please? I want to make sure we are looking at the same results.
Many thanks,
Piotr
UKHLS User Support
- Status changed from New to Feedback
Dear Piotr,
The do file is attached to this mail.
Please find the attachment.
Thank you.
Kind regards,
Saddaf
Dear Saddaf,
I'm not sure which part of your syntax shows the issue, but I think that the last command in the file will not show you the correct results since it includes in the calculation the zeros from the waves in which this question was not asked. I checked the frequencies with your filters on and haven't found a drop in wave 6 (Figs. 2 and 3). You mentioned ethnicity in your post, so I also checked the jbpen distribution, including a breakdown by ethnicity (Fig. 3), and the overall increasing trend still holds. If you need population estimates, you'll need to weight the data in Figure 3, though you need to remember that the sample sizes for some groups with the filters on are tiny and so the point estimates can be inaccurate.
I hope this answers your question.
Best wishes,
Piotr Marzec,
UKHLS User Support
Dear Piotr,
Thank you very much for all your hard work. I have corrected my estimates.
Many thanks.
Kind regards,
Saddaf
- % Done changed from 80 to 90
Dear Saddaf,
Great! I am glad the issue has been resolved and my answer is helpful.
Best wishes,
Piotr
Dear Piotr,
Thank you very much.
Great help.
Kind regards,
Saddaf
- Status changed from Feedback to Resolved
- % Done changed from 90 to 100
Also available in: Atom
PDF
Updated by 
Updated by 
