SAS Custom Format Setup Via Program Code Hits: "ERROR: The informat <XYZ> was not found or could not be loaded."

(Doc ID 2403525.1)

Last updated on MAY 25, 2018

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.7 and later
Information in this document applies to any platform.

Symptoms

 LSH 2.4.6, 2.4.7

CAVEAT: The behavior from this KM note just reproduces when SAS format is setup via Program execution (custom code).
If you are using the LSH SAS Adapter, this other document may help you better <NOTE:1970370.1> What are the SAS Column Format (Format Mask) Supported By LSH For Number, Varchar2, Date and Time?


In SAS, an informat is a specification for how raw data should be read. A format is a layout specification for how a variable should be printed or displayed. SAS contains many internal formats and informats, or user defined formats and informats can be constructed using PROC FORMAT.


ISSUE:  When source Table Descriptor of program has a custom DATE format, you cannot use the table as source Table Descriptor to another SAS program, because the program fails with incorrect informat error.

The issue can be reproduced at will with the following steps:

1. Create Program instance of type SAS with name "SAS Pgm"
2. Add below mentioned source code

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms