Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: RE: generate
From
Mirriam Gee <[email protected]>
To
[email protected]
Subject
Re: st: RE: generate
Date
Wed, 31 Mar 2010 10:33:21 +0200
Guess my question was not clearer enough. What i want in short is to
create 20 new variables which are equal to the first observation for
each variable
Obs CC1 CC2 CC3
............................................................CC20
1 333 440
2 333 440
3 333 440
4 605 777
5 605 777
6 605 777
7
..
..
Now i want to cteate
Obs CCC1
1
2
3
4
5
6
O4n Wed, Mar 31, 2010 at 12:03 AM, Martin Weiss <[email protected]> wrote:
> " As a next step i now want to create a new variable which only uses
> mean of the lowest decile for all variables e.g CCC`i'= mean of
> decile 1 for all observations."
>
>
>
> *******
> vers 9.2
>
> clear
> set obs 10000
>
> //recreating your dataset
> gen Dy= rchi2(2)
> xtile deciles = Dy, n(10)
> forv i=1/20{
> gen C`i'=rnormal()
> bys deciles: egen CC`i' =mean(C`i')
> }
>
> //Put first observation into new CCCs
> forv i=1/20{
> gen CCC`i' =CC`i'[1]
> }
> *******
>
>
> HTH
> Martin
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Mirriam Gee
> Sent: Dienstag, 30. März 2010 23:16
> To: [email protected]
> Subject: st: generate
>
> Hallo everyone, I am new in stata. I am using STATA 9.2. I do have a
> very basic statement on how to generate a variable which is equal to
> the lowest 10th percentile of income(Dy) ?
> I tried this:
> sort Dy
> Xtile deciles = Dy, n(10)
> forvalues `i' = 1/20 {
> bys deciles : egen CC`i' =mean (C`i' )
> }
> This seem to do part of the job. But it gives me mean of all deciles.
> For example CC1 varies from decile 1-10 as follows:
> Deciles CC1 CC2
> CC3..............................................
> 1 333 440
> 1 333 440
> 1 333 440
> 2 605 777
> 2 605 777
> 2 605 777
> 2
> ..
> ..
>
> As a next step i now want to create a new variable which only uses
> mean of the lowest decile for all variables e.g CCC`i'= mean of
> decile 1 for all observations. To be more precise i want CCC1 to be
> equl to 333 for all observation, and CCC2 to be 440 etc I know i can
> do this manually by checking value of CC`i' when decile=1 , and then
> proceed to input values:
>
> generate CCC1 = 330
>
>
> generate CCC2= 440
>
>
> . .
>
>
> . .
>
>
> etc up to 20th item.
> I was just wondering if there is a way of doing it automatically in my
> do file without stoping and checking results and inputting them
> manually, because i do have a lot of variables, even more than 20?
>
>
> Mirriam
>
> *
> * 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/
>
*
* 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/