Date: Thu, 24 Mar 2011 12:14:07 -0700
Reply-To: David Marso <email@example.com>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: David Marso <firstname.lastname@example.org>
Subject: Re: Aggregate With New Count Variable
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)
> I have a file which has approximately 22 variables and 56,000 student
> 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
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
For a list of commands to manage subscriptions, send the command