counting agreements

[Tina Samuel]

Dear all,
I have the following dataset:

Trade agreement	year	country_1	country_2	country_n

I want to run a command that counts the number of trade agreements between each country-pairs. Noting that there are agreements that contain up to 80 countries. so I want to see if each of these countries share a trade agreement with another country.
Would greatly appreciate your help on this.
Thank you.

[Emil Alnor]

Tina Samuel provide an example of your data using -dataex and it will likely be possible to answer your question. If needed, you can take a sample of your data using

sample 100, count

to draw a 100 observation sample from your data before using -dataex