Dear,
For the following variable 'a', I need to use two informats to get the output I need. Is there any other format that can both OBS.
output needed;
b
01SEP17:15:10:00
04SEP17:00:00:00
Thank you.
data one;
input a $16.;
datalines;
2017-09-01T15:10
2017-09-04
;
data two;
set one;
b=input(a, anydtdtm.);
c=input(a,?? is8601dt.);
format b c datetime16.;
run;
Well, a simple conditional:
data one; input a $16.; datalines; 2017-09-01T15:10 2017-09-04 ; run; data two; set one; b=ifn(lengthn(a)=10,input(catx('T',a,"00:00"),e8601dt.),input(a,e8601dt.)); format b datetime.; run;
Its more or less the same thing however.
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.