JR38811: SAS Enterprise operator reads DATES AS NULL ON 64 BIT PLATFORMs.

APAR status

• Closed as program error.

Error description

• While reading date fields in SAS datasets using the SAS
  Enterprise operator, the dates are being read as NULL, when the
  field is defined to be nullable. When the field is defined as
  non-nullable, then the job is failing with the import error.
  This problem is seen only on 64 bit platforms, whereas, when the
  same job is run on a 32 bit platform, the dates are being
  retrieved correctly.
  

Local fix

Problem summary

• The SAS dates are being read as NULL on 64 bit platforms. While
  reading date fields in SAS dataset using the SAS Enterprise
  operator, the dates are being read as NULL, when the field is
  defined to be nullable. When the field is defined
  as non-nullable, then the job is failing with the import error.
  This problem is seen only on 64 bit platforms, whereas, when the
  same job is run on a 32 bit platform, the dates are being
  retrieved correctly.
  

Problem conclusion

• After analyzing the code, it is observed that while reading the
  date values, there is an incorrect check which is causing the
  data to become null. Corrected the same address the problem.
  

Temporary fix

• Reading them as string and applying string to date
  transformation functions using a transformer stage.
  

Comments

APAR Information

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

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

Modules/Macros

• SAS
  

Fix information

• Fixed component name

  DSTAGE PCK FOR

• Fixed component ID

  5724Q5700

Applicable component levels

• R810 PSY

     UP