Re: st: Collapsing ward-level electoral data

[Richard Williams <Richard.A.Williams.5@nd.edu>]

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/