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?
How to export polychoric matrix resultsHello everyone I have now searched far and wide for an answer to this question. I am using polychor…
Margins after csdid.Dear All, I want to update my traditional DiD analyses with Callaway and Sant’Anna's (2021) semi-par…
test - xsmle and interpretationHey listers, I am using the "xsmle" command to run fixed effects models on panel data. I am particu…
Is -python script- much slower in Stata 17 than in Stata 16?I use the tuples command (from SSC). The tuples command is implemented in terms of python script and…
Post estimation models for latent class analysesI recently ran a latent class analysis for my choice experiment data using the "lclogit" command. I …
Subscribe to:
Post Comments (Atom)
0 Response to How to restructure aggregated count data as individual observation?
Post a Comment