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;
data want;
Period=input(catx(':',put(input("&period", yymmn6.),date9.),'00:00:00'), datetime.);
format period datetime20.;
run;
data want;
Period=input(catx(':',put(input("&period", yymmn6.),date9.),'00:00:00'), datetime.);
format period datetime20.;
run;
&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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.