st: RE: collapse with mode

["Martin Weiss" <martin.weiss1@gmx.de>]

<>

You can still -egen-erate the mode beforehand, and retain the first
observation during the -collapse- call:


***********
sysuse auto, clear
bys rep78: egen mymode=mode(foreign)
collapse (firstnm) mymode, by(rep78)
l
***********


HTH
Martin


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Tyler Frazier
Sent: Dienstag, 1. Juni 2010 00:08
To: statalist@hsphsun2.harvard.edu
Subject: st: collapse with mode

Is there a way to execute a collapse and return the mode of a variable

I have a variable which is either 11 , 21  or   51  (land use:
residential, commercial or public) which can possibly but not likely
change over the time period

I want to collapse the average consumption to the meter for the time
period (16 months), but then retain either the mode or some indication
that the meter land use has changed its land use during this time
period

Is there a way to do this?

Thanks,
Ty
*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/