here is a script for removing duplicates. there is also a point and click & aggregate way to do this.
sort cases by school_code.
if school_code=lag(school_code) drop=1.
select if missing(drop).
------------------------------
Art Jack
------------------------------