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

Re: st: Collapsing ward-level electoral data


From   Richard Williams <Richard.A.Williams.5@nd.edu>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Collapsing ward-level electoral data
Date   Mon, 22 Mar 2004 23:21:31 -0500

At 02:51 AM 3/23/2004 +0000, Clive Nicholas wrote:

What I want to do is 'collapse' this ward-level data into constituencies
("const"). As you can see, each constituency has its own number. Trouble
is, how can I achieve this whilst summing the votes, averaging the turnout
("turn"), keeping the same "year", "city" and "dist" and so forth?
How about something like

collapse (sum) vote (mean) turn, by (id year city dist const)

If I follow you correctly, each record is uniquely defined by the combo of id, year, city, dist, const and ward. So, you leave ward out of the by, and you will collapse across wards. Or am I not following you correctly?


-------------------------------------------
Richard Williams, Notre Dame Dept of Sociology
OFFICE: (574)631-6668, (574)631-6463
FAX: (574)288-4373
HOME: (574)289-5227
EMAIL: Richard.A.Williams.5@ND.Edu
WWW (personal): http://www.nd.edu/~rwilliam
WWW (department): http://www.nd.edu/~soc

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