Frank,
I am sure you know this, but just to make sure, the line
recode newvar (18=0)
was specific to the "auto" dataset, and I included it because the
variable "mpg" had no zeros which I could use to illustrate the
solution.
T
On Mon, Aug 24, 2009 at 10:59 AM, Frank Gallo<[email protected]> wrote:
> Hi Nick & Tirthankar,
>
> Thank you for the suggestions. Here is what I did, which solved my problem:
>
> egen newvar = group(oldvar)
> recode newvar (18=0)
> replace newvar = newvar - 1
>
>
> Best,
> Frank
>
>
> On Aug 23, 2009, at 12:05 PM, Nick Cox wrote:
>
> Alternatively,
>
> egen newvar = group(oldvar) if oldvar != 0
> replace newvar = 0 if newvar == .
>
> This exploits the fact the -egen, group()- never yields 0 as a result.
>
> Nick
> [email protected]
>
> Tirthankar Chakravarty
>
> Well, in your case (non-negative values) it is easy. Simply subtract 1
> from the -group-ed variable:
> *******************
> sysuse auto, clear
> tab mpg
> recode mpg (18=0) // change 18 to 0
> egen new = group(mpg)
> replace new = new - 1
> tab new
> *******************
>
> On Sat, Aug 22, 2009 at 4:24 PM, Frank Gallo<[email protected]> wrote:
>
>> So the syntax "egen newvar = group(oldvar)" achieves my goal for one
>> variable. But for another variable, I have "0" values that I want to keep
>> and do not include in the grouping. I tried adding the if qualifier [egen
>> newvar = group(oldvar) if oldvar > 0] but this transformed the 0s to
>> missing. I would greatly appreciate any suggestions. Thank you.
>
> *
> * 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/
>
--
To every ω-consistent recursive class κ of formulae there correspond
recursive class signs r, such that neither v Gen r nor Neg(v Gen r)
belongs to Flg(κ) (where v is the free variable of r).
*
* 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/
