Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: Sorting Data


From   "Ray, Bryan" <Bryan.Ray@NERA.com>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Sorting Data
Date   Wed, 13 Nov 2002 13:10:12 -0500

Just a quick comment on the analysis of these data...It looks like a vote
can be either yes, no, or abstain. I am no expert on UN voting patterns and
the like, but I just thought that there might be some significance to the
abstentions that you might lose by simply looking at, for a given vote,
votes that match the U.S.'s vote. 

Maybe you have already thought about a way to deal with this or have
determined that it is not an issue, but I thought it worthwhile to raise.

Bryan

-----Original Message-----
From: Mkenda A.F [mailto:amkenda@udsm.ac.tz]
Sent: Wednesday, November 13, 2002 10:17 AM
To: statalist@hsphsun2.harvard.edu
Subject: st: Sorting Data


I have the followig type of data that I want to sort in a way that I will
explain.
              
		Table 1 ( Year 1980)
Country     vote1   vote2   vote3   vote4   vote5 etc 
USA          Y       N       Y       Y       A       
Albania      N       Y       N       N       Y
Algeria      N       Y       Y       A       Y
Argentina    Y       N       Y       Y       Y
ETC


This data is of the UN general assembly voting on different resolutions and 
it repeats itself for twenty years (1980 to 2000).  

I want to constuct a variable for each country to represent the number of
times that
each country votes in line with the way USA votes. I am thinking of doing
the following:

In the first step to assign one (unit) to each vote that is the same as the
vote casted (or
not casted) by the USA and zero to each vote that differs with the US vote
on the same resolution.
Thus the data above would look like:

		Table 2 (Year 1980)
Country   vote1   vote2    vote3   vote4    vote5  etc
Albania    0       0         0       0       0   
Algeria    0       0         1       0       0
Argentina  1       1         1       1       0


Thereafter I am thinking of making a row-wise summation to get a new
variable for the frequency that
a country voted in tune with the USA.


I'll very much appreciate if anyone can suggest to me a simple program for
reorganising the
data from Table 1 above to Table 2 and making the row-wise summation for
each country for each year.

Thanks,

A. F Mkenda
University of Dar es Salaam
Tanzania


        


*
*   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/



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