see -help reshape-. you need first to generate an index at country-year level
bys country year: gen ethnic_index = _n
reshape wide ethnicity ethnicpop, i(country year) j(ethnic_index)
cheers,
-radu
2006/2/13, Michael Horowitz <[email protected]>:
> To whom it may concern:
>
> I have a dataset I was wondering if people might have a fix for.
>
> My data measures various information (ethnicity especially) of
> countries. The way the data is currently set up it has multiple entries
> per country per year depending on the background of the country. This
> means that if there are 2 ethnic groups in a country with significant
> populations, there are 2 entries per year as follows (these numbers are
> made up to illustrate the situation). There can also be more than 2,
> etc., and it can change depending on the population in a given year:
>
> Country Number year ethnicity ethnicpop
> 10 1930 Caucasion 1,000,000
> 10 1930 Hispanic 50,000
> 10 1931 Caucasion 1,000,100
> 10 1931 Hispanic 51,000
> 11 1931 Asia 10,000
>
>
> I want to set up the data so there is only one entry per country per year,
> as follows:
>
> Country Number year ethnic1 ethnic2 ethpop1 ethpop2
> 10 1930 Caucasian Hispanic 1,000,000 50,000
>
> Any ideas people have would be greatly appreciated.
>
> Sincerely,
> Michael Horowitz
> *
> * 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/
>
*
* 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/
