SAS Formats

[zimcom]

HelIo conmmunity,

I received an data export from clincal trial database and there are 50 datasets and 1 formats SAS Catalog, I assume the formats catalog contains all the formats used in the datasets. But before I use the formats, what I should do.

If I start the code in below:  

libname test 'C:\Users\test'; 

data ae; set test.ae;
run; 

the log will have a few error like below:

...........................................................

ERROR: The format CAETOXGR was not found or could not be loaded.
ERROR: The format $CAEREL was not found or could not be loaded.
ERROR: The format $CAECN was not found or could not be loaded.

[SASKiwi · Accepted solution]

Assuming your SAS format catalog is in the same folder / library try this after your LIBNAME statement:

options fmtsearch = (WORK, TEST, LIBRARY);

SAS will search for formats in the libraries in the order listed.