Date:         Thu, 24 Mar 2011 12:14:07 -0700
Reply-To:     David Marso <david.marso@gmail.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         David Marso <david.marso@gmail.com>
Subject:      Re: Aggregate With New Count Variable
In-Reply-To:  <81FFC78AB1129F4FB1A509BF6E92C2A80236B631@TLRUSMNEAGMBX13.ERF.THOMSON.COM>
Content-Type: text/plain; charset=us-ascii

"contain the 22 variables from the original file plus a new variable named
student count" ????
Means of these variables or what???

AGGREGATE OUTFILE *
                / M1 to M22=MEAN(v1 TO v22)
                /  Student_Count=N.



james.moffitt wrote:
>
> I have a file which has approximately 22 variables and 56,000 student
> records.
>
> The students are enrolled in 228 schools.
>
> I want to collapse this file into a new sav file that contains one row
> per school (228 rows).
>
> I'd like that file to contain the 22 variables from the original file
> plus a new variable named student count that shows the number of
> students from each school that in the original file.
>
> I believe I want to use AGGREGATE with the school identification codes
> as my break variable.
>
> Does anyone know the syntax I would use to collapse the original file
> while at the same time adding the new student count variable to the
> output file?
>
> I am using SPSS 15.0
>
> Thanks,
>
> Jim
>


--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/Aggregate-With-New-Count-Variable-tp4262861p4262906.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
LISTSERV@LISTSERV.UGA.EDU (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD