Hi everyone,
I have some panel data and I need to combine observations that share an id and a date. The id is stored in a variable ("unique_id"). Each id may have multiple dates, and so will have multiple records (i.e. longitudinal data). However, right now I have multiple observations with the same id and same date, but with different values on some dummy variables. I want to combine all of the observations that share an id and a date in such a way that if at least observation has a value of "1" in a dummy variable, the combined variable will also have a value of "1" in that dummy.
Do you have any suggestions?
Thanks,
Kris
I have some panel data and I need to combine observations that share an id and a date. The id is stored in a variable ("unique_id"). Each id may have multiple dates, and so will have multiple records (i.e. longitudinal data). However, right now I have multiple observations with the same id and same date, but with different values on some dummy variables. I want to combine all of the observations that share an id and a date in such a way that if at least observation has a value of "1" in a dummy variable, the combined variable will also have a value of "1" in that dummy.
Do you have any suggestions?
Thanks,
Kris
Comment