Dear all:
It would be a very simple question, but it bothers me.
I have the two datasets as follows:
1. country data
Exporter Importer ID Year
U.S. Canada 1 1950
U.S. Mexico 2 1950
2. Year data
Year
1950
1951
1952
I'd like to generate the following data set from the two datasets.
Exporter Importer ID Year
U.S. Canada 1 1950
U.S. Canada 1 1951
U.S. Canada 1 1952
U.S. Mexico 2 1950
U.S. Mexico 2 1951
U.S. Mexico 2 1952
In other words, I'd like to extend the range of the years from 1950 to
1950-1952 by ID variable. I would appreciate it if you can help me solve
this puzzle (at least for me). Best, Kihong
Kihong Eom
1651 Patterson Office Tower
Lexington, KY, 40506
Office: 859-257-6958
Homepage: http://www.uky.edu/~keom0
*
* 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/