Support #2107: Query related to Understanding society data (UKHLS) - Understanding Society User Support

Actions

Copy link

Support #2107

open

Query related to Understanding society data (UKHLS)

Added by Saddaf Naaz Akhtar 7 months ago. Updated 5 months ago.

Status:

Resolved

Priority:

Normal

Assignee:

Understanding Society User Support Team

Category:

Data analysis

Start date:

05/16/2024

% Done:

100%

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

Download all files

jbpen_forum.do (1011 Bytes) jbpen_forum.do		Understanding Society User Support Team, 05/16/2024 04:41 PM
Employer runs a pension scheme by wave.png (51.3 KB) Employer runs a pension scheme by wave.png		Understanding Society User Support Team, 05/16/2024 04:41 PM
wave 6 query.do (1.24 KB) wave 6 query.do		Saddaf Naaz Akhtar, 05/17/2024 02:24 PM
fig 1. jbpen by wave_filtered sample_unweighted.png (57.1 KB) fig 1. jbpen by wave_filtered sample_unweighted.png		Understanding Society User Support Team, 05/23/2024 11:46 AM
fig 2. jbpen by wave_filtered sample_weighted.png (57.8 KB) fig 2. jbpen by wave_filtered sample_weighted.png		Understanding Society User Support Team, 05/23/2024 11:46 AM
fig 3. jbpen by wave&ethnicity_filtered sample_unweighted.png (101 KB) fig 3. jbpen by wave&ethnicity_filtered sample_unweighted.png		Understanding Society User Support Team, 05/23/2024 11:46 AM
jbpen_forum2.do (6.78 KB) jbpen_forum2.do		Understanding Society User Support Team, 05/23/2024 11:46 AM

Actions

Copy link Download all files

Updated by Understanding Society User Support Team 7 months ago

File Employer runs a pension scheme by wave.png Employer runs a pension scheme by wave.png added
File jbpen_forum.do jbpen_forum.do added
Priority changed from Urgent to Normal
% Done changed from 0 to 80

Dear Saadaf,

1. I checked the frequencies for jbpen and I couldn't find a drop in wave 6 (see the figure attached).
2. This is because this question is asked only of proxy respondents (Sometimes when a person cannot participate in the interview, someone else in the household (generally their spouse or partner or adult children) answers questions on their behalf, that is, by proxy. This questionnaire is a much shorter questionnaire asking factual information.)

Please check the list of available income variables here https://www.understandingsociety.ac.uk/documentation/mainstage/user-guides/main-survey-user-guide/derived-income-variables/, you might also want to have a look at this paper https://understandingsociety.ac.uk/wp-content/uploads/working-papers/2019-08.pdf

I hope it helps.

Best wishes,
Piotr Marzec
UKHLS User Support

Actions

Copy link

Updated by Saddaf Naaz Akhtar 7 months ago

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

Actions

Copy link

Updated by Saddaf Naaz Akhtar 7 months ago

Dear Piotr,

I forgot to inform you that I am looking for 45-64 years adults. Please use this filter too.

Thank you.

Actions

Copy link

Updated by Understanding Society User Support Team 7 months ago

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

Actions

Copy link

Updated by Understanding Society User Support Team 7 months ago

Status changed from New to Feedback

Actions

Copy link

Updated by Saddaf Naaz Akhtar 7 months ago

File wave 6 query.do wave 6 query.do added

Dear Piotr,

The do file is attached to this mail.

Please find the attachment.

Thank you.

Kind regards,
Saddaf

Actions

Copy link Download all files

Updated by Understanding Society User Support Team 7 months ago

File fig 1. jbpen by wave_filtered sample_unweighted.png fig 1. jbpen by wave_filtered sample_unweighted.png added
File fig 2. jbpen by wave_filtered sample_weighted.png fig 2. jbpen by wave_filtered sample_weighted.png added
File fig 3. jbpen by wave&ethnicity_filtered sample_unweighted.png fig 3. jbpen by wave&ethnicity_filtered sample_unweighted.png added
File jbpen_forum2.do jbpen_forum2.do added

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

Actions

Copy link