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

Re: st: RE: Sorting Data


From   "Mkenda A.F" <amkenda@udsm.ac.tz>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: Sorting Data
Date   Thu, 14 Nov 2002 13:23:49 +0300

Hello Bryan,
As a matter of fact I have given a lot of though about how to treat
abstaintion vote, and I am still thinking. It is a work in progress,
and right now I focused on how to sort the data and perhaps later
I may even figure out how best to handle the abstaintion votes.
Thanks,
A.F. Mkenda
Dar es Salaam
Tanzania


At 01:10 PM 11/13/02 -0500, you wrote:
>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/
>

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