Date:         Mon, 4 Mar 2002 20:01:36 -0500
Reply-To:     Raynald Levesque <rlevesque@videotron.ca>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Raynald Levesque <rlevesque@videotron.ca>
Subject:      Re: sort mean scores
In-Reply-To:  <004601c1c36e$60cef7c0$1702a8c0@vincent>
Content-Type: text/plain; charset="iso-8859-1"

How about this?

DATA LIST LIST /question(A8) mean(f3.2).

BEGIN DATA
q1 2.2
q2 2.3
q3 2.1
q4 2.5
q5 2.9
q6 3.2
q7 4.1
END DATA.

LIST.

SORT CASES BY mean(D).
SUMMARIZE
  /TABLES=question mean
  /FORMAT=VALIDLIST NOCASENUM TOTAL
  /TITLE='Highest Responses'
  /MISSING=VARIABLE
  /CELLS=NONE.

Regards

Raynald Levesque rlevesque@videotron.ca
Visit my SPSS Pages http://pages.infinit.net/rlevesqu/index.htm

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
Vincent Toh
Sent: March 4, 2002 6:19 AM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: sort mean scores


Dear List,

I was wondering if it is possible to sort the means scores in either
ascending or descending values upon generation of general tables.

Please view my syntax to have a better idea of what I mean.

DATA LIST LIST /question(A8) mean(f3.2).

BEGIN DATA

q1 2.2

q2 2.3

q3 2.1

q4 2.5

q5 2.9

q6 3.2

q7 4.1

END DATA.

LIST.

* General Tables.

TABLES

/FORMAT BLANK MISSING('.')

/OBSERVATION= mean

/GBASE=CASES

/TABLE=question BY mean

/STATISTICS

mean( mean( F7.2 )) /TITLE 'Highest Responses' ''.


Thank you very much and would appreciate any enriching advise.

Thanks in advance!

Vincent