Many thanks. I should have known better.
On 8/31/05, Clive Nicholas <[email protected]> wrote:
> Raphael Fraser wrote:
>
> > I have 50 data sets (d1, d2, ..., d50) like the one given below but
> > much larger. I would like to calculate the prevalence of protein for
> > each data set by genotype (AA and SS). Then put the results together
> > in a single file. Can this be done?
> >
> >
> > DATA SET 1(d1)
> > id age genotype protein
> > 31 11 AA 1
> > 40 11 SS 0
> > 71 11 AA 1
> > 74 11 AA 0
> > 88 11 AA 0
> > 98 11 AA 0
> > 110 11 SS 1
> >
> > The first two observation in the RESULTS file should look some thing like
> > this:
> >
> > age genotype prevalence
> > 11 AA 0.4
> > 11 SS 0.5
>
> Looks like an easy job for -collapse-, thus:
>
> . collapse (mean) age protein, by(genotype)
>
> You have to discard your -id- variable for this to work. I assume you mean
> -protein- when you say -prevalance-, in which case you can easily
> -rename-. I hope this helps.
>
> CLIVE NICHOLAS |t: 0(044)7903 397793
> Politics |e: [email protected]
> Newcastle University |http://www.ncl.ac.uk/geps
>
> Whereever you go and whatever you do, just remember this. No matter how
> many like you, admire you, love you or adore you, the number of people
> turning up to your funeral will be largely determined by local weather
> conditions.
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
-
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
