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.   ... View more

Hi Iam running below code and iam getting error.please have a look and kindly help   proc sql; create table work.W5WITF2 as select (case when Sign='C' then input(Amt,11)/100 when Sign='D' then (input(Amt,11)/100)*-1 else end) as Amt length = 8 format = 11.2 informat = 11.2 label = 'Amt', (case when sign1='C' then input(Amt1 ,11)/100 when sign1='D' then (input(Amt1 ,11)/100)*-1 else end) as Amt1 length = 8 format = 11.2 informat = 11.2 label = 'Amt1', Sign, sign1 from test ; quit; (case 595 when Sign='C' 596 then input(Amt,11)/100 __ 22 76 ERROR 22-322: Syntax error, expecting one of the following: a format name, ?. ERROR 76-322: Syntax error, statement will be ignored.   ... View more