SPSSX Discussion

Highest Value

Classic

List

Threaded

8 messages Options

April Vergara

Highest Value

Hi,

Anyone knows how I can get highest value across variables.

For example, I have vars M1,M2,...M12 with diff values. How do I get the
highest?

Thanks.

April

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

Kylie Lange

Re: Highest Value

Hi April,

Use the MAXimum function:

COMPUTE max_value = MAX(M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11, M12).

Cheers,
Kylie.

On 19/11/2007 1:42 PM, April Vergara wrote:

> Hi,
>
>
>
> Anyone knows how I can get highest value across variables.
>
> For example, I have vars M1,M2,...M12 with diff values. How do I get the
> highest?
>
>
>
> Thanks.
>
> April
>
>
>
> ===================
> 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

behnaz shirazi-2

Re: Highest Value

Hi Kylie:
Do you know if I want to get max and min number of a variable what should I
do?

Thanks
Behnaz

>From: Kylie Lange <[hidden email]>
>Reply-To: Kylie Lange <[hidden email]>
>To: [hidden email]
>Subject: Re: Highest Value
>Date: Mon, 19 Nov 2007 13:53:49 +1030
>
>Hi April,
>
>Use the MAXimum function:
>
>COMPUTE max_value = MAX(M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11, M12).
>
>Cheers,
>Kylie.
>
>
>On 19/11/2007 1:42 PM, April Vergara wrote:
>>Hi,
>>
>>
>>
>>Anyone knows how I can get highest value across variables.
>>
>>For example, I have vars M1,M2,...M12 with diff values. How do I get the
>>highest?
>>
>>
>>
>>Thanks.
>>
>>April
>>
>>
>>
>>===================
>>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

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

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

Kylie Lange

Re: Highest Value

Hi Behnaz,

If you mean of a single variable, then procedures such as FREQUENCIES
and DESCRIPTIVES can be used to report the maximum and minimum value.
See the Analyse > Descriptive Statistics menu if you are not familiar
with these procedures.

Cheers,
Kylie.

On 23/11/2007 1:18 PM, behnaz shirazi wrote:

> Hi Kylie:
> Do you know if I want to get max and min number of a variable what
> should I do?
>
> Thanks
> Behnaz
>
>
>> From: Kylie Lange <[hidden email]>
>> Reply-To: Kylie Lange <[hidden email]>
>> To: [hidden email]
>> Subject: Re: Highest Value
>> Date: Mon, 19 Nov 2007 13:53:49 +1030
>>
>> Hi April,
>>
>> Use the MAXimum function:
>>
>> COMPUTE max_value = MAX(M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11,
>> M12).
>>
>> Cheers,
>> Kylie.
>>
>>
>> On 19/11/2007 1:42 PM, April Vergara wrote:
>>> Hi,
>>>
>>>
>>>
>>> Anyone knows how I can get highest value across variables.
>>>
>>> For example, I have vars M1,M2,...M12 with diff values. How do I get
>>> the
>>> highest?
>>>
>>>
>>>
>>> Thanks.
>>>
>>> April
>>>
>>>
>>>
>>> ===================
>>> 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
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today it's
> FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

behnaz shirazi-2

Re: Highest Value

HI Kylie,

Thanks for your suggestion but I don't need max and min of variables ,let's
say I have 8 variables with different number of cases for each variable .I
need max and min of these N(not value).

I will dig more with freq but as I tested I couldn't get the result.

Best Regards
Behnaz

>From: Kylie Lange <[hidden email]>
>Reply-To: Kylie Lange <[hidden email]>
>To: [hidden email]
>Subject: Re: Highest Value
>Date: Fri, 23 Nov 2007 13:22:04 +1030
>
>Hi Behnaz,
>
>If you mean of a single variable, then procedures such as FREQUENCIES
>and DESCRIPTIVES can be used to report the maximum and minimum value.
>See the Analyse > Descriptive Statistics menu if you are not familiar
>with these procedures.
>
>Cheers,
>Kylie.
>
>
>On 23/11/2007 1:18 PM, behnaz shirazi wrote:
>>Hi Kylie:
>>Do you know if I want to get max and min number of a variable what
>>should I do?
>>
>>Thanks
>>Behnaz
>>
>>
>>>From: Kylie Lange <[hidden email]>
>>>Reply-To: Kylie Lange <[hidden email]>
>>>To: [hidden email]
>>>Subject: Re: Highest Value
>>>Date: Mon, 19 Nov 2007 13:53:49 +1030
>>>
>>>Hi April,
>>>
>>>Use the MAXimum function:
>>>
>>>COMPUTE max_value = MAX(M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11,
>>>M12).
>>>
>>>Cheers,
>>>Kylie.
>>>
>>>
>>>On 19/11/2007 1:42 PM, April Vergara wrote:
>>>>Hi,
>>>>
>>>>
>>>>
>>>>Anyone knows how I can get highest value across variables.
>>>>
>>>>For example, I have vars M1,M2,...M12 with diff values. How do I get
>>>>the
>>>>highest?
>>>>
>>>>
>>>>
>>>>Thanks.
>>>>
>>>>April
>>>>
>>>>
>>>>
>>>>===================
>>>>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
>>
>>_________________________________________________________________
>>Express yourself instantly with MSN Messenger! Download today it's
>>FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>=====================
>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

Peck, Jon

Re: Highest Value

I'm not sure I understand what you are trying to compute, but if it is just the number of nonmissing cases for each of a set of variables, you can do that with AGGREGATE. For example, if c is a constant and x, y, and z are the variables, the syntax below create a new dataset containing the counts. (You could alternatively add these counts to the input dataset.)

DATASET DECLARE fred.
AGGREGATE
/OUTFILE='fred'
/BREAK=c
/x_nu=NU(x)
/y_nu=NU(y)
/z_nu=NU(z).

Both user and system missing values are excluded from the counts.

Then you can apply whatever computations you need to the new dataset.

HTH,
Jon Peck

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of behnaz shirazi
Sent: Friday, November 23, 2007 8:47 AM
To: [hidden email]
Subject: Re: [SPSSX-L] Highest Value

HI Kylie,

Thanks for your suggestion but I don't need max and min of variables ,let's
say I have 8 variables with different number of cases for each variable .I
need max and min of these N(not value).

I will dig more with freq but as I tested I couldn't get the result.

Best Regards
Behnaz

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.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

Kylie Lange-2

Re: Highest Value

In reply to this post by behnaz shirazi-2

Hi Behnaz,

It's not clear what format you need the result in, but if you run Descriptives
on all 8 variables then that will print out the N of each variable in a column
of a single table. Is that sufficient?

Cheers,
Kylie.

Quoting behnaz shirazi <[hidden email]>:

> HI Kylie,
>
> Thanks for your suggestion but I don't need max and min of variables ,let's
> say I have 8 variables with different number of cases for each variable .I
> need max and min of these N(not value).
>
> I will dig more with freq but as I tested I couldn't get the result.
>
> Best Regards
> Behnaz
>
>
> >From: Kylie Lange <[hidden email]>
> >Reply-To: Kylie Lange <[hidden email]>
> >To: [hidden email]
> >Subject: Re: Highest Value
> >Date: Fri, 23 Nov 2007 13:22:04 +1030
> >
> >Hi Behnaz,
> >
> >If you mean of a single variable, then procedures such as FREQUENCIES
> >and DESCRIPTIVES can be used to report the maximum and minimum value.
> >See the Analyse > Descriptive Statistics menu if you are not familiar
> >with these procedures.
> >
> >Cheers,
> >Kylie.
> >
> >
> >On 23/11/2007 1:18 PM, behnaz shirazi wrote:
> >>Hi Kylie:
> >>Do you know if I want to get max and min number of a variable what
> >>should I do?
> >>
> >>Thanks
> >>Behnaz
> >>
> >>
> >>>From: Kylie Lange <[hidden email]>
> >>>Reply-To: Kylie Lange <[hidden email]>
> >>>To: [hidden email]
> >>>Subject: Re: Highest Value
> >>>Date: Mon, 19 Nov 2007 13:53:49 +1030
> >>>
> >>>Hi April,
> >>>
> >>>Use the MAXimum function:
> >>>
> >>>COMPUTE max_value = MAX(M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11,
> >>>M12).
> >>>
> >>>Cheers,
> >>>Kylie.
> >>>
> >>>
> >>>On 19/11/2007 1:42 PM, April Vergara wrote:
> >>>>Hi,
> >>>>
> >>>>
> >>>>
> >>>>Anyone knows how I can get highest value across variables.
> >>>>
> >>>>For example, I have vars M1,M2,...M12 with diff values. How do I get
> >>>>the
> >>>>highest?
> >>>>
> >>>>
> >>>>
> >>>>Thanks.
> >>>>
> >>>>April
> >>>>
> >>>>
> >>>>
> >>>>===================
> >>>>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
> >>
> >>_________________________________________________________________
> >>Express yourself instantly with MSN Messenger! Download today it's
> >>FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> >
> >=====================
> >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
>
> _________________________________________________________________
> Don't just search. Find. Check out the new MSN Search!
> http://search.msn.com/
>

behnaz shirazi-2

Re: Highest Value

In reply to this post by Peck, Jon

Hello dear Jon and Kylie,
Thank you for your solutions but actualy I don't have problem with having N
for my variables .I need max and min of these N.
For example if I have (number of cases) 33 , 35, 36 ,37 I need to show just
33 and 37.

8 varibales with different N for each.I need min and max of this N.Because
these 8 variables are related together and N can be variable.While I want to
get max and min of N.

All the best
Behnaz

>From: "Peck, Jon" <[hidden email]>
>Reply-To: "Peck, Jon" <[hidden email]>
>To: [hidden email]
>Subject: Re: Highest Value
>Date: Fri, 23 Nov 2007 21:08:56 -0600
>
>I'm not sure I understand what you are trying to compute, but if it is just
>the number of nonmissing cases for each of a set of variables, you can do
>that with AGGREGATE. For example, if c is a constant and x, y, and z are
>the variables, the syntax below create a new dataset containing the counts.
> (You could alternatively add these counts to the input dataset.)
>
>DATASET DECLARE fred.
>AGGREGATE
> /OUTFILE='fred'
> /BREAK=c
> /x_nu=NU(x)
> /y_nu=NU(y)
> /z_nu=NU(z).
>
>Both user and system missing values are excluded from the counts.
>
>Then you can apply whatever computations you need to the new dataset.
>
>
>HTH,
>Jon Peck
>
>-----Original Message-----
>From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
>behnaz shirazi
>Sent: Friday, November 23, 2007 8:47 AM
>To: [hidden email]
>Subject: Re: [SPSSX-L] Highest Value
>
>HI Kylie,
>
>Thanks for your suggestion but I don't need max and min of variables ,let's
>say I have 8 variables with different number of cases for each variable .I
>need max and min of these N(not value).
>
>I will dig more with freq but as I tested I couldn't get the result.
>
>Best Regards
>Behnaz
>
>
> >From: Kylie Lange <[hidden email]>
> >Reply-To: Kylie Lange <[hidden email]>
> >To: [hidden email]
> >Subject: Re: Highest Value
> >Date: Fri, 23 Nov 2007 13:22:04 +1030
> >
> >Hi Behnaz,
> >
> >If you mean of a single variable, then procedures such as FREQUENCIES
> >and DESCRIPTIVES can be used to report the maximum and minimum value.
> >See the Analyse > Descriptive Statistics menu if you are not familiar
> >with these procedures.
> >
> >Cheers,
> >Kylie.
> >
> >
> >On 23/11/2007 1:18 PM, behnaz shirazi wrote:
> >>Hi Kylie:
> >>Do you know if I want to get max and min number of a variable what
> >>should I do?
> >>
> >>Thanks
> >>Behnaz
> >>
> >>
> >>>From: Kylie Lange <[hidden email]>
> >>>Reply-To: Kylie Lange <[hidden email]>
> >>>To: [hidden email]
> >>>Subject: Re: Highest Value
> >>>Date: Mon, 19 Nov 2007 13:53:49 +1030
> >>>
> >>>Hi April,
> >>>
> >>>Use the MAXimum function:
> >>>
> >>>COMPUTE max_value = MAX(M1, M2, M3, M4, M5, M6, M7, M8, M9, M10, M11,
> >>>M12).
> >>>
> >>>Cheers,
> >>>Kylie.
> >>>
> >>>
> >>>On 19/11/2007 1:42 PM, April Vergara wrote:
> >>>>Hi,
> >>>>
> >>>>
> >>>>
> >>>>Anyone knows how I can get highest value across variables.
> >>>>
> >>>>For example, I have vars M1,M2,...M12 with diff values. How do I get
> >>>>the
> >>>>highest?
> >>>>
> >>>>
> >>>>
> >>>>Thanks.
> >>>>
> >>>>April
> >>>>
> >>>>
> >>>>
> >>>>===================
> >>>>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
> >>
> >>_________________________________________________________________
> >>Express yourself instantly with MSN Messenger! Download today it's
> >>FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
> >
> >=====================
> >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
>
>_________________________________________________________________
>Don't just search. Find. Check out the new MSN Search!
>http://search.msn.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