Don't know why your code that runs in base wouldn't run in EG. However, the following should work in both:
data have; input dt datetime18.; format dt datetime18.; cards; 16JUN16:10:30:55 ; proc format library=work; picture Exceldt (default=22) low-high = '%0m/%0d/%Y %h:%0M:%0S %p' (datatype=datetime); run; data want; set have; char_dt=put(dt,Exceldt.); run;
Art, CEO, AnalystFinder.com
Don't know why your code that runs in base wouldn't run in EG. However, the following should work in both:
data have; input dt datetime18.; format dt datetime18.; cards; 16JUN16:10:30:55 ; proc format library=work; picture Exceldt (default=22) low-high = '%0m/%0d/%Y %h:%0M:%0S %p' (datatype=datetime); run; data want; set have; char_dt=put(dt,Exceldt.); run;
Art, CEO, AnalystFinder.com
this should do
proc format;
picture mydate other='%0m/%0d/%0Y %0H:%0M:%0S %p' (datatype=datetime);
run;
data a;
a= '16JUN16:10:30:55';
b= input(a, datetime.);
format b mydate.;
run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.