you can however create dummy "reserved for future use" values among your value labels, and then have CTables print those 0 row/columns. Obviously those would need to be edited when the future use comes, but that's a small edit and can be put at the top of the syntax or in a data preparation step syntax for easy access.
Kathy Reinig
KJ Reinig Associates
quantitative research analysts
+1 978 544 2194
On Dec 12, 2014, at 8:37 AM, Jon K Peck wrote:
If you are using CTABLES, you can force
empty cells to appear by making sure that all variable values have a value
label. AUTORECODE has a similar capability. Of course, if new
values appear, you can't squeeze the table dimensions down Procrusteanly.
Beyond that, you could use some Python code and/or the STATS TABLE
CALC extension command to fill in absent rows or columns.
Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
phone: 720-342-5621
From:
progster <[hidden email]>
To:
[hidden email]
Date:
12/12/2014 01:40 AM
Subject:
Re: [SPSSX-L]
best way to export spss output
Sent by:
"SPSSX(r)
Discussion" <[hidden email]>
I can't export individual tables to individual xls
becuase it's really a lot
of tables.
I use the OMS in order to leave only the tables in the output. The problems
is a new item in a varible is added: so for instance the table will have
3
rows instead of 2.
I was wondering if there is a system to export data with a fixed matrix,
for
istance 3X3, so the table manteins the same dimension in the future quarter
in spite of changes in the variable.
--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/best-way-to-export-spss-output-tp5728155p5728158.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
=====================
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
Locked
