Hi,
I'd like to get the numeric version of '31DEC16:00:00:00'
I tried:
options yearcutoff=1950;
data null;
a='31DEC16:00:00:00'd;
put 'SAS datetime='a;
put 'formatted datetime='a datetime18.;
run;
That gave me 20819 and 01JAN60:05:46:59
Thanks.
As you are dealing with Datetime - you need define:
a='31DEC16:00:00:00'dt; ( instead a='31DEC16:00:00:00'd; )
As you are dealing with Datetime - you need define:
a='31DEC16:00:00:00'dt; ( instead a='31DEC16:00:00:00'd; )
Thanks for the quick response!
I left out the 't'.
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.