topic Re: ERROR: The informat HHMM was not found or could not be loaded. Works on local but not server. in SAS Programming

ERROR: The informat HHMM was not found or could not be loaded. Works on local but not server.

DavidPhillips2 — Mon, 20 May 2019 14:09:26 GMT

I have a script that runs correctly in Enterprise Guide on my computer. However when I run the script overnight on a server it errors. With the block:

proc sql;

_33 The SAS System 05:28 Monday, May 20, 2019

1421

1422

1423 create table capacity_base as

1424

1425

1426 select academic_period, census_period, input(begin_time1,hhmm.) as time, COURSE_IDENTIFICATION, COURSE_REFERENCE_NUMBER,

1427 ACTUAL_ENROLLMENT, MAXIMUM_ENROLLMENT

1428 from odsstu.registration_course

1429 where census_period=&census and (academic_period>="&first_academic_period" and academic_period<="&last_academic_period")

1430 order by academic_period, COURSE_IDENTIFICATION, COURSE_REFERENCE_NUMBER;

ERROR: The informat HHMM was not found or could not be loaded.

It appears that when I run the block in Enterprise Guide that the script understands format hhmm. But when running the .sas script on the server, the server does not understand the format expression.

Re: ERROR: The informat HHMM was not found or could not be loaded. Works on local but not server.

PaigeMiller — Mon, 20 May 2019 14:11:58 GMT

There is no informat HHMM

The only informat of this type is HHMMSS

See: https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=allprodslang&docsetTarget=syntaxByType-informat.htm&locale=en#p0txgpjugj4th3n1g72pshdrw4zl

Re: ERROR: The informat HHMM was not found or could not be loaded. Works on local but not server.

DavidPhillips2 — Mon, 20 May 2019 14:14:56 GMT

Paige,

Looking at other posts it looks like the common solution is to add SS to the format. Any idea why an error or warning is not thrown with Enterprise Guide?

Re: ERROR: The informat HHMM was not found or could not be loaded. Works on local but not server.

PaigeMiller — Mon, 20 May 2019 14:16:38 GMT

@DavidPhillips2 wrote:

Looking at other posts it looks like the common solution is to add SS to the format. Any idea why an error or warning is not thrown with Enterprise Guide?

No idea at all.