Dear Statalist members,
I am trying to create a map of Russian regions depicting the ratio of under-reporting COVID-19 mortality.
I have a master dataset with 1020 observations. Each observation corresponds to one region and to one month of the year. Therefore, I have a region ID that goes from 1 to 85, where each ID exists 12 times. That is, in month 1 for region 1, the region ID is 1. In month 2 for region 1, the region ID is still 1, and so on.
The shaping dataset, with the coordinates of the regions, has 83 observations, one for each region. Thus, I have 83 region IDs, that only occur once each. How can I merge these two datasets based on a unique identifier?
The 1:1 merge does not work, the m:1 merge does work. However, if I try to create a map following the m:1 merge with the spmap command, I get the following error message:
Variable _ID specified in option id() does not uniquely identify the observations.
Any help would be greatly appreciated!
I am trying to create a map of Russian regions depicting the ratio of under-reporting COVID-19 mortality.
I have a master dataset with 1020 observations. Each observation corresponds to one region and to one month of the year. Therefore, I have a region ID that goes from 1 to 85, where each ID exists 12 times. That is, in month 1 for region 1, the region ID is 1. In month 2 for region 1, the region ID is still 1, and so on.
The shaping dataset, with the coordinates of the regions, has 83 observations, one for each region. Thus, I have 83 region IDs, that only occur once each. How can I merge these two datasets based on a unique identifier?
The 1:1 merge does not work, the m:1 merge does work. However, if I try to create a map following the m:1 merge with the spmap command, I get the following error message:
Variable _ID specified in option id() does not uniquely identify the observations.
Any help would be greatly appreciated!
Comment