SAS Custom Format Setup Via Program Code Hits: "ERROR: The informat <XYZ> was not found or could not be loaded."
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.
LSH 2.4.6, 2.4.7
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
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