Have you thought about using a reporting procedure rather than aggregate?
For filtered means the best way to do this is to set the variable to missing
for each logical condition of status. Then it won't be included in the mean
calculation.
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of
Keval Khichadia
Sent: Thursday, September 11, 2008 5:20 PM
To:
[hidden email]
Subject: aggregate procedure
Hi,
I have about 30 variables I need to report on (GPA, TestScore, etc..) and I
need to break by a certain type of status. The break variable has 4 values
(Applicants, Admits, Deposits, Registered).
aggregate out = *
/break = status term
/Variable1= nu(Variable1)
/Variable2 = mean(Variable2)
/Variable3= mean(Variable3)
/Variable4 = mean(Variable4)
/Variable5= mean(Variable5)
/Variable6 = mean(Variable6)
For Deposits I only need the mean of these variables for students who have a
status of deposit, and for Registered , I only need the mean of these
variables for students who have a status of Registered. The problem is I
need the mean of the variables for Admits to include Admits, Deposits,and
Registered ; and the mean for Applicants to include Applicants, Admits,
Deposits, and Registered.
I am looking for the most simple and shortest way to do this, because the
only way I can think of would use way too much syntax.
Thanks for any help,
Keval
=======
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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
=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (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
Locked
