IBM Support

PH28875: EXPORTED EXCEL FILE IS EMPTY AFTER SPSS 27 WAS LAUNCHED VIA DOUBLE CLICK ON A SAV FILE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • You work with IBM SPSS Statistics 27 instaled on a windows 10 64
    bit machine. The program works just fine. However, you notice
    the below behavior:
    
    You open SPSS Statistics 27 via double click on a SAV file, for
    example Employee Data.sav:
    Go to C:\Program Files\IBM\SPSS\Statistics\27\Samples\English
    Double click on Employee Data.sav to open SPSS 27 with double
    click on a sav file.
    After SPSS 27 launched with the file, create the a custom table:
    Analyze - Tables - Custom tables
    Select gender as column variable and educational level as row
    variable. Click OK.
    Syntax:
    GET   FILE='C:\Program
    Files\IBM\SPSS\Statistics\27\Samples\English\Employee data.sav'.
    
    DATASET NAME DataSet1 WINDOW=FRONT.
    * Custom Tables.
    CTABLES
      /VLABELS VARIABLES=educ gender DISPLAY=LABEL
      /TABLE educ BY gender [COUNT F40.0]
      /CATEGORIES VARIABLES=educ gender ORDER=A KEY=VALUE
    EMPTY=INCLUDE MISSING=EXCLUDE
      /CRITERIA CILEVEL=95.
    
    On output viewer go to File - Export menu
    For objects to export select: "all visible"
    As document type select : Excel 2007 and Higher *.xlsx
    Define a output name and export location.
    Use all other default settings and just click OK
    After you exported the table open the exported Excel file in MS
    Excel
    You will see the exported Excel file is empty.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Statistics 27.0.0.0 and Statistics Subscription     *
    * exporting to Excel                                           *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Exported Excel file is empty after SPSS 27 was launched via  *
    * double click on a SAV file and a custom table is exported as *
    * XLSX file                                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This issue is resolved in IBM SPSS Statistics 27.0.1 and IBM *
    * SPSS Statistics Subscreiption November 2020 Update.  Please  *
    * update to IBM SPSS Statistics 27.0.1 or IBM SPSS Statistics  *
    * Subscription November 2020 Update at your earliest           *
    * convenience.                                                 *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PH28875

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    R00

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-08-27

  • Closed date

    2020-11-16

  • Last modified date

    2020-11-16

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"R00"}]

Document Information

Modified date:
17 November 2020