I am analyzing information on uhrswork Nash eqm. decision matrix for husbands and wives. As of now, I have 2.2million uhrswork(male) observations with 2.2million linked uhrswork_sp(female) observations, and 1.7million uhrswork(female) observations with 1.7million linked uhrswork_sp(male) observations. I assume that the difference in sex of the primary person is due to more male-identifying spouses filling out the survey or being listed as head of household.
I want to somehow combine all male observations with each other (primary and _sp) and all female observations with each other (primary and _sp) so I can tabulate data from all couples together. Right now I only know how to tabulate information for primary husbands and secondary (_sp) wives OR primary wives and secondary (_sp) husbands. I want to combine these 4 variables into just 2, one for each identifying gender, without losing the ability to analyze spousal actions through actions of the primary.
Thank you for the help!