# CPS ASEC - Household Aggregation and Weights' utilisation

Hi all,

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