Date: Thu, 21 Mar 2002 12:51:16 -0300
Reply-To: hmaletta@fibertel.com.ar
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Hector Maletta <hmaletta@fibertel.com.ar>
Subject: Re: re-organizing data from 1 line per student to 1 line per
school
Content-Type: text/plain; charset=us-ascii
Patricia:
Jim's suggestion is good, but it won't achieve exactly what you want. It
would create a file with one case per each combination of school id and
reading score. That is, one record for school A and score 1, another
record for school A and score 2, and so on.
What you asked was one record per school, with 10 variables representing
how many children at that school obtained a given score. That is
achieved with the solution I sent before.
Hector Maletta
Universidad del Salvador
Buenos Aires, Argentina.
"Marks, Jim" wrote:
>
> Hi Patricia:
>
> The function you are looking for is AGGREGATE. It will create a new file
> with the information you are looking for.
>
> data list FREE /stdt_id (F8) schl_id (F8) schlname (A30) brd_id (F8)
> brd_name (A30) read_scr (F8).
>
> Begin data
> 1 1 Central 1 Etobicoke 1
> 2 1 Central 1 Etobicoke 2
> 3 1 Central 1 Etobicoke 1
> 4 1 Central 1 Etobicoke 6
> 5 1 Central 1 Etobicoke 3
> 6 1 Central 1 Etobicoke 4
> 7 1 Central 1 Etobicoke 8
> 8 1 Central 1 Etobicoke 6
> 9 1 Central 1 Etobicoke 9
> 10 1 Central 1 Etobicoke 2
> 11 1 Central 1 Etobicoke 10
> 12 1 Central 1 Etobicoke 6
> 13 2 Laurier 2 Scarborough 6
> 14 2 Laurier 2 Scarborough 1
> 15 2 Laurier 2 Scarborough 2
> 16 2 Laurier 2 Scarborough 6
> END DATA.
>
> AGGREGATE
> /OUTFILE=*
> /BREAK=schl_id read_scr
> /schlname brd_name brd_id= First(schlname brd_name brd_id)
> /nbr_stdt=N.
>
> This example will replace your working file. If you want to create a new
> file replace the " * " with a file name: 'c:\temp.sav'
>
> Cheers
>
> Jim Marks
> Market Analyst
> LodgeNet Entertainment Corporation
> 605.988.1616
>
> IMPORTANT NOTICE: This communication (including any attached files) is
> intended for the entity to which it is directed and may contain confidential
> and proprietary information of LodgeNet Entertainment Corporation. The
> communication is provided under the terms of the nondisclosure agreement
> between LodgeNet and the intended recipient. If you are not acting solely
> on behalf of the intended recipient with respect to the receipt of this
> communication, you are not authorized to receive, retain, print or forward
> this communication. In that event, you are directed to destroy this
> communication (including any attached files), and to advise
> ipmanager@lodgenet.com that you received this communication in error. If
> you are authorized to receive this communication on behalf of the intended
> recipient, you are obligated to treat it as confidential and proprietary
> information of LodgeNet Entertainment Corporation, in accordance with the
> nondisclosure agreement mentioned above.
>
> -----Original Message-----
> From: Patricia Cleland [mailto:Patricia.Cleland@eqao.com]
> Sent: Thursday, March 21, 2002 8:32 AM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: re-organizing data from 1 line per student to 1 line per school
>
> 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
| 
