topic Datetime from macro is giving wrong value in SAS Programming

Datetime from macro is giving wrong value

WorkingMan — Mon, 11 Feb 2019 01:53:44 GMT

Hi everyone. I am trying my script, to get "datetime" in the format of "201808" into datetime.

Here is the code:

  
%let period=201808;
Period=input(catx(':',put(&period, date9.),'00:00:00'), datetime.);

I am expecting to see the result of : 01Aug2018:00:00:00, in datetime format.

However, I am only getting the result of 13JUL2512:00:00:00

What could be wrong?

%let period=201808;

Data want;

Period=.;

run;

novinosrin — Mon, 11 Feb 2019 02:01:54 GMT

data want;
Period=input(catx(':',put(input("&period", yymmn6.),date9.),'00:00:00'), datetime.);
format period datetime20.;
run;

Kurt_Bremser — Mon, 11 Feb 2019 06:39:06 GMT

&period contains just a number. Interpreting that number as a SAS date value (what you do with

put(&period, date9.)

) renders a date that is 201808 days after 1960-01-01, which gives you that day in 2512.