Edit/Options/Output Labels lets you set what is displayed, but that does not affect the underlying order, which is based on values. However, in Ctables you can control the sorting criteria for categories, including an explicit, manually set order (the Categories and Totals subdialog or the CATEGORIES subcommand).
If you really want to sort other output by the label instead of the value, you could compute a new string variable containing the label and use it as the categorical variable. SPSS 14 has a VALUELABEL function that returns the label for the current value of the specified variable. For example,
string xlabel(a40).
compute xlabel = valuelable(x).
HTH,
Jon Peck
SPSS
-----Original Message-----
From: SPSSX(r) Discussion [mailto:
[hidden email]] On Behalf Of E. Griffin
Sent: Friday, September 22, 2006 9:07 AM
To:
[hidden email]
Subject: [SPSSX-L] ordering output by variable by value lables rather than value
For the life of me I can't figure out how to format my output by the
value label rather than the actual variable value. In my case, I have
a variable called "country" that is a 3 digit number. I have labels
for each 3-digit number that is the name of the country. On my
output, I have it set to display the value so I see the list of
country names, but the order it comes out is based on the 3 digit
number. Any help would, as always, be greatly appreciated.
Eric Griffin
Locked
