Date:         Thu, 21 Mar 2002 09:32:15 -0500
Reply-To:     Patricia Cleland <Patricia.Cleland@eqao.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Patricia Cleland <Patricia.Cleland@eqao.com>
Subject:      re-organizing data from 1 line per student to 1 line per school
Content-Type: text/plain; charset=US-ASCII

I have a data file that contains data on the scores of all children who wrote the Grade 3 Reading assessment in 2001.  It has about 145,000 cases, that is, each child is a case.  As well as the child's scores, each record contains identifying information about the school, that is school id and name and the name and id of the school board in which is located.  What I need is a file with 1 line per school with the number of children at each level on the reading assessment (there are a total of 10 levels) as well as the information that identifies the school (name, board id and name).

The original file looks like this, with 1 case per student:

studentid  schoolid schoolname board_id board_name reading_score

What I want is 1 case per school:

schoolid schoolname board_id board_name Level1 Level2  ...Level10, where Level1 to Level10 are the number of kids in that school at that level.

At the end of everything, I need to export the data file to Excel since the client only has Excel.

This feels like it shouldn't be that complicated but I'm stumped as to how to proceed.  This is probably something that we will need to do more than once, so I'm willing to invest some up-front time to get it right.  Any suggestions with how to proceed would be greatly appreciated.  I'm using 10.1.

Thanks,
Pat

--------------------------------------------------------------
Patricia Cleland,
Assessment Officer,
Data and Operations Unit,
Education Quality and Accountability Office
Suite 1200, 2 Carlton Street,
Toronto, Ontario
M5B 2M9

phone:416-314-7950
fax:     416-325-6622
email: patricia.cleland@eqao.com