CTABLES
Locked
 
|
Problem:
If I use Implicit Category Specification by using KEY=COUNT, is there any possibility to influence how SPSS sorts Categories with equal counts? It seems to me that it sorts Labels from Z to A. Could I have it done the other way round? Regards, Thomas Research Manager |
|
|
The sort order in the case of ties is undefined.
There is no way to specify the behavior in that case. Sorry.
Jon Peck (no "h") aka Kim Senior Software Engineer, IBM [hidden email] phone: 720-342-5621 From: ThW <[hidden email]> To: [hidden email], Date: 01/23/2014 04:01 AM Subject: [SPSSX-L] CTABLES Sent by: "SPSSX(r) Discussion" <[hidden email]> Problem: If I use Implicit Category Specification by using KEY=COUNT, is there any possibility to influence how SPSS sorts Categories with equal counts? It seems to me that it sorts Labels from Z to A. Could I have it done the other way round? Regards, Thomas Research Manager -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/CTABLES-tp5724093.html Sent from the SPSSX Discussion mailing list archive at Nabble.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 |
|
Is there a SPSSINC to
edit tables?
Art Kendall Social Research ConsultantsOn 1/23/2014 9:00 AM, Jon K Peck [via SPSSX Discussion] wrote: The sort order in the case of ties is undefined. There is no way to specify the behavior in that case. Sorry.
Art Kendall
Social Research Consultants |
|
|
SPSSINC MODIFY TABLES can sort table columns
in newer versions of Statistics, but it uses a stable sort, which means
that it would not change the order of ties.
In V22, you can use the new OUTPUT MODIFY command to sort table columns. Here is an example using the employee data.sav file. CTABLES /TABLE jobcat > educ. OUTPUT MODIFY /SELECT TABLES /IF COMMANDS=["CTables(1)"] LABELS=[EXACT("Table 1")] INSTANCES=[1] /TABLE SORT=COLLABEL("Count"). Jon Peck (no "h") aka Kim Senior Software Engineer, IBM [hidden email] phone: 720-342-5621 From: Art Kendall <[hidden email]> To: [hidden email], Date: 01/23/2014 08:07 AM Subject: Re: [SPSSX-L] CTABLES Sent by: "SPSSX(r) Discussion" <[hidden email]> Is there a SPSSINC to edit tables? Art Kendall Social Research Consultants On 1/23/2014 9:00 AM, Jon K Peck [via SPSSX Discussion] wrote: The sort order in the case of ties is undefined. There is no way to specify the behavior in that case. Sorry. Jon Peck (no "h") aka Kim Senior Software Engineer, IBM [hidden email] phone: 720-342-5621 From: ThW <[hidden email]> To: [hidden email], Date: 01/23/2014 04:01 AM Subject: [SPSSX-L] CTABLES Sent by: "SPSSX(r) Discussion" <[hidden email]> Problem: If I use Implicit Category Specification by using KEY=COUNT, is there any possibility to influence how SPSS sorts Categories with equal counts? It seems to me that it sorts Labels from Z to A. Could I have it done the other way round? Regards, Thomas Research Manager -- View this message in context: http://spssx-discussion.1045642.n5.nabble.com/CTABLES-tp5724093.html Sent from the SPSSX Discussion mailing list archive at Nabble.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 If you reply to this email, your message will be added to the discussion below: http://spssx-discussion.1045642.n5.nabble.com/CTABLES-tp5724093p5724095.html To start a new topic under SPSSX Discussion, email [hidden email] To unsubscribe from SPSSX Discussion, click here. NAML Art Kendall View this message in context: Re: CTABLES Sent from the SPSSX Discussion mailing list archive at Nabble.com. |
|
|
In reply to this post by Jon K Peck
Of course you can
always recode the
COMPUTE X = Y. RECODE Y ... VALUE LABELS Y ... Art Kendall Social Research ConsultantsOn 1/23/2014 9:00 AM, Jon K Peck [via SPSSX Discussion] wrote: The sort order in the case of ties is undefined. There is no way to specify the behavior in that case. Sorry.
Art Kendall
Social Research Consultants |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |