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:[email protected]]
>Sent: Wednesday, November 13, 2002 10:17 AM
>To: [email protected]
>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/
