Dear all,
I was just thinking about this: When you analyze hierarchical structured dataset (for example students L1 clustered in schools L2) and you wish to analyze the second level only (by aggregation of the first level values) you probably use the command -collapse- which gives you for example mean, median or SD etc. of the L1 units to the L2 units, but it create new dataset.
Now, I was trying to figure out a way around this, so you can incorporate the results of -collapse- into your original dataset. I would use the command:
- by L2_var, sort: egen new_L2_var = mean(another_variable) -
the result of this command is that each L1 unit gets a new mean value of the variable of interest (which is completely correct). And what I was thinkg about -- can you keep just on value for each L2 unit created this way so you have de facto two datasets in one? I don't know how to write a code for this (but I assume it will mostlikely say: keep the first value of certain variable by group).
Does it make sense to you?
Thanks for your thoughts.
Related Posts with Command collapse AND keeping the original dataset
Odds ratios and Interaction effects InterpretationHi All, I have having some trouble interpreting some interaction effects of some panel data ordinal…
Addtions of observations with conditionsHello everybody, I have a big dataset to manage and I'd like to reduce it. To do so, I want to add …
New program -ineqdecgini- (Gini coefficient and its subgroup decomposition) now available on SSC-ineq …
regression loop !Dear Colleagues I have daily stock returns and market return for 100 firms and for a number of year…
stata commandI have several observations (individuals) with each belong to a household (so each has a household I…
Subscribe to:
Post Comments (Atom)
0 Response to Command collapse AND keeping the original dataset
Post a Comment