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
Twoway graph X axisHi all, Would anyone know whether there is a similar over () function such as with the graph bar (a…
Identifying the newly employed receptionist and the waitresses who joined the enterprise after the new receptionist assumed officeHi, I have the follwoing sample: Code: ssc install dataex clear input int year str6 staff_id str5 h…
Specifying IV with panel data, binary treatment and binary/count outcomeDear all Statalisters I am working on an application of an instrumental variable (IV) approach to a…
Multilevel ModelsHi; I am runing runing linear model with four levels. I have not been able to find out what the mean…
Creating Lagged variables with repeated valuesDear all, I wanted help in creating lagged variables when there are repeated values in the dataset.…
Subscribe to:
Post Comments (Atom)
0 Response to reshape a large household survey
Post a Comment