Support #942
open
Net income of multiple job holders
Added by G F almost 7 years ago.
Updated over 6 years ago.
Description
I'm a researcher doing a project on income of single vs. multiple job holders in the Understanding Society dataset and I'm having difficulty constructing variables for income. Every income earnings or pay income variable I've come across either has mostly, missing variables or is inappropriate for the project. The only earnings variable that I've seen that seems to have fewer missing rows is [letter]_paygl. But, that's gross pay from last paycheck. I definitely need to know the total weekly, monthly, or annual income of people with more than one job. And, ideally I'd like to decompose it into what they earned at both jobs. What is a good way to do this?
I could not find an answer to this on any of the questions posted online. Thanks so much for the help.
- Category set to Income
- Status changed from New to In Progress
- Assignee set to Stephanie Auty
- Target version set to X M
- % 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
Dear G F,
The following variables should help:
w_j2pay_dv is gross pay in second job (see questionnaire for clarification of gross vs net)
w_paygu_dv is gross pay in first job if employee
w_seearngrs_dv is self-employment earnings in first job if self-employed
w_fimnlabgrs_dv is total labour earnings from first and second jobs
Some people will have a value for j2pay_dv with no first job, if this is defined as occasional or casual work and they do not define themselves as holding a job at jobhas/joboff.
Best wishes,
Stephanie Auty - Understanding Society User Support Officer
- Status changed from In Progress to Feedback
- Assignee changed from Stephanie Auty to G F
- % Done changed from 10 to 80
Thanks for the feedback. I tried out this variable, unfortunately, it didn't work for a panel I'm constructing. When I merge waves into panel by the cross-wave ID variable (in R):
PANEL1 <- merge(Aindrespi, Bindrespi, by="pidp")
The only variables left are the following:
[1] "pidp" "a_jbhrs" "twojobs.x" "a_jbisco88_cc" "a_prfitba" "a_prfitbw"
[7] "a_agegr10_dv" "a_scsex" "a_urban_dv" "a_jbseg_dv" "a_paygl" "a_j2pay"
[13] "a_j2hrs" "b_prfitba" "b_jbisco88_cc" "b_jbhrs" "twojobs.y" "b_prfitbw"
[19] "b_agegr10_dv" "b_sex" "b_urban_dv" "b_jbseg_dv" "b_paygl" "b_j2pay"
[25] "b_j2hrs"
I am doing something wrong or is the gross income variable your mentioned above not available for panels? Thank you!
nevermind. I couldn't delete this comment but i figured out my problem
- Status changed from Feedback to Resolved
- % Done changed from 80 to 100
Also available in: Atom
PDF
Updated by Stephanie Auty 
Updated by