topic Re: self defined import format & later cannot open the file because informat was not found in SAS Programming

self defined import format & later cannot open the file because informat was not found

fengyuwuzu — Wed, 09 Mar 2016 20:57:27 GMT

I used a self defined important format to read ina time variable, but later when I tried to open the data set , I could not open it and got this info in the log:

Informat IMPORTDATETIME not found or couldn't be loaded for variable LOGIN_TIMESTAMP.

I re-run the format code when I imported it, and then I can open the data set. Is there a way to save the informat to overcome this issue?

Re: self defined import format & later cannot open the file because informat was not found

LinusH — Wed, 09 Mar 2016 21:12:30 GMT

Yes, store it in a permanent library. Point the fmtsearch global option to that libname.

Re: self defined import format & later cannot open the file because informat was not found

LinusH — Wed, 09 Mar 2016 21:14:46 GMT

If you created that informat just for the cause of importing the data, you don't have to store the variable with the informat specification. Either change your import code, or remove it from the data set using PROC DATASETS.

Re: self defined import format & later cannot open the file because informat was not found

fengyuwuzu — Wed, 09 Mar 2016 21:29:58 GMT

Thank you. I will look into proc datasets.

Re: self defined import format & later cannot open the file because informat was not found

ballardw — Wed, 09 Mar 2016 22:50:55 GMT

The SAS option treating that as an error and preventing use of the set is FMTERR.

If you use

Options nofmterr;

you will get a message in the log about the missing format but can do anything with the set that does not require use of the missing format.

I have that set as a persistent system option because of the occasional dataset I get from other folks with such things and access to the format may not be possible.