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

[DavidPhillips2]

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.

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.

[PaigeMiller · Accepted solution]

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=syn...

[DavidPhillips2]

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?

[PaigeMiller]

---

@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.