Hi,
I have date variable values as below
2018-02-26T10:05
I want to convert them to numeric datetime variable. Can anyone provide me the code.
Thanks,
Adi
data sample;
format datetime_var datetime.;
myvar='2018-02-26T10:05';
new=scan(myvar,1,'T')||''||scan(myvar,2,'T');
datetime_var=input(new,anydtdtm.);
run;
data sample;
format datetime_var datetime.;
myvar='2018-02-26T10:05';
new=scan(myvar,1,'T')||''||scan(myvar,2,'T');
datetime_var=input(new,anydtdtm.);
run;
There is an informat (actually several) designed to read ISO dates and datetimes.
data example; x="2018-02-26T10:05"; y=input(x,E8601DT.); format y datetime18.; run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.