using MODIFY TABLES

[Art Kendall]

I have been trying out the SPSSINC MODIFY TABLES command.

What I think I have learned is:
MODIFY TABLES applies to all the tables from a previous command;
MODIFY TABLES only applies to tables from an IMMEDIATELY previous valid command,
      there can be no valid command between e.g., FREQUENCIES  and MODIFY TABLES;
highlighting a table in the index and running the MODIFY TABLES syntax does not work;
highlighting FREQUENCIES in the index and running the MODIFY TABLES syntax does not work;
MODIFY TABLES cannot be applied to a .spv file read back in.

Below is some syntax that demonstrates what I did.

Is my experience with MODIFY TABLES the same as others on this list?


Art Kendall
Social Research Consultants

GET
  FILE='C:\Program Files\IBM\SPSS\Statistics\19\Samples\English\carpet.sav'.
DATASET NAME DataSet1 WINDOW=FRONT.

*----------.
* it appears that modify tables only applies to tables from IMMEDIATELY previous valid command.

FREQUENCIES VARIABLES= package brand
  /ORDER=ANALYSIS.
FREQUENCIES VARIABLES=brand price
  /ORDER=ANALYSIS.
FREQUENCIES VARIABLES= seal price
  /ORDER=ANALYSIS.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

*------------.
*It appears that no VALID procedure can be between FREQUENCIES and Modify Tables.

* with invalid and valid procedure between.
FREQUENCIES VARIABLES= package brand
  /ORDER=ANALYSIS.
nosuchprocedure.
descriptives variables=price.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

*with invalid procedure between.
FREQUENCIES VARIABLES=brand price
  /ORDER=ANALYSIS.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

===================== 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 K Peck]

See below.

Jon Peck
Senior Software Engineer, IBM
[hidden email]
312-651-3435



From:        Art Kendall <[hidden email]>
To:        [hidden email]
Date:        02/09/2011 08:22 AM
Subject:        [SPSSX-L] using MODIFY TABLES
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

I have been trying out the SPSSINC MODIFY TABLES command.

What I think I have learned is:
MODIFY TABLES applies to all the tables from a previous command;
>>>You can choose whether to apply it to the immediately preceding command or all commands with
PROCESS=PRECEDING or PROCESS=ALL.  The default is PROCESS=PRECEDING.
Logs and such ephemera are ignored regardless.  

MODIFY TABLES only applies to tables from an IMMEDIATELY previous valid command,
     there can be no valid command between e.g., FREQUENCIES  and MODIFY TABLES;
>>>Commands such as COMPUTE that are not procedures are ignored in figuring out what is preceding.

highlighting a table in the index and running the MODIFY TABLES syntax does not work;
>>>MODIFY TABLES is syntax and is unaware of any interactive selection.

highlighting FREQUENCIES in the index and running the MODIFY TABLES syntax does not work;
MODIFY TABLES cannot be applied to a .spv file read back in.
>>>MODIFY TABLES applies to whatever Viewer window is active.  Probably PROCESS=PRECEDING is not what you would want in that case.  The command works backward from the end of the Viewer contents.


Below is some syntax that demonstrates what I did.

Is my experience with MODIFY TABLES the same as others on this list?


Art Kendall
Social Research Consultants

GET
 FILE='C:\Program Files\IBM\SPSS\Statistics\19\Samples\English\carpet.sav'.
DATASET NAME DataSet1 WINDOW=FRONT.

*----------.
* it appears that modify tables only applies to tables from IMMEDIATELY previous valid command.

FREQUENCIES VARIABLES= package brand
 /ORDER=ANALYSIS.
FREQUENCIES VARIABLES=brand price
 /ORDER=ANALYSIS.
FREQUENCIES VARIABLES= seal price
 /ORDER=ANALYSIS.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

*------------.
*It appears that no VALID procedure can be between FREQUENCIES and Modify Tables.

* with invalid and valid procedure between.
FREQUENCIES VARIABLES= package brand
 /ORDER=ANALYSIS.
nosuchprocedure.
descriptives variables=price.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

*with invalid procedure between.
FREQUENCIES VARIABLES=brand price
 /ORDER=ANALYSIS.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

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

[Art Kendall]

Main lesson: read the help more carefully.

SPSSINC MODIFY TABLES subtype="Frequencies"
process = all
SELECT=-1 -2 HIDE=TRUE.

worked to remove the last two columns  in frequencies from all frequency commands.

With the "process = all"  specification it worked on pre-existing .spv files.

Art Kendall
Social research Consultants




On 2/9/2011 10:33 AM, Jon K Peck wrote:

See below.

Jon Peck
Senior Software Engineer, IBM
[hidden email]
312-651-3435



From:        Art Kendall [hidden email]
To:        [hidden email]
Date:        02/09/2011 08:22 AM
Subject:        [SPSSX-L] using MODIFY TABLES
Sent by:        "SPSSX(r) Discussion" [hidden email]

---

I have been trying out the SPSSINC MODIFY TABLES command.

What I think I have learned is:
MODIFY TABLES applies to all the tables from a previous command;
>>>You can choose whether to apply it to the immediately preceding command or all commands with
PROCESS=PRECEDING or PROCESS=ALL.  The default is PROCESS=PRECEDING.
Logs and such ephemera are ignored regardless.  

MODIFY TABLES only applies to tables from an IMMEDIATELY previous valid command,
     there can be no valid command between e.g., FREQUENCIES  and MODIFY TABLES;
>>>Commands such as COMPUTE that are not procedures are ignored in figuring out what is preceding.

highlighting a table in the index and running the MODIFY TABLES syntax does not work;
>>>MODIFY TABLES is syntax and is unaware of any interactive selection.

highlighting FREQUENCIES in the index and running the MODIFY TABLES syntax does not work;
MODIFY TABLES cannot be applied to a .spv file read back in.
>>>MODIFY TABLES applies to whatever Viewer window is active.  Probably PROCESS=PRECEDING is not what you would want in that case.  The command works backward from the end of the Viewer contents.


Below is some syntax that demonstrates what I did.

Is my experience with MODIFY TABLES the same as others on this list?


Art Kendall
Social Research Consultants

GET
 FILE='C:\Program Files\IBM\SPSS\Statistics\19\Samples\English\carpet.sav'.
DATASET NAME DataSet1 WINDOW=FRONT.

*----------.
* it appears that modify tables only applies to tables from IMMEDIATELY previous valid command.

FREQUENCIES VARIABLES= package brand
 /ORDER=ANALYSIS.
FREQUENCIES VARIABLES=brand price
 /ORDER=ANALYSIS.
FREQUENCIES VARIABLES= seal price
 /ORDER=ANALYSIS.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

*------------.
*It appears that no VALID procedure can be between FREQUENCIES and Modify Tables.

* with invalid and valid procedure between.
FREQUENCIES VARIABLES= package brand
 /ORDER=ANALYSIS.
nosuchprocedure.
descriptives variables=price.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

*with invalid procedure between.
FREQUENCIES VARIABLES=brand price
 /ORDER=ANALYSIS.
SPSSINC MODIFY TABLES subtype="Frequencies"
SELECT=-1 -2 HIDE=TRUE.

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