topic ERROR: The informat YYMMDDN8 was not found or could not be loaded. in SAS Programming

ERROR: The informat YYMMDDN8 was not found or could not be loaded.

samgautam007 — Fri, 11 May 2018 04:24:49 GMT

Dear Mentors,

I am running a piece of code vis shell script through putty which uses the below line:

INPUT(PUT(DATEPART(A1.Date), YYMMDD8.), YYMMDDN8.)

and I am getting error as below:

ERROR: The informat YYMMDDN was not found or could not be loaded.

However, when i ran the same code in SAS Studio, it runs smoothly.

Please help.

Thanks in Advance.

Sandeep

ChrisNZ — Fri, 11 May 2018 04:42:40 GMT

There is not YYMMDDN informat supplied by SAS.

Maybe is it a user-created informat that is available in one environment..

Either way just remove the n and your code should run fine.

SASKiwi — Fri, 11 May 2018 04:45:04 GMT

The PUT and INPUT functions appear to be redundant as DATEPART creates a SAS data to start with. Try this:

DATEPART(A1.Date) format = YYMMDD8.

ChrisNZ — Fri, 11 May 2018 04:52:52 GMT

@SASKiwi lol you are right. Time to go home!

SASKiwi — Fri, 11 May 2018 04:59:00 GMT

@ChrisNZ - too right. I'm out the door too!

samgautam007 — Fri, 11 May 2018 06:35:28 GMT

Thanks @ChrisNZ and @SASKiwi for your inputs.

I have executed below command:

data a;
z=input(put(today(),yymmddn8.),yymmddn8.);
run;

data b;
z=input(put(today(),yymmddn8.),yymmdd8.);
run;

proc sql;
create table c as
select *,input(put(today(),yymmddn8.),yymmddn8.) as v from a
;quit;

And I am surprised why Proc sql is not throwing error.

Your help is much appreciated.

Kurt_Bremser — Fri, 11 May 2018 06:44:34 GMT

data a;
z=today();
run;

data b;
z=today();
run;

proc sql;
create table c as
select *, today() as v from a
;
quit;

The whole put/input thing makes no sense, as it does not change values in any way.