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

st: RE: Calculate the mean of y if there are many similar x


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Calculate the mean of y if there are many similar x
Date   Fri, 18 Mar 2005 12:28:19 -0000

. whelp collapse 

Nick 
n.j.cox@durham.ac.uk 

Eik Leong Swee
 
> I have a problem here trying to sort my data. I have 2 
> variables y and x. Each one is of
> length 15000. However, y is unique but x is not i.e. for some 
> values of y, there are more than one
> x. Specifically, there are 3573 unique values of x. I wish to 
> take the mean of y for those x's
> that are the same, so that I end up only with a unique set of 
> 3573 (y,x). I can either manually
> compute the mean 3573 times, or hopefully someone out there 
> knows a command I can use. 

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