SPSS Statistics

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I have been working exclusively in Workbook mode since I discovered it, and it works really well for testing and retesting new sections of syntax without overclogging the viewer.  That said, I can't seem to get the Edit > Options > Viewer tab to do anything apparent.  And I'm not sure how to get to regular mode or perform SPSSINC MODIFY OUTPUT.  I only used OMS for a couple of the mixed models (of 6) to create their random effects data, so not sure if I'm in the cold on the other 4 models.

What I want is to be able to see what I currently see in the Workbook viewer as is (all titles, models, charts, tables), BUT only export to Excel just the TITLE, Mixed Model Analysis, Fixed Effects, and Covariance Parameter tables for each of 6 models and that's it.

What would be the best resource for learning this?  The videos I see don't seem to get to the automation level.

------------------------------
Mark Sloan
------------------------------

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Original Message:
Sent: 6/20/2024 2:23:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

I have been working exclusively in Workbook mode since I discovered it, and it works really well for testing and retesting new sections of syntax without overclogging the viewer.  That said, I can't seem to get the Edit > Options > Viewer tab to do anything apparent.  And I'm not sure how to get to regular mode or perform SPSSINC MODIFY OUTPUT.  I only used OMS for a couple of the mixed models (of 6) to create their random effects data, so not sure if I'm in the cold on the other 4 models.

What I want is to be able to see what I currently see in the Workbook viewer as is (all titles, models, charts, tables), BUT only export to Excel just the TITLE, Mixed Model Analysis, Fixed Effects, and Covariance Parameter tables for each of 6 models and that's it.

What would be the best resource for learning this?  The videos I see don't seem to get to the automation level.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Thank you.  I'll give it a shot tonight.  I just figured out how to find the OMS Command Identifier, OMS Subtype, and OMS Label for each item, which is very helpful. 

How should I get to regular mode from Workbook mode? Do I have to make changes in Edit > Options to "Classic"?  I normally work and test code in workbook mode because it "writes over" the mistakes so I don't get overwhelmed with the output.  My novice-ness is quickly coming out!

I have been working exclusively in Workbook mode since I discovered it, and it works really well for testing and retesting new sections of syntax without overclogging the viewer.  That said, I can't seem to get the Edit > Options > Viewer tab to do anything apparent.  And I'm not sure how to get to regular mode or perform SPSSINC MODIFY OUTPUT.  I only used OMS for a couple of the mixed models (of 6) to create their random effects data, so not sure if I'm in the cold on the other 4 models.

What I want is to be able to see what I currently see in the Workbook viewer as is (all titles, models, charts, tables), BUT only export to Excel just the TITLE, Mixed Model Analysis, Fixed Effects, and Covariance Parameter tables for each of 6 models and that's it.

What would be the best resource for learning this?  The videos I see don't seem to get to the automation level.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I tried MENU Utilities > Modify Output Titles, and got to this:

SPSSINC MODIFY OUTPUT MODELS TITLES 
/IF COMMAND="Mixed" 
ITEMTITLE= "execute" PROCESS=PRECEDING
/REPLACE ITEMS.

and then tried again:

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I tried MENU Utilities > Modify Output Titles, and got to this:

SPSSINC MODIFY OUTPUT MODELS TITLES 
/IF COMMAND="Mixed" 
ITEMTITLE= "execute" PROCESS=PRECEDING
/REPLACE ITEMS.

and then tried again:

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan
------------------------------

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

MODIFY OUTPUT in the Extension Hub = good to go

Utilities > Modify Output Titles = good to go

Retried this syntax, adjusted for my computer and output:

SPSSINC MODIFY OUTPUT TABLES
/IF SUBTYPE="'Descriptives'"
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS/mytable.xlsx')".

It briefly worked, but now I cannot get it to work again.  I tried adding additional /IF statements to see if I could add TABLES to the successful Excel file, but now nothing works.  I am also now having trouble with "cut-and-paste" from forum text to SPSS Syntax Editor...I've seen this trouble with SPSS' cut-and-paste abilities before.  It feels like past bugs are coming back, and I am using a fresh install of SPSS on my machine.  Previously I was using a server at the university and saw similar behaviors.  Is there some kind of a reset without closing out SPSS that might clear up some of these things?

Hit and miss success today.

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Thank you for the quick reply.  Floundering without this help.  I don't understand your last sentence.  What I want is to basically replicate most of the tables produced by the MIXED command (not all), and do this 6 times above each other on ONE Excel worksheet.  Basically this without writing over each other:

MODEL 1

'Model Dimension'

'Information Criteria'

'Intraclass Correlation Coefficients'

'Parameter Estimates'

'Covariance Parameter Estimates'

MODEL 2

(same as above)

MODEL 3 etc.

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Thank you for the quick reply.  Floundering without this help.  I don't understand your last sentence.  What I want is to basically replicate most of the tables produced by the MIXED command (not all), and do this 6 times above each other on ONE Excel worksheet.  Basically this without writing over each other:

MODEL 1

'Model Dimension'

'Information Criteria'

'Intraclass Correlation Coefficients'

'Parameter Estimates'

'Covariance Parameter Estimates'

MODEL 2

(same as above)

MODEL 3 etc.

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Thank you for the quick reply.  Floundering without this help.  I don't understand your last sentence.  What I want is to basically replicate most of the tables produced by the MIXED command (not all), and do this 6 times above each other on ONE Excel worksheet.  Basically this without writing over each other:

MODEL 1

'Model Dimension'

'Information Criteria'

'Intraclass Correlation Coefficients'

'Parameter Estimates'

'Covariance Parameter Estimates'

MODEL 2

(same as above)

MODEL 3 etc.

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I am so sorry, but this has me more confused.  Is there a good tutorial resource on how to build up an Excel sheet with multiple tables on it using SPSSINC MODIFY OUTPUT?  I've spend a lot of time on the web today trying to figure this out, and even reviewed a couple of help pdfs from SPSS, but nothing seems to address this adequately.

Thank you for the quick reply.  Floundering without this help.  I don't understand your last sentence.  What I want is to basically replicate most of the tables produced by the MIXED command (not all), and do this 6 times above each other on ONE Excel worksheet.  Basically this without writing over each other:

MODEL 1

'Model Dimension'

'Information Criteria'

'Intraclass Correlation Coefficients'

'Parameter Estimates'

'Covariance Parameter Estimates'

MODEL 2

(same as above)

MODEL 3 etc.

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Reading through again, I think you mean the following, attempting to adapt to my situation:

/CUSTOM FUNCTION="cutomoutputfunctions.excelexport (file='d:/spss/extest.xls, sheet='mixedmodels', action='ModifyWorksheet', location='OverwriteAtCellRef', startingCell='A50')"   <---no image format wanted

Is this the right idea?  I just keep using the same filename to add on more and more tables?

I am so sorry, but this has me more confused.  Is there a good tutorial resource on how to build up an Excel sheet with multiple tables on it using SPSSINC MODIFY OUTPUT?  I've spend a lot of time on the web today trying to figure this out, and even reviewed a couple of help pdfs from SPSS, but nothing seems to address this adequately.

Thank you for the quick reply.  Floundering without this help.  I don't understand your last sentence.  What I want is to basically replicate most of the tables produced by the MIXED command (not all), and do this 6 times above each other on ONE Excel worksheet.  Basically this without writing over each other:

MODEL 1

'Model Dimension'

'Information Criteria'

'Intraclass Correlation Coefficients'

'Parameter Estimates'

'Covariance Parameter Estimates'

MODEL 2

(same as above)

MODEL 3 etc.

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Reading through again, I think you mean the following, attempting to adapt to my situation:

/CUSTOM FUNCTION="cutomoutputfunctions.excelexport (file='d:/spss/extest.xls, sheet='mixedmodels', action='ModifyWorksheet', location='OverwriteAtCellRef', startingCell='A50')"   <---no image format wanted

Is this the right idea?  I just keep using the same filename to add on more and more tables?

I am so sorry, but this has me more confused.  Is there a good tutorial resource on how to build up an Excel sheet with multiple tables on it using SPSSINC MODIFY OUTPUT?  I've spend a lot of time on the web today trying to figure this out, and even reviewed a couple of help pdfs from SPSS, but nothing seems to address this adequately.

Thank you for the quick reply.  Floundering without this help.  I don't understand your last sentence.  What I want is to basically replicate most of the tables produced by the MIXED command (not all), and do this 6 times above each other on ONE Excel worksheet.  Basically this without writing over each other:

MODEL 1

'Model Dimension'

'Information Criteria'

'Intraclass Correlation Coefficients'

'Parameter Estimates'

'Covariance Parameter Estimates'

MODEL 2

(same as above)

MODEL 3 etc.

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

Reading through again, I think you mean the following, attempting to adapt to my situation:

/CUSTOM FUNCTION="cutomoutputfunctions.excelexport (file='d:/spss/extest.xls, sheet='mixedmodels', action='ModifyWorksheet', location='OverwriteAtCellRef', startingCell='A50')"   <---no image format wanted

Is this the right idea?  I just keep using the same filename to add on more and more tables?

I am so sorry, but this has me more confused.  Is there a good tutorial resource on how to build up an Excel sheet with multiple tables on it using SPSSINC MODIFY OUTPUT?  I've spend a lot of time on the web today trying to figure this out, and even reviewed a couple of help pdfs from SPSS, but nothing seems to address this adequately.

Thank you for the quick reply.  Floundering without this help.  I don't understand your last sentence.  What I want is to basically replicate most of the tables produced by the MIXED command (not all), and do this 6 times above each other on ONE Excel worksheet.  Basically this without writing over each other:

MODEL 1

'Model Dimension'

'Information Criteria'

'Intraclass Correlation Coefficients'

'Parameter Estimates'

'Covariance Parameter Estimates'

MODEL 2

(same as above)

MODEL 3 etc.

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I just tried to put 5 mixed tables on a sheet and 3 of them made it.  Two did not.  The startingCell control doesn't seem to work beyond the first table.  Also, the formatting of cells is a bit funky....earlier attempts had black fill in the cells.  I've attached an image of what Excel looks like, and the syntax that got there:

Reading through again, I think you mean the following, attempting to adapt to my situation:

/CUSTOM FUNCTION="cutomoutputfunctions.excelexport (file='d:/spss/extest.xls, sheet='mixedmodels', action='ModifyWorksheet', location='OverwriteAtCellRef', startingCell='A50')"   <---no image format wanted

Is this the right idea?  I just keep using the same filename to add on more and more tables?

I am so sorry, but this has me more confused.  Is there a good tutorial resource on how to build up an Excel sheet with multiple tables on it using SPSSINC MODIFY OUTPUT?  I've spend a lot of time on the web today trying to figure this out, and even reviewed a couple of help pdfs from SPSS, but nothing seems to address this adequately.

Thank you for the quick reply.  Floundering without this help.  I don't understand your last sentence.  What I want is to basically replicate most of the tables produced by the MIXED command (not all), and do this 6 times above each other on ONE Excel worksheet.  Basically this without writing over each other:

MODEL 1

'Model Dimension'

'Information Criteria'

'Intraclass Correlation Coefficients'

'Parameter Estimates'

'Covariance Parameter Estimates'

MODEL 2

(same as above)

MODEL 3 etc.

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------

I just tried to put 5 mixed tables on a sheet and 3 of them made it.  Two did not.  The startingCell control doesn't seem to work beyond the first table.  Also, the formatting of cells is a bit funky....earlier attempts had black fill in the cells.  I've attached an image of what Excel looks like, and the syntax that got there:

Reading through again, I think you mean the following, attempting to adapt to my situation:

/CUSTOM FUNCTION="cutomoutputfunctions.excelexport (file='d:/spss/extest.xls, sheet='mixedmodels', action='ModifyWorksheet', location='OverwriteAtCellRef', startingCell='A50')"   <---no image format wanted

Is this the right idea?  I just keep using the same filename to add on more and more tables?

I am so sorry, but this has me more confused.  Is there a good tutorial resource on how to build up an Excel sheet with multiple tables on it using SPSSINC MODIFY OUTPUT?  I've spend a lot of time on the web today trying to figure this out, and even reviewed a couple of help pdfs from SPSS, but nothing seems to address this adequately.

Thank you for the quick reply.  Floundering without this help.  I don't understand your last sentence.  What I want is to basically replicate most of the tables produced by the MIXED command (not all), and do this 6 times above each other on ONE Excel worksheet.  Basically this without writing over each other:

MODEL 1

'Model Dimension'

'Information Criteria'

'Intraclass Correlation Coefficients'

'Parameter Estimates'

'Covariance Parameter Estimates'

MODEL 2

(same as above)

MODEL 3 etc.

I think PRECEDING was the problem.  That said, I am trying to write multiple tables (Mixed model tables), but they are overwriting each other. I'm working to resolve, but if you catch this any help is appreciated.

After much testing, I am beginning to believe MODIFY OUTPUT only partially works, and it may be buggy.  I was able to consistently get "Descriptive Statistics" to save into an Excel file for a while, but now my working syntax no longer works.  I tried other object types/subtypes such as "Notes" (worked), and "Model Dimensions" from MIXED models (doesn't work).  After repeating syntax a few times, nothing works, not even the previously successful "Descriptive Statistics". 

I tried creating the syntax from the menu version, and while had an initial success, it also failed to save after a few tries.

I think this is the answer to what I need but I can't get it work consistently or properly.  I tried some of the other options, and was also unsuccessful.  If there are other options to send to Excel only certain tables and titles, it is greatly appreciated!

I was unfortunately unable to get anything to work tonight.  First, I used the Extensions > Extension Hub... to download all extensions related to the word search:  "SPSSINC".  I have many extensions now loaded to get the right one, but not sure which actually contains "SPSSINC MODIFY INPUT" or "customoutputfunctions.excelexport".

I also opened a new classic Syntax Editor, and ran this syntax:

show all.

I got the System Settings, License components, Versions, and System Variables, but unfortunately nothing that indicated if "SPSSINC MODIFY OUTPUT" or "customoutputfunctions.excelexport" were loaded.

When I ran the example Python extension, it would not save into the various folders I tried to save to.  The Output editor did not indicate there were any errors.

I think this is what I want, if I can just get it to work:

SPSSINC MODIFY OUTPUT MODELS TITLES
/IF SUBTYPE="'Mixed'"    <----or /IF COMMAND="'Mixed'"   ?
PROCESS=PRECEDING
/CUSTOM FUNCTION="customoutputfunctions.excelexport(file='d:/SPSS-RESULTS-REPOSITORY/mytable.xlsx')".

and to add in a subcommand for TITLES that contain the word "EXECUTE".

Should Mixed have both single and double quotes together?  Mixed is the OMS Command Identifier associated with all the tables of interest.  Any further ideas?  

BTW, I am running SPSS 29.

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 03:20 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 2:38:00 PM
From: Mark Sloan
Subject: RE: Controlling What gets Exported to Excel

It appears SPSSINC MODIFY INPUT is a Python code?  Would you have/know of any sample routines that might allow control over items to export to Excel?  The last sample routines were extremely helpful and I could not have proceeded without them. Thank you!

------------------------------
Mark Sloan

Original Message:
Sent: Thu June 20, 2024 01:46 PM
From: Jon Peck
Subject: Controlling What gets Exported to Excel

Original Message:
Sent: 6/20/2024 1:15:00 PM
From: Mark Sloan
Subject: Controlling What gets Exported to Excel

I have successfully developed a consolidated MIXED syntax that processes a series of models, creates graphs/plots to assess assumptions, and presents model output before and after removal of extreme outliers.  My next need is to export model-only output to EXCEL (3 before and 3 after MIXED models) with no extraneous tables or graphs.  To this end I am trying to use the WORKBOOK EXPORT function to control what gets exported to Excel:

* Export Workbook.
WORKBOOK EXPORT
  /CONTENTS  EXPORT=VISIBLE  LAYERS=VISIBLE  MODELVIEWS=VISIBLE
  /XLSM  DOCUMENTFILE='D:\SPSS-RESULTS\test-output-delete-later.xlsm'
     OPERATION=CREATESHEET
     LOCATION=LASTCOLUMN  NOTESCAPTIONS=YES.

Here is what I want to suppress: entire syntax up front (hide this), Notes, Model Descriptions, Graphs/Plots.  The above syntax successfully suppresses Notes and Model Descriptions, but not syntax (too long) and the graphs/plots.  Are their additional subcommands that do this, or is OMS the only way? 'Utilities > OMS Control Panel' appears to only produce XML output, and I need .xlsm-based output.  

An alternative is to manually-select each of the tables from each model: right-click "Export..." and select "Objects to Export > Selected" with Type > Excel...., and filename.  This roughly does what I am trying to do, but I need to automate this in syntax.

Thanks!

------------------------------
Mark Sloan
------------------------------