Questions on Custom Tables and Pivoting

[Ratna Wynn-2]

Hi

 

I was wondering if there was a way to output the stat testing only for a custom table and not the table itself. I ask because I have two column variables Wave and Specialty and I want to look at specialty within wave but want statistical testing done across waves within specialty and across specialties within waves. I would need to run the tables 2 times so I could test column proportions across waves and across specialties the other time but don't need the table output twice just the stat testing. One workaround would be to create a variable that breakouts both wave and specialty but did not know if there was something far easier parrallel to format notable command in frequencies.

 

The other question I had is I would like to select all the pivot tables in the .spo document and transpose row and columns in the output for all tables at once. Is there a way to do this easily using syntax or scripts? Any help would be greatly appreciated. I have custom  tables and SPSS version 18. I am using a PC. 

 

Thanks,

 

Ratna  

[Jon K Peck]

There is no way within CTABLES to suppress the main table, but you can use OMS to prevent the table from appearing in the Viewer.

For transposition, you could create an autoscript to do the transposition automatically if you are familiar with scripting.
An alternative that would not require any programming would be to use the SPSSINC MODIFY TABLES extension command available from the SPSS Community website (www.ibm.com/developerworks/spssdevcentral).  It includes a customstyles module that has a function to transpose tables.

Here is syntax that transposes all tables of type "Custom Table".

SPSSINC MODIFY TABLES subtype="'Custom Table'"
SELECT=1
DIMENSION= COLUMNS
LEVEL = -1  PROCESS = ALL
/STYLES  APPLYTO=DATACELLS
CUSTOMFUNCTION="customstylefunctions.transpose".

HTH,

Jon Peck
Senior Software Engineer, IBM
[hidden email]
new phone: [phone]




From:        Ratna Wynn <[hidden email]>
To:        [hidden email]
Date:        05/18/2011 09:43 PM
Subject:        [SPSSX-L] Questions on Custom Tables and Pivoting
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hi
 
I was wondering if there was a way to output the stat testing only for a custom table and not the table itself. I ask because I have two column variables Wave and Specialty and I want to look at specialty within wave but want statistical testing done across waves within specialty and across specialties within waves. I would need to run the tables 2 times so I could test column proportions across waves and across specialties the other time but don't need the table output twice just the stat testing. One workaround would be to create a variable that breakouts both wave and specialty but did not know if there was something far easier parrallel to format notable command in frequencies.
 
The other question I had is I would like to select all the pivot tables in the .spo document and transpose row and columns in the output for all tables at once. Is there a way to do this easily using syntax or scripts? Any help would be greatly appreciated. I have custom  tables and SPSS version 18. I am using a PC. 
 
Thanks,
 
Ratna