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.
The Z. formats are used for displaying leading zeroes; when inputting, they are not needed and therefore not available. Use 2. and 4. instead.
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
The Z. formats are used for displaying leading zeroes; when inputting, they are not needed and therefore not available. Use 2. and 4. instead.
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.
To give you moral support, I've tried to use Z as an informat a few times. 😞
Tom
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
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.