Support #942

Net income of multiple job holders

Added by G F over 2 years ago. Updated almost 2 years ago.

Target version:
Start date:
Due date:
% Done:


Estimated time:


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.


#1 Updated by Stephanie Auty over 2 years ago

  • 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

#2 Updated by Stephanie Auty over 2 years ago

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

#3 Updated by Stephanie Auty over 2 years ago

  • Status changed from In Progress to Feedback
  • Assignee changed from Stephanie Auty to G F
  • % Done changed from 10 to 80

#4 Updated by G F over 2 years ago

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!

#5 Updated by G F over 2 years ago

nevermind. I couldn't delete this comment but i figured out my problem

#6 Updated by Stephanie Auty almost 2 years ago

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

Also available in: Atom PDF