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]

From |
Nicholas Winters <nicholas.winters@mail.mcgill.ca> |

To |
"statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |

Subject |
st: Creating a mean of x entries in variable1 if there are at least x entries in variable1 by person id |

Date |
Wed, 9 Oct 2013 00:07:21 +0000 |

Sorry for the complicated subject, this is what my data looks like: person id exposure year 1 3 1 1 3 2 1 4 3 1 3 4 1 3 5 2 4 1 2 4 2 2 3 3 2 4 4 3 1 1 3 2 2 3 3 3 3 2 4 I want to take an average of 'exposure' if there are at least, say, 3 entries in 'year' per person id. So I want to end up with a new variable, mean_exposure, that looks like this: person id mean_exposure 1 3 2 4 3 3 4 2 I've tried by person id: egen mean_exposure=mean(exposure) if _____________ but I want the mean of ALL values in exposure only if 'year' has at least x number of observations please help, I'm stumped...? * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**Re: st: Creating a mean of x entries in variable1 if there are at least x entries in variable1 by person id***From:*Roberto Ferrer <refp16@gmail.com>

**st: RE: Creating a mean of x entries in variable1 if there are at least x entries in variable1 by person id***From:*Joe Canner <jcanner1@jhmi.edu>

- Prev by Date:
**Re: st: RE: Box Graph Question** - Next by Date:
**st: Carry forward an observation within a time frame** - Previous by thread:
**st: Estimating a system of equations with panel data: error with xtsur** - Next by thread:
**st: RE: Creating a mean of x entries in variable1 if there are at least x entries in variable1 by person id** - Index(es):