HI All,
I have dates like 2017-10-05T13:00 in $22 format i want to convert it in to CDISC is860 format how i can...?
You probably have to read it in using one of the ANYDTDTM formats to make it a numeric.
Then, all you have to do is apply the desired format ISO 8601 format
Yes I want to convert it into numeric ,presently it in $20. format I want to present it in E8601DT19.
data _null_;
length x $22 ;
x='2017-10-05T13:00';
value=input(x,e8601dt19.);
put value=datetime19.;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.