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]
st: generate
From
Mirriam Gee <[email protected]>
To
[email protected]
Subject
st: generate
Date
Tue, 30 Mar 2010 14:16:29 -0700
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/