seeking help in viewing output labels in an alphabetical order - reply

[thara vardhan-2]

Hi Elaine, Anil and Michael

Thanks for responding to my plea for help with the above.

Unfortunately Michael - I have already tried your suggestion. What that
does is to list the variables alphabetically within the working file and
does not change the output labels.

Anil - the syntax you sent may help me but I use ctables and have 65
locations by which the data is presented from an aggregated data file. So
I am not aware of how to combine the two.

My table syntax is as follows:

* Custom Tables.
CTABLES
  /VLABELS VARIABLES=percentsatisfy lower upper POLREGX DISPLAY=DEFAULT
  /TABLE POLREGX BY percentsatisfy [MINIMUM] + lower [MINIMUM] + upper
  [MINIMUM]
  /CATEGORIES VARIABLES=POLREGX ORDER=A KEY=VALUE EMPTY=INCLUDE
  /TITLES
   TITLE= 'NSW July07TOJune 08 - RQ4E - Percentage of respondents
satisfied in'+
 ' general with the services provided by Police'
   CAPTION= 'Source: National Community Satisfaction with Policing
Services'+
 ' Survey June 2008'.

Looks like Elaine's suggestion is the best option for me. Yes Elaine I do
need the labels as given by the consultant because I have to calculate
values for each area.. I will have to try the If statements suggested by
you.

At the moment I am exporting SPSS output into excel and sorting it in
Excel. But then I have around 45 tables that I have to sort each quarter.
I just wanted to find a more permanent solution within SPSS.

Once again thank you all very much for helping me with the problem.

regards
Thara Vardhan
Senior Statistician
Performance Improvement & Planning
NSW Police
Tel: [phone]
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

The information contained in this email is intended for the named recipient(s)
only. It may contain private, confidential, copyright or legally privileged
information.  If you are not the intended recipient or you have received this
email by mistake, please reply to the author and delete this email immediately.
You must not copy, print, forward or distribute this email, nor place reliance
on its contents. This email and any attachment have been virus scanned. However,
you are requested to conduct a virus scan as well.  No liability is accepted
for any loss or damage resulting from a computer virus, or resulting from a delay
or defect in transmission of this email or any attached file. This email does not
constitute a representation by the NSW Police Force unless the author is legally
entitled to do so.

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

I'm not sure about the original question, but if you are just trying to have your Ctables categories in alphabetical order by label, just change
KEY=VALUE
to
KEY=LABEL
on the Categories subcommand.

HTH,
Jon Peck


-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Thara Vardhan
Sent: Sunday, August 10, 2008 8:58 PM
To: [hidden email]
Subject: [SPSSX-L] seeking help in viewing output labels in an alphabetical order - reply

Hi Elaine, Anil and Michael

Thanks for responding to my plea for help with the above.

Unfortunately Michael - I have already tried your suggestion. What that
does is to list the variables alphabetically within the working file and
does not change the output labels.

Anil - the syntax you sent may help me but I use ctables and have 65
locations by which the data is presented from an aggregated data file. So
I am not aware of how to combine the two.

My table syntax is as follows:

* Custom Tables.
CTABLES
  /VLABELS VARIABLES=percentsatisfy lower upper POLREGX DISPLAY=DEFAULT
  /TABLE POLREGX BY percentsatisfy [MINIMUM] + lower [MINIMUM] + upper
  [MINIMUM]
  /CATEGORIES VARIABLES=POLREGX ORDER=A KEY=VALUE EMPTY=INCLUDE
  /TITLES
   TITLE= 'NSW July07TOJune 08 - RQ4E - Percentage of respondents
satisfied in'+
 ' general with the services provided by Police'
   CAPTION= 'Source: National Community Satisfaction with Policing
Services'+
 ' Survey June 2008'.

Looks like Elaine's suggestion is the best option for me. Yes Elaine I do
need the labels as given by the consultant because I have to calculate
values for each area.. I will have to try the If statements suggested by
you.

At the moment I am exporting SPSS output into excel and sorting it in
Excel. But then I have around 45 tables that I have to sort each quarter.
I just wanted to find a more permanent solution within SPSS.

Once again thank you all very much for helping me with the problem.

regards
Thara Vardhan
Senior Statistician
Performance Improvement & Planning
NSW Police
Tel: [phone]
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

The information contained in this email is intended for the named recipient(s)
only. It may contain private, confidential, copyright or legally privileged
information.  If you are not the intended recipient or you have received this
email by mistake, please reply to the author and delete this email immediately.
You must not copy, print, forward or distribute this email, nor place reliance
on its contents. This email and any attachment have been virus scanned. However,
you are requested to conduct a virus scan as well.  No liability is accepted
for any loss or damage resulting from a computer virus, or resulting from a delay
or defect in transmission of this email or any attached file. This email does not
constitute a representation by the NSW Police Force unless the author is legally
entitled to do so.

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