Hi statalister,
I would like to reshape "long" a large dataset of 8000 households in which every households (in rows) has up to 35 members. If I reshape long using the usual command, stata creates 8000*35=280 k rows.. This is particularly inefficient because most of these rows are entirely empty: in deed most households have a few members only, a handful of them have 35 members.
How can I simply ask stata to reshape but not reshape empty rows?
Thanks
Related Posts with reshape a large household survey
Difference in Difference Model - Binary outcome variable- Panel dataHi, I am trying to do a diff in diff model for the panel dataset. My outcome variable (y) is binary…
Reshape from wide to long with multiple variablesHello everyone, Just trying to puzzle out how to reshape my dataset from wide format to long, but w…
Graph STATA RR 95% CI with different colors and space between barsHello everybody, I am really struggling to create a graph in STATA that looks like the attached one…
How to test for differences in two WTP distributions using the complete combinatorial approachDear all, Does anyone know how to test for differences in two WTP distributions using the complete …
Variable transormation and change in coefficientsDear Stata members Let us say that my dependent variable is Net credit, derived as a difference betw…
Subscribe to:
Post Comments (Atom)
0 Response to reshape a large household survey
Post a Comment