Kihong Eom
>
> 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
expand 3
bysort Exporter Importer : replace Year = 1949 + _n
Nick
[email protected]
*
* 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/
