Re: st: RE: Creating a new series from a group of multiple series

[Syed Basher <syed.basher@yahoo.com>]

Dear Jan and Nick that was very helpful, thank you. Looking forward to reading 
Nick's `rowwise' article.

Syed



----- Original Message ----
From: Nick Cox <njcoxstata@gmail.com>
To: statalist@hsphsun2.harvard.edu
Sent: Wed, March 9, 2011 12:21:03 PM
Subject: Re: st: RE: Creating a new series from a group of multiple series

In Stata 9 and 10 you can use the user-written -rowmedian()- function
for -egen- included in -egenmore- for SSC, which you must download.

Older and much slower -egen- functions for the same purpose also
exist. Stata 9 made it possible to use Mata for the job.

Nick

On Wed, Mar 9, 2011 at 9:14 AM, Jan Bryla <JBR@finansraadet.dk> wrote:

> In Stata 11 I think you can use the rowmedian function in -egen-. In yout case 
>egen x1=rowmedian(y1 y2 y3 ... y10)
>
> See help http://www.stata.com/help.cgi?egen
>
> rowmedian(varlist)
>            may not be combined with by.  It gives the (row) median of the
>            variables in varlist, ignoring missing values.  If all variables
>            in varlist are missing for an observation, newvar is set to
>            missing in that observation.  Also see rowpctile().
>
On Behalf Of Syed Basher
>
> I have 10 series with 30 observation each. The series are labeled as y1,
> y2,y3,...,y10. I want to generate a new series (say, x1) which is the median
> of 10 series, and x1 should also contain 30 observation. So basically x1 will 
>be
> the median of 10 y but by observation. I tried doing it using foreach 
loop, due
> to wrong commands I got 10 median observations for each y. Any hint or help is
> highly appreciated. I am using Stata 11.1.

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