list cases

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

list cases

Hui Zhao
Hello,

Suppose I have 100 variables (var1 to var100) and another variable is
id. I want to list the first 10 cases which have the lowest 10 values
for each variable. I've tried do repeat but it's not working. Is
anybody be able to help? Thanks a lot!

hui

--
Hui Zhao, Ph.D.
Research & Evaluation Specialist I
Edvantia, Inc.
304.347.0411 (work)
360.232.3794 (cell)

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: list cases

Hui Zhao
Hi, I figured it out. For those who are learning syntax like me, here it is:

DEFINE !listid (varrep = !TOKENS (1))
sort cases by !varrep.
list cases from 1 to 10/variable=id.
!ENDDEFINE.
!listid varrep=var1.
!listid varrep=var8.
!listid varrep=var16.
....



On Mon, Oct 6, 2008 at 9:57 AM, Hui Zhao <[hidden email]> wrote:

> Hello,
>
> Suppose I have 100 variables (var1 to var100) and another variable is
> id. I want to list the first 10 cases which have the lowest 10 values
> for each variable. I've tried do repeat but it's not working. Is
> anybody be able to help? Thanks a lot!
>
> hui
>
> --
> Hui Zhao, Ph.D.
> Research & Evaluation Specialist I
> Edvantia, Inc.
> 304.347.0411 (work)
> 360.232.3794 (cell)
>



--
Hui Zhao, Ph.D.
Research & Evaluation Specialist I
Edvantia, Inc.
304.347.0411 (work)
360.232.3794 (cell)

=====================
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
Reply | Threaded
Open this post in threaded view
|

Re: list cases

ksairam reddy
In reply to this post by Hui Zhao
Please remove the list
------Original Message------
From: Hui Zhao
To: [hidden email]
Sent: Oct 6, 2008 2:07 PM
Subject: Re: list cases

Hi, I figured it out. For those who are learning syntax like me, here it is:

 DEFINE !listid (varrep = !TOKENS (1))
 sort cases by !varrep.
 list cases from 1 to 10/variable=id.
 !ENDDEFINE.
 !listid varrep=var1.
 !listid varrep=var8.
 !listid varrep=var16.
 ....



 On Mon, Oct 6, 2008 at 9:57 AM, Hui Zhao <[hidden email]> wrote:
 > Hello,
 >
 > Suppose I have 100 variables (var1 to var100) and another variable is
 > id. I want to list the first 10 cases which have the lowest 10 values
 > for each variable. I've tried do repeat but it's not working. Is
 > anybody be able to help? Thanks a lot!
 >
 > hui
 >
 > --
 > Hui Zhao, Ph.D.
 > Research & Evaluation Specialist I
 > Edvantia, Inc.
 > 304.347.0411 (work)
 > 360.232.3794 (cell)
 >



 --
 Hui Zhao, Ph.D.
 Research & Evaluation Specialist I
 Edvantia, Inc.
 304.347.0411 (work)
 360.232.3794 (cell)

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


Sent via BlackBerry by AT&T

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