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

From |
"Martin Weiss" <martin.weiss1@gmx.de> |

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

Subject |
st: AW: simple sum() question |

Date |
Wed, 15 Apr 2009 17:15:00 +0200 |

<> I am betting that you want a count of visits, not a running sum, but correct me if I am wrong... ************* clear* set obs 400 egen float patient = seq(), from(1) to(400) block(4) egen float visit = seq(), from(1) to(4) block(1) //not strictly necessary xtset patient visit //less than 4 visits for some replace visit =. if runiform()<0.05 bys patient: egen overallvisits=count(visit) l in 1/20, sepby(patient) noo ************* HTH Martin -----Ursprüngliche Nachricht----- Von: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Shehzad Ali Gesendet: Mittwoch, 15. April 2009 16:48 An: statalist@hsphsun2.harvard.edu Cc: noman.paracha@gmail.com Betreff: st: simple sum() question Hi, I have a simple question about summing across observations. I have 100 patients (variable: patient_id) in the dataset, each had clinic visits (variable: clinic) and hospital visits (variable: hospital) recorded at weeks 4, 8, 12 and 16. The dataset is long and hence I have 400 observations (one observation per patient per time point). I want to sum the clinic visits for each patient (across all 4 visits) bearing in mind that some patients had less than 4 visits. So effectively I want to generate a new variable that will produce the sum of clinic visits for each patient. Any help would be appreciated. Thank you, Shehzad * * 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/

**Follow-Ups**:**Re: st: AW: simple sum() question***From:*Shehzad Ali <sia500@york.ac.uk>

**References**:**st: simple sum() question***From:*Shehzad Ali <sia500@york.ac.uk>

- Prev by Date:
**st: RE: simple sum() question** - Next by Date:
**Re: st: AW: simple sum() question** - Previous by thread:
**st: RE: simple sum() question** - Next by thread:
**Re: st: AW: simple sum() question** - Index(es):

© Copyright 1996–2017 StataCorp LLC | Terms of use | Privacy | Contact us | What's new | Site index |