Dear all,
I have a panel datatset of 74 countries with multiple daily observations. I have also four events A, B, C and D as dummy variables.
Array
As you can see from the Table, an event may occur multiple times per one date (ex: event A in 3/17/2020). Also, multiple events may occur in one time (e.g., event B, A and C in 3/19/2020).
I would like to merge these multiple observations in order to have just one observation per date with all occuring events. For example, for 3/19/2020 event A, 1; event B, 1; event C, 1; event D, 0. For 3/17/2020, event A, 1; event B, 0; event C, 0; event D, 0
Thank you in advance!
Jon.
Related Posts with Merging multiple observations per time in panel data.
Removing specific observationsHello everyone, Based on my title post it seems the question is repeated but no it’s different. my q…
Stata is turning out results very slowly. What can i do?I have a dataset comprising about 30 million observations. When i try to execute even basic commands…
Using the foreach-command to find a spesific part among hundreds of observations in a string variable.Dear members of Statalist, I am fairly new to Stata and I have been struggling with an issue I beli…
How to draw a smaller sample from a larger dataset with different mean/ distribution than that of larger/ parent dataset?Hello, I want to draw a ssample (with certain mean/ distribution) from a larger dataset that has di…
Problems of setting intial values in semDear all, I am running a sem on the following data. My command is sem trust->std_retweet std_fav…
Subscribe to:
Post Comments (Atom)
0 Response to Merging multiple observations per time in panel data.
Post a Comment