Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: difficult merging issue


From   Rufus Peabody <rufus.peabody@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: difficult merging issue
Date   Sat, 12 Jul 2008 20:33:50 -0700

Hey all,

I'm doing an analysis of college football officiating and have a large dataset. Each game played is an observation. There are 7 types of officials, and I have an ID for each official. I have the 7 official variables, but the problem is that officials are not confined exclusively to one type---for example, one official might be "Referee" one game and "Line Judge" another. What I did to alleviate this problem was create dummies for each official (there are 596 in total).

Now, the major issue: I would like to somehow transform this so that each official is an observation and I have mean(penalties), mean(penalty yards), total games, etc. as variables. This would mean there should be 596 total observations. Anybody have any suggestions of how to tackle this problem?

Thanks!
Rufus
*
* 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/




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