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

[JJP1]

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.

[MichaelLarsen]

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

[JJP1]

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

[Kurt_Bremser]

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

---

[Kurt_Bremser · Accepted solution]

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

[Tom]

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.

[TomKari]

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

Tom

[JackHamilton]

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