Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: data formatting question


From   "Nick Cox" <[email protected]>
To   <[email protected]>
Subject   st: RE: data formatting question
Date   Mon, 13 Feb 2006 20:34:02 -0000

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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index