I want to collapse (mean) "15 variables", by (household) + casewise
This is because different households have missings in different variables.
The problem is if I collapse them all at the same time, I will be deleting missing observations and not missing observations.
I am thinking on,
for each x-var in "15 variables", collapse x and save. Then append all the files.
It sounds easy, but How can I program it?
how can I make a repeated collapse and save for each variable?
any suggestion?