Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Dennis Kramer <dkramerii@gmail.com> |
To | statalist@hsphsun2.harvard.edu |
Subject | Re: st: Average Multiple Records |
Date | Mon, 25 Apr 2011 11:19:59 -0400 |
Thank you Nick, that worked perfectly. On Mon, Apr 25, 2011 at 10:01 AM, Nick Cox <njcoxstata@gmail.com> wrote: > Check out -egen-'s -mean()- function in conjuction with -by:-. > > Nick > > On Mon, Apr 25, 2011 at 2:30 PM, William Buchanan > <william@williambuchanan.net> wrote: > >> You can probably use - collapse - by student ID to get this. > > Dennis Kramer > >> I am trying to trying to calculate GPA for each student in a given >> year and I have course grade information in the following form: >> >> Student 1 -- Course 1 -- Grade >> Student 1 -- Course 2 -- Grade >> Student 1 -- Course 3 -- Grade >> Student 2 -- Course 1 -- Grade >> Student 2 -- Course 2 -- Grade >> Student 2 -- Course 3 -- Grade etc.... >> >> I know I need to generate a GPA variable by converting the Grade into >> a GPA format; however, I am not sure how I could generate an overall >> GPS variable for each unique student that takes into account the sum >> of the newly created GPA variables and divides it by the number of >> courses an individual took in that given year. > > * > * 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/