Running PPML with bilateral exports

[Tina Samuel]

Greetings,
I am trying to conduct a study on the impact of a given trade provision on exports, the data is in bilateral form.
When I run the xtset command to specify the countries and the years I receive a message that there is repeated time values. And Yes, there is repeated time values because I am examining the exports of all countries to all other countries.
This is my first time doing something like this and I don't know how to get around it, I would greatly appreciate your help.

[Camilo Castro]

Hi Tina,
I have the same issue, but I was searching forums and I found:

https://www.statalist.org/forums/for...ral-trade-data

I am trying this myself right now. If you succeed let me know

Regards

[Tina Samuel]

Hey Camilo,
Thank you so much for sharing this, I will try it out and let you know if it worked.

Kind regards!

[Tina Samuel]

Unfortunately it didn't work

[Camilo Castro]

Hi Tina,
I used a codification for my home countries (1 to 49) and for my host countries (1 to 95). Then I used egen to group them:

 
 egen id=group(home host)  xtset id Year, yearly

However I find a repetition in the data. You can check the data

 duplicates list id year

Hope that works

[Tina Samuel]

Yes it worked perfectly, Thank you so much for your help.