IBM Support

PI39917: AMOS APPEARS NOT TO SEE VARIABLES IN EXCEL FILE, GIVES INCORRECT RESULTS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as user error.

Error description

  • You're running Amos on an Excel file where some variables have
    missing data. The model should be identified and there is
    nothing apparently wrong with the data, but Amos sometimes
    issues pop-up errors when trying to read the data and when
    fitting the saturated and independence models, and in all cases
    gives incorrect output indicating that certain variables are not
    observed.
    

Local fix

  • This problem has been observed when Excel files have 0 length
    strings in apparently empty cells. Amos treats these as valid
    string values rather than missing values. This is working as
    designed.
    You can remove the 0 length strings in Excel via the following
    steps and the file
    should then work properly in Amos.
    
    1. Open the spreadsheet in Excel.
    2. Press Ctrl-F. (The Find and Replace dialog opens)
    3. Make sure that the Find what: box is empty.
    4. Click the Find All button.
    5. Press Ctrl-A. (Notice that all the "empty" cells in the
    spreadsheet
    are now selected)
    6. Click the Close button. (Notice that the "empty" cells in the
    spreadsheet are still selected.)
    7. Press the Delete key once. (There is no visible change in the
    spreadsheet when you press the Delete key.)
    8. Save the modified spreadsheet.
    

Problem summary

Problem conclusion

Temporary fix

Comments

  • This problem has been observed when Excel files have 0 length
    strings in apparently empty cells. Amos treats these as valid
    string values rather than missing values. This is working as
    designed.
    You can remove the 0 length strings in Excel via the following
    steps and the file
    should then work properly in Amos.
    
    1. Open the spreadsheet in Excel.
    2. Press Ctrl-F. (The Find and Replace dialog opens)
    3. Make sure that the Find what: box is empty.
    4. Click the Find All button.
    5. Press Ctrl-A. (Notice that all the "empty" cells in the
    spreadsheet
    are now selected)
    6. Click the Close button. (Notice that the "empty" cells in the
    spreadsheet are still selected.)
    7. Press the Delete key once. (There is no visible change in the
    spreadsheet when you press the Delete key.)
    8. Save the modified spreadsheet.
    

APAR Information

  • APAR number

    PI39917

  • Reported component name

    SPSS AMOS

  • Reported component ID

    5725A60AM

  • Reported release

    L00

  • Status

    CLOSED USE

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-04-27

  • Closed date

    2016-03-22

  • Last modified date

    2016-03-22

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLVC7","label":"IBM SPSS Amos"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"21.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 March 2016