topic Re: SAS Formats in SAS Programming

SAS Formats

VVDR — Tue, 07 Sep 2021 09:15:19 GMT

Hi All,

I am getting below error while executing SAS DI job.

ERROR: The format calim_s was not found or could not be loaded.

Format catalog locatio is pointing to as below:

LIBNAME glfmt "/data/SASEnvironment/SASFormats/G_L";
options fmtsearch=(glfmt);

And, the same code executed without any errors earlier and there are no modifications in the code. Can you advise what am I missing here in terms of fixing the issue.

I have reloaded the formats from prod to dev ( assuming catalogue got corrupted) but still the same issue.

Thanks

Re: SAS Formats

PaigeMiller — Tue, 07 Sep 2021 11:25:21 GMT

From now on, please show us the entire log for this PROC or DATA step. Do NOT show us errors in the log without showing us the rest of the log for this PROC or DATA step.

Your format calim_s is not defined when you run this particular code. It doesn't matter that it was defined on an earlier run, somehow the format is not defined any longer and it must be defined for this run. We can't debug further since you didn't show us your code and your LOG.

Re: SAS Formats

Astounding — Tue, 07 Sep 2021 11:42:34 GMT

A likely possibility based on this description: the data has changed.

Take a look at which variable(s) use this format. Probably you will find a variable that used to be character in the old (working) data, but is now numeric in the current (nonworking) data.

Of course we can't tell why this happened. But this should start your path in the right direction.

Re: SAS Formats

tarheel13 — Tue, 07 Sep 2021 13:11:59 GMT

you can try options nofmterr to get rid of the error.