topic Re: MPRINT(ETLS_LOADER): Informat Z was not found or could not be loaded in SAS Data Management

MPRINT(ETLS_LOADER): Informat Z was not found or could not be loaded

JJP1 — Wed, 27 Nov 2019 13:44:24 GMT

Hi ,Iam running SAS DI job,job got completed successfully with desired output.but log is showing below notes.
i just want to understand why it is getting generated below motes like "Informat Z was not found or could not be loaded.".
it is giving me impression like something is wrong with year and month formats/informats.please help.

NOTE: Line generated by the invoked macro "ETLS_LOADER".
366      ! Year length = 8          format = z4.          informat = z4.          label = 'Year';        attrib
                                                                               ___
                                                                               485
366      ! Month length = 8
NOTE 485-185: Informat Z was not found or could not be loaded.

MPRINT(ETLS_LOADER):   attrib Year length = 8 format = z4. informat = z4. label = 'Year';
NOTE: Line generated by the invoked macro "ETLS_LOADER".
366                  format = z2.          informat = z2.          label = 'Month';        call missing(of _all_);
                                                      ___
                                                      485
366      ! stop;    run;        %rcSet(&syserr);
MPRINT(ETLS_LOADER):   attrib Month length = 8 format = z2. informat = z2. label = 'Month';
MPRINT(ETLS_LOADER):   call missing(of _all_);
MPRINT(ETLS_LOADER):   stop;
MPRINT(ETLS_LOADER):   run;

NOTE 485-185: Informat Z was not found or could not be loaded.

Re: MPRINT(ETLS_LOADER): Informat Z was not found or could not be loaded

MichaelLarsen — Wed, 27 Nov 2019 14:15:59 GMT

That is because the Z format only exist as a format not as an informat.

Re: MPRINT(ETLS_LOADER): Informat Z was not found or could not be loaded

Kurt_Bremser — Wed, 27 Nov 2019 14:18:11 GMT

The Z. formats are used for displaying leading zeroes; when inputting, they are not needed and therefore not available. Use 2. and 4. instead.

Re: MPRINT(ETLS_LOADER): Informat Z was not found or could not be loaded

Tom — Wed, 27 Nov 2019 14:32:56 GMT

What is this macro you are calling? Why is it trying to use a FORMAT as if it was an INFORMAT?

Probably it is writing that code from some input you gave it. If you cannot fix the macro to know the difference between an informat and a format you might need to fix the input you are giving the macro.

Re: MPRINT(ETLS_LOADER): Informat Z was not found or could not be loaded

TomKari — Wed, 27 Nov 2019 21:11:14 GMT

To give you moral support, I've tried to use Z as an informat a few times. 😞

Tom

Re: MPRINT(ETLS_LOADER): Informat Z was not found or could not be loaded

JJP1 — Thu, 28 Nov 2019 02:40:18 GMT

Thanks. Would you please suggest can I remove z informat value ? To avoid
this notes. Or no need to worry on this please. Please suggest

Re: MPRINT(ETLS_LOADER): Informat Z was not found or could not be loaded

Kurt_Bremser — Thu, 28 Nov 2019 06:18:22 GMT

AFAIK, DI Studio generates code out of metadata, so you need to make the corrections there.

@JJP1 wrote:
Thanks. Would you please suggest can I remove z informat value ? To avoid
this notes. Or no need to worry on this please. Please suggest

Re: MPRINT(ETLS_LOADER): Informat Z was not found or could not be loaded

JackHamilton — Mon, 02 Dec 2019 17:09:04 GMT

If correcting whatever generates the Z. informat is difficult, you could just create a Z. informat from the best. format. You'll have to experiment to find the correct values for the width (but the values below might work). You could get fancy and create a more rigorous informat routine with PROC FCMP, but that's probably not necessary.

 69         data _null_;
 70             n = input('0123', z4.);
                                  ___
                                  485
 NOTE 485-185: Informat Z was not found or could not be loaded.
 
 71             putlog 'NOTE: ' n=z4.;
 72         run;
 
 NOTE: n=0123
 NOTE: DATA statement used (Total process time):
       real time           0.00 seconds       
 
 73         
 74         proc format;
 75             invalue z (default=12 min=1 max=40)
 76                 other = [best12.];
 NOTE: Informat Z has been output.
 77         run;
 
 NOTE: PROCEDURE FORMAT used (Total process time):
       real time           0.01 seconds
        
 78         
 79         data _null_;
 80             n = input('0123456789012345', z16.);
 81             putlog 'NOTE: ' n=z16.;
 82         run;
 
 NOTE: n=0123456789012345
 NOTE: DATA statement used (Total process time):
       real time           0.00 seconds