Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down at the end of May, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Nick Cox <njcoxstata@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Save the percentage of each response category into new variables |

Date |
Fri, 9 Sep 2011 18:20:19 +0100 |

Also, if percents rather than proportions are really needed, you can do that within the same line. sysuse nlsw88 bys race: egen p_mar = mean(100 * married) bys race: egen p_n_mar = mean(100 * never_married) The easy details here are that -egen, mean()- works on expressions, which can be more complicated than single variable names, and also that mean(constant * variable) is equal to constant * mean(variable). Note that bys race: egen p_n_mar = 100 * mean(never_married) won't work. On Fri, Sep 9, 2011 at 5:28 PM, Maarten Buis <maartenlbuis@gmail.com> wrote: > On Fri, Sep 9, 2011 at 6:14 PM, <hsiyuan@uchicago.edu> wrote: >> I have a panel data where I want to compare the percentage of people belonging to each category of the marital status variable in each group and each time point. There are five categories in the marriage variable and I have two time points and two groups each with say, 50 people. > > The trick is that the proportion is the mean of a dummy/indicator variable, so: > > *-------------- begin example ----------------- > sysuse nlsw88 > bys race: egen p_mar = mean(married) > bys race: egen p_n_mar = mean(never_married) > *------------- end example ----------------- > (For more on examples I sent to the Statalist see: > http://www.maartenbuis.nl/example_faq ) > * * 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/

**References**:**st: Save the percentage of each response category into new variables***From:*<hsiyuan@uchicago.edu>

**Re: st: Save the percentage of each response category into new variables***From:*Maarten Buis <maartenlbuis@gmail.com>

- Prev by Date:
**Re: st: Save the percentage of each response category into new variables** - Next by Date:
**Re: st: Save the percentage of each response category into new variables** - Previous by thread:
**Re: st: Save the percentage of each response category into new variables** - Next by thread:
**Re: st: Save the percentage of each response category into new variables** - Index(es):