DMW User Definied SAS Format Hits ERROR: Format $XYZ Could Not Be Loaded. The Default Format Will Be Used

(Doc ID 2149381.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.3 and later
Information in this document applies to any platform.

Goal

Why DMW is not recognizing User defined SAS formats? Kindly let us know whether DMW SAS uses FORMAT CATALOG.

As part of a project activity, loading SAS data set which has USER DEFINED format into DMW data model, but load is failing with the below messages:

ERROR: Format $ABC could not be loaded. The default format will be used.
ERROR: Format $DEF could not be loaded. The default format will be used.
ERROR: Format $GHI could not be loaded. The default format will be used.
ERROR: Format $JKL could not be loaded. The default format will be used.
ERROR: Format $MNO could not be loaded. The default format will be used.
....
ERROR: Format $XYZ could not be loaded. The default format will be used.


Converted ODM XML files into SAS data sets using FORMAT CATALOG's so these are the Valid files.

Does DMW SAS uses FORMAT CATALOG?
 

Solution

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