SPSS MODIFY TABLES OR OUTPUT EXPORT problem

[NicoDW]

Hello,

i a experiencing a problems with SPSSINC MODIFY TABLES or Output export.
The syntax I use is below. As can be seen i'am using 4 variables (dichotome)
and I want the 'neen' (=no in English) to disappear.
Selecting the syntax till the modify command results in a table
               
<http://spssx-discussion.1045642.n5.nabble.com/file/t339604/tabel.jpg>

When the spss modify command is used, the neen are gone, but exporting the
file results in two hidden variables as can be seen in this uploaded file.
spssx-file.xls
<http://spssx-discussion.1045642.n5.nabble.com/file/t339604/spssx-file.xls>  


thanks in advance for any help
Nico




**************
CTABLES
/FORMAT EMPTY='        ***' MISSING='.'
  /SMISSING VARIABLE
  /VLABELS VARIABLES=V17_4R V17_5R V17_6R V17_7R          DISPLAY=NONE
/VLABELS VARIABLES=vcomp2
    DISPLAY=none
  /TABLE  V17_4R [C] + V17_5R [C] + V17_6R [C] + V17_7R [C]         by
vcomp2 [C][COLPCT.COUNT PCT40.1]
  /CATEGORIES VARIABLES=V17_4R V17_5R V17_6R V17_7R          [1, 2, OTHERNM]
EMPTY=EXCLUDE
  /CATEGORIES VARIABLES=vcomp2 ORDER=A KEY=VALUE EMPTY=INCLUDE
 /SLABELS POSITION=column VISIBLE=NO.
SPSSINC MODIFY TABLES subtype="Custom Table"
SELECT=neen
DIMENSION= ROWS
LEVEL =-1  PROCESS = ALL HIDE=TRUE
/STYLES  APPLYTO=DATACELLS.
OUTPUT EXPORT
/XLS DOCUMENTFILE= ' C:\spss_18\tabel\woonmob_vcomp.xls' .
  OUTPUT CLOSE *.
*****



--
Sent from: http://spssx-discussion.1045642.n5.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

[Jon Peck]

The SPSSINC MODIFY TABLES extension can hide things but cannot actually delete them, because there is no api for that available.  The problem is the way these are treated in the xls export, which mangles the table after the rows are hidden.

However, if you export the table as xlsx instead of xls, the resulting file should be correct.  The xls and xlsx file structures are very different.

On Fri, Mar 16, 2018 at 5:29 AM, NicoDW <[hidden email]> wrote:

Hello,

i a experiencing a problems with SPSSINC MODIFY TABLES or Output export.
The syntax I use is below. As can be seen i'am using 4 variables (dichotome)
and I want the 'neen' (=no in English) to disappear.
Selecting the syntax till the modify command results in a table

<http://spssx-discussion.1045642.n5.nabble.com/file/t339604/tabel.jpg>

When the spss modify command is used, the neen are gone, but exporting the
file results in two hidden variables as can be seen in this uploaded file.
spssx-file.xls
<http://spssx-discussion.1045642.n5.nabble.com/file/t339604/spssx-file.xls>


thanks in advance for any help
Nico




**************
CTABLES
/FORMAT EMPTY='        ***' MISSING='.'
  /SMISSING VARIABLE
  /VLABELS VARIABLES=V17_4R V17_5R V17_6R V17_7R          DISPLAY=NONE
/VLABELS VARIABLES=vcomp2
    DISPLAY=none
  /TABLE  V17_4R [C] + V17_5R [C] + V17_6R [C] + V17_7R [C]         by
vcomp2 [C][COLPCT.COUNT PCT40.1]
  /CATEGORIES VARIABLES=V17_4R V17_5R V17_6R V17_7R          [1, 2, OTHERNM]
EMPTY=EXCLUDE
  /CATEGORIES VARIABLES=vcomp2 ORDER=A KEY=VALUE EMPTY=INCLUDE
 /SLABELS POSITION=column VISIBLE=NO.
SPSSINC MODIFY TABLES subtype="Custom Table"
SELECT=neen
DIMENSION= ROWS
LEVEL =-1  PROCESS = ALL HIDE=TRUE
/STYLES  APPLYTO=DATACELLS.
OUTPUT EXPORT
/XLS DOCUMENTFILE= ' C:\spss_18\tabel\woonmob_vcomp.xls' .
        OUTPUT CLOSE *.
*****



--
Sent from: http://spssx-discussion.1045642.n5.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

[NicoDW]

Thanks Jon, I'll give it a try



--
Sent from: http://spssx-discussion.1045642.n5.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