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]
st: filling in the gaps
From
John Singhammer <[email protected]>
To
[email protected]
Subject
st: filling in the gaps
Date
Fri, 18 Jan 2013 09:21:20 +0100
Dear statalister
I'm working on a dataset consisting of information on 45.000 school children
Data has been collected annually since 2009, though not for all children
Information on grade has been imported from a national register.
However, that information is only available up to the year 2011
Consequently, information on grade is missing for the year 2012 and 2013
The data look like this:
id sch_year grade
347246 2010 2
347246 2011 3
347246 2012 .
731909 2010 4
731909 2011 5
731909 2012 .
901302 2011 4
901302 2013 .
How do I fill in the blanks?... and how do I take care of the cases
where information is missing for an entire year (eg. id 901302)?
Note: A school year is calculated as beginning in august and ending
in june the next year. Thus, the year 2011 begins august 2010 and ends
in june 2011.
Any advices would be much appreciated.
Thanks.
John Singhammer
University of Southern Denmark
*
* 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/