Hi altruist,
I am just wondering whether STATA has any function to convert aggregated count data into individual row.
For example, I have audited different parks and counted how many people are doing three different types of physical activity.
I did that multiple times in same park.
So in my raw data each row is a park and each column include 'female walking' and 'male walking' etc.
Now I want a new data where row number will be equivalent to the count of each of the activities.
I have attached a screenshot of my raw data (first) and also how the restructure may look like (2nd).
Can anyone tell me whether it is possible to restructure in STATA or not?
Thank you very much in anticipation.
best regards,
FaysalArray Array
Related Posts with How to restructure aggregated count data as individual observation?
Stata and Mata give different results for OLSI am confused why Stata OLS and Mata would give me different results, rather one of them is incorrec…
Using lagged instrumental variable for lagged endogeneous variableDear Statalist members, I am trying to use IV model with panel data (xtivreg) along with fixed effe…
Wrong efficient signs on regressionHi everyone, I am carrying out a study on the effect of unemployment on happiness(individual satis…
Using lagged instrumental variables for lagged endogenous variablesDear Statalist members, I am trying to use IV model with panel data (xtivreg) along with fixed effe…
KHB method for mediation analysisDear all, I came across the KHB method for mediation analysis. I have gone through the paper “Compar…
Subscribe to:
Post Comments (Atom)
0 Response to How to restructure aggregated count data as individual observation?
Post a Comment