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 <[email protected]>
To   [email protected]
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: [email protected]
WWW (personal):
WWW (department):

* For searches and help try:

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