new variable that computes maximum by pool

[jimjohn]

hi guys can someone help me with the following in spss:

Two of the variables that I have in my data set are poolno and nummtgs. so for each poolno, there will be many different records with different nummtgs. i want to create a new variable that for each poolno, it will be the maximum of the numtgs in that pool. so for the same pool, each record in this variable will have the same value, the maximum nummtgs in that pool.

now i think i can use split file group by pools, and i know there is a max function under transform ->  compute new variable. but this max function only takes in two arguments, so how would i use this to find the max under each pool? any advice would be greatly appreciated

[Marks, Jim]

not tested


aggregate file = *  mode addvariables /break = poolno
   /max_nummtg = max(nummtgs).


--jim

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
jimjohn
Sent: Thursday, January 31, 2008 11:01 AM
To: [hidden email]
Subject: new variable that computes maximum by pool

hi guys can someone help me with the following in spss:

Two of the variables that I have in my data set are poolno and nummtgs.
so for each poolno, there will be many different records with different
nummtgs. i want to create a new variable that for each poolno, it will
be the maximum of the numtgs in that pool. so for the same pool, each
record in this variable will have the same value, the maximum nummtgs in
that pool.

now i think i can use split file group by pools, and i know there is a
max function under transform ->  compute new variable. but this max
function only takes in two arguments, so how would i use this to find
the max under each pool? any advice would be greatly appreciated
--
View this message in context:
http://www.nabble.com/new-variable-that-computes-maximum-by-pool-tp15208
585p15208585.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
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

[Matthew Reeder]

Hi all,

  I have a quick, presumably easy, question regarding graphs (bivar scatterplots) in SPSS. Using the Data Label Mode button, the user is able to go about targetting specific observations and, after clicking on a given observation, obtaining the case number corresponding to that observation. I've noticed that when I do this, save the file, close, and re-open, not only is the case number pertaining to my selected observations showing, but all case numbers for all observations show, as well. Is there anyway to prevent this from happening, such that, after closing the output file and re-opening, only the observations I've selected still have their case number showing (and not all observations in the graph)? Thanks for any help.


  Regards,
  Matt


---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.

=====================
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