Hello
I have a panel data set in long form - several groups (companies in different countries) and each year is its own observation). Now I downloaded additional data (in Stata format) which I would like to add selectively. The additional dataset (wide format) contains a key metric which is different for every country and every year. I would like to add this key metric to my existing dataset, however, I am missing the right commands, getting stuck the whole time.
So for example I have 10 companies from 5 different countries and 10 observations (years) each. Now I would like to add the key metric information contained in the additional dataset to each company - taking into account the correct country and year. How would you go about this? Thanks!!
I have a panel data set in long form - several groups (companies in different countries) and each year is its own observation). Now I downloaded additional data (in Stata format) which I would like to add selectively. The additional dataset (wide format) contains a key metric which is different for every country and every year. I would like to add this key metric to my existing dataset, however, I am missing the right commands, getting stuck the whole time.
So for example I have 10 companies from 5 different countries and 10 observations (years) each. Now I would like to add the key metric information contained in the additional dataset to each company - taking into account the correct country and year. How would you go about this? Thanks!!
Comment