IBM Support

PI68084: TEXT IMPORT WIZARD IS A STICKLER FOR DETAIL RE: DATES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You are reading DATE11  (e.g. 24-June-2011) data from text.
    However, your actual data values do not match this format
    exactly (e.g. 24 June 2011).  Statistics 24.0 is dropping these
    values and storing the system missing value ($sysmis) instead.
    
    To workaround this problem, read the field as a string, then
    restructure it to include hyphens, then change its type from
    string (A11) to a date (DATE11).
    
    * For Example.
    LOOP #i = 1 to LENGTH(DateVar).
    IF (SUBSTR(dateVar,#i,1)=' ') SUBSTR(DateVar,#i,1)='-'.
    END LOOP.
    EXECUTE.
    ALTER TYPE DateVar (DATE11).
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of the IBM SPSS Statistics 24.0  Text Import Wizard    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You are reading DATE11  (e.g. 24-June-2011) data from text.  *
    * However, your actual data values do not match this format    *
    * exactly (e.g. 24 June 2011).  Statistics 24.0 is dropping    *
    * these                                                        *
    * values and storing the system missing value ($sysmis)        *
    * instead.                                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please upgrade to IBM SPSS Statistics 24.0 FP2               *
    ****************************************************************
    

Problem conclusion

  • This issue is resolved for IBM SPSS Statistics 24.0 FP2
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI68084

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    O00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-08-24

  • Closed date

    2017-05-17

  • Last modified date

    2017-05-17

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

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

Fix information

  • Fixed component name

    SPSS STATISTICS

  • Fixed component ID

    5725A54ST

Applicable component levels

  • RO00 PSN

       UP

  • RO00 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCQ88K","label":"Statistics Desktop"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"O00","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 May 2017