On Sat, 14 Feb 2004, R.E. De Hoyos wrote:
>
> I have a dataset with bilateral trade data as follows:
>
> Country1 Country2 year btrade
> US Arg 1950 x1
> US Arg 1951 x2
> US Bra 1949 x3
> US Can 1949 x4
> US Can 1950 x5
> US Can 1951 x6
> US Col 1950 x7
> US Chile 1950 x9
> US Mex 1950 x10
> Arg Bra 1950 x11
> Arg Can 1951 x12
>
>
>
> Chile Mex 1952 xN
>
> Notice that the last of country2 (Mex) wont appear as a country1 and that
> the first of country1 (US) wont appear as country2.
>
> Want I want to do is to expand the dataset in order to have all possible
> combinations of country1 and country2 for each country in the sample. The
> dataset I'm looking for should look like the following one:
>
> Country1 Country2 year btrade
> US Arg 1950 x1
> US Arg 1951 x2
> US Bra 1949 x3
> US Can 1949 x4
> US Can 1950 x5
> US Can 1951 x6
> US Col 1950 x7
> US Chile 1950 x9
> US Mex 1950 x10
> Arg Bra 1950 x11
> Arg Can 1951 x12
>
>
> Arg US 1950 x1
> Arg US 1951 x2
>
>
> Chile Mex 1952 xN
>
>
> Mex US 1950 x10
If you have country1 and country2 information in 2 separate data sets,
would -joinby- solve your problem?
Stephen
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
