Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: collapse with mode

From   "Martin Weiss" <>
To   <>
Subject   st: RE: collapse with mode
Date   Tue, 1 Jun 2010 00:15:02 +0200


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)


-----Original Message-----
[] On Behalf Of Tyler Frazier
Sent: Dienstag, 1. Juni 2010 00:08
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

Is there a way to do this?

*   For searches and help try:

*   For searches and help try:

© Copyright 1996–2016 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index