SPSS Statistics

 View Only
Expand all | Collapse all

SPSSINC MODIFY TABLES and Excel Export

  • 1.  SPSSINC MODIFY TABLES and Excel Export

    Posted Fri October 20, 2023 07:26 AM

    Hello.

    I have a question about the SPSSINC MODIFY TABLES command and the export of a table edited with it into Excel.

    The aim was to hide the column "Gültige Nennungen (n)" in a table, which I solved with the following command line:

    SPSSINC MODIFY TABLES 
    SUBTYPE="Custom Table" 
    SELECT="Gültige Nennungen (n)"
    LEVEL = -1
    HIDE=TRUE .


    Unfortunately, when exporting to Excel, the column appears again in the table. This is despite the fact that I have selected the option "only visible elements" in the export settings.

    Does anyone have an idea how to export the edited table as it is? Or does anyone know another way to edit the table and then export it?

    Any advice would be appreciated. Thank you!
    Lisa



    ------------------------------
    ------
    ------------------------------


  • 2.  RE: SPSSINC MODIFY TABLES and Excel Export

    Posted Fri October 20, 2023 10:21 AM
    The "only visible" option applies to entire items, e.g., all visible tables.

    There was a bug in some older SPSS versions where the "hidden" property for table rows or columns was lost on the export, but it was fixed several releases ago.  I don't  recall whether it affected both xls and xlsx formats, so you might try the other.

    Also, the OUTPUT MODIFY extension command uses a different mechanism for hiding, so that might work better for you.


    --



    Original Message