Check out -reshape-. Note, however, that
-reshape- will take your data literally,
so that, for example, "Caucasian" and
"Caucasion" will be regarded as different.
Nick
[email protected]
Michael Horowitz
> 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
*
* 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/
