I am new to PUMS. I am trying to estimate the gender wage gap by median annual earnings of men and women in Pennsylvania. I am using 2017 1-year estimates. I am calculating WAGP*(ADJINC/1000000). I have made a table of RAC1P variable(race/ethnicity) and SEX variable, aggregating the person-level data using median function.
However my estimates are coming out incorrect - the median earnings for "Black or African American alone" class is coming more for women, whereas women should be earning less(according to past historical data in american factfinder). Am I doing something wrong?
PS- I am not using the PWGTP weights, is that the problem?
PPS- I have tried using OIP+WAGP+SEMP instead of just WAGP, but the estimates are still in the same order.
Any help is appreciated,
In reply to Beth Jarosz:
HiBeth Jarosz Thank you for replying. Would it be correct if I simply multiplied the PWGTP weights with the wage ( calculated so, (WAGP*ADJINC)/1000000 ) ? I am not sub-setting the population, so I will keep that in mind. Thanks for the advice.
In reply to Shubham Kumar: