I would love some suggestions on aggregating CPS ASEC Data at Household Level, in particular on the usage of ASEC WEIGHTS.
As far as the aggregation is concerned, what I did so is:
for variables where the values were already aggregated and repeated for each member of the household (like HHINCOME, FOODSTMP, etc) I kept the observations for the householder (so RELATE ==101). Alternatively, I eliminated the duplicates, and the result is the same.
for the variables at the individual level (e.g. unemployment benefits, INCSSI, etc), I summed up the values of the members of each household.
Is it correct? (I think so, but a further confirmation is welcomed).
Most importantly, I am not sure on how to use the weights. I did the following:
I chose ASECWTH
I considered it as the # of people with the same characteristics of the corresponding respondent
Hence to compute the percentage of (for example) SNAP Recipients who are African American I did: SUM of the weights corresponding to household observations with African American and SNAP dummies = 1, divided by the sum of the weights corresponding to HH observations with SNAP dummy = 1.
Is it right? Or should I use it in another way (or use other weights)?
I apologise for the silly questions, but it’s my first experience as Research Assistant and I am not familiar with this dataset.
Thank you very much in advance for your help