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
Arc Elasticities Hello, I am trying to calculate the arc elasticities for a low income group and a high income grou…
GMM: Calculating Hansen J statistic and p-value by handHello, I am running a two-step dynamic difference GMM with a pilot Stata command. This command calcu…
Hint to start programmingHello I am trying to write simple programs and can't seem to get started with what I am trying to d…
Help needed: Dummy coding for Canadian Community Health SurveyHi all, I'm new here, so my apologies if this is the wrong place for a question like this. I am con…
Group averages and assign them to a specific dateHi, I am trying to make average of the median EPS that have been forecasted 90 days before the earn…
Subscribe to:
Post Comments (Atom)
0 Response to reshape a large household survey
Post a Comment