OUTPUT MODIFY SELECT ALL EXCEPT problem

[Mario Giesel]

* Hi, SPSS friends, I'm investigating this new OUTPUT MODIFY command;
I want to delete all objects from the viewer except for tables (e.g. CTABLES command)
in order to export only tables afterwards;
The recommended command from the syntax reference doesn't seem to work as expected.

DATA LIST /SEX 1 AGE 3.
BEGIN DATA
1 1
1 2
2 1
2 2
END DATA.
VALUE LABELS SEX 1 'Male' 2 'Female'
   /AGE 1 'Young' 2 'Old'.
FREQUENCIES SEX AGE.
CTABLES /TABLE SEX BY AGE.

* Syntax Reference: "In this example, all output objects except pivot tables are deleted from the Viewer".
OUTPUT MODIFY
/SELECT ALL EXCEPT (TABLES)
/DELETEOBJECT DELETE = YES.

* Result: Empty viewer?! Where did I go wrong? Any help is appreciated :-).

===================== 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

[Jignesh Sutar]

Hi Mario,

An alternative approach (which you'll probably find to be more efficient/quicker processing) is to simply capture and export the relevant tables directly using OMS. Find demo below:

DATA LIST /SEX 1 AGE 3.
BEGIN DATA
1 1
1 2
2 1
2 2
END DATA.
VALUE LABELS
 /SEX 1 'Male' 2 'Female'.
 
/AGE 1 'Young' 2 'Old'.

oms
 /select all
 /if commands=['ctables'] subtypes=['custom table']
 /destination format=xlsx
  outfile='C:\Temp\test.xlsx'
 /tag='CTxlsExport'.

FREQUENCIES SEX AGE.
CTABLES /TABLE SEX BY AGE.

omsend.

HTH,

Jignesh

On 28 July 2014 15:31, Mario Giesel <[hidden email]> wrote:

DATA LIST /SEX 1 AGE 3.
BEGIN DATA
1 1
1 2
2 1
2 2
END DATA.
VALUE LABELS SEX 1 'Male' 2 'Female'
   /AGE 1 'Young' 2 'Old'.
FREQUENCIES SEX AGE.
CTABLES /TABLE SEX BY AGE.

===================== 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

[Jignesh Sutar]

...I've assumed you are wanting to export to Excel but if instead you are simply wanting to exclude from viewer then that too can be achieved using the appropriate OMS settings.

On 28 July 2014 15:49, Jignesh Sutar <[hidden email]> wrote:

Hi Mario,

An alternative approach (which you'll probably find to be more efficient/quicker processing) is to simply capture and export the relevant tables directly using OMS. Find demo below:

DATA LIST /SEX 1 AGE 3.
BEGIN DATA
1 1
1 2
2 1
2 2
END DATA.
VALUE LABELS

 /SEX 1 'Male' 2 'Female'.

 
/AGE 1 'Young' 2 'Old'.

oms
 /select all
 /if commands=['ctables'] subtypes=['custom table']
 /destination format=xlsx
  outfile='C:\Temp\test.xlsx'
 /tag='CTxlsExport'.

FREQUENCIES SEX AGE.
CTABLES /TABLE SEX BY AGE.

omsend.

HTH,

Jignesh

On 28 July 2014 15:31, Mario Giesel <[hidden email]> wrote:

DATA LIST /SEX 1 AGE 3.
BEGIN DATA
1 1
1 2
2 1
2 2
END DATA.
VALUE LABELS SEX 1 'Male' 2 'Female'
   /AGE 1 'Young' 2 'Old'.
FREQUENCIES SEX AGE.
CTABLES /TABLE SEX BY AGE.

===================== 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

[Mario Giesel]

Thanks, Jignesh.

The problem with OMS is it ignores modifications I've done with OUTPUT MODIFY like column coloring or tables indexing.

I'd really like to solve this problem with OUTPUT MODIFY, therefore.

Thanks.

  Mario

Jignesh Sutar <[hidden email]> schrieb am 16:55 Montag, 28.Juli 2014:

...I've assumed you are wanting to export to Excel but if instead you are simply wanting to exclude from viewer then that too can be achieved using the appropriate OMS settings.

On 28 July 2014 15:49, Jignesh Sutar <[hidden email]> wrote:

Hi Mario,

An alternative approach (which you'll probably find to be more efficient/quicker processing) is to simply capture and export the relevant tables directly using OMS. Find demo below:

DATA LIST /SEX 1 AGE 3.
BEGIN DATA
1 1
1 2
2 1
2 2
END DATA.
VALUE LABELS

 /SEX 1 'Male' 2 'Female'.

 
/AGE 1 'Young' 2 'Old'.

oms
 /select all
 /if commands=['ctables'] subtypes=['custom table']
 /destination format=xlsx
  outfile='C:\Temp\test.xlsx'
 /tag='CTxlsExport'.

FREQUENCIES SEX AGE.
CTABLES /TABLE SEX BY AGE.

omsend.

HTH,

Jignesh

On 28 July 2014 15:31, Mario Giesel <[hidden email]> wrote:

DATA LIST /SEX 1 AGE 3.
BEGIN DATA
1 1
1 2
2 1
2 2
END DATA.
VALUE LABELS SEX 1 'Male' 2 'Female'
   /AGE 1 'Young' 2 'Old'.
FREQUENCIES SEX AGE.
CTABLES /TABLE SEX BY AGE.

===================== 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

[Jignesh Sutar]

OMS approach would still work as you would be supressing all tables except CTABLES. And then any modifications you would be doing would all be on the CTABLES anyway, the tables you have chose to leave visible.

On 28 July 2014 16:02, Mario Giesel <[hidden email]> wrote:

Thanks, Jignesh.

The problem with OMS is it ignores modifications I've done with OUTPUT MODIFY like column coloring or tables indexing.

I'd really like to solve this problem with OUTPUT MODIFY, therefore.

Thanks.

  Mario

Jignesh Sutar <[hidden email]> schrieb am 16:55 Montag, 28.Juli 2014:

...I've assumed you are wanting to export to Excel but if instead you are simply wanting to exclude from viewer then that too can be achieved using the appropriate OMS settings.

On 28 July 2014 15:49, Jignesh Sutar <[hidden email]> wrote:

Hi Mario,

An alternative approach (which you'll probably find to be more efficient/quicker processing) is to simply capture and export the relevant tables directly using OMS. Find demo below:

DATA LIST /SEX 1 AGE 3.
BEGIN DATA
1 1
1 2
2 1
2 2
END DATA.
VALUE LABELS

 /SEX 1 'Male' 2 'Female'.

 
/AGE 1 'Young' 2 'Old'.

oms
 /select all
 /if commands=['ctables'] subtypes=['custom table']
 /destination format=xlsx
  outfile='C:\Temp\test.xlsx'
 /tag='CTxlsExport'.

FREQUENCIES SEX AGE.
CTABLES /TABLE SEX BY AGE.

omsend.

HTH,

Jignesh

On 28 July 2014 15:31, Mario Giesel <[hidden email]> wrote:

DATA LIST /SEX 1 AGE 3.
BEGIN DATA
1 1
1 2
2 1
2 2
END DATA.
VALUE LABELS SEX 1 'Male' 2 'Female'
   /AGE 1 'Young' 2 'Old'.
FREQUENCIES SEX AGE.
CTABLES /TABLE SEX BY AGE.

===================== 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