Hi all,
In one of the tables I refer to, the date appears as 31MAR2012:00:00:00.
How do I drop the time component of this and get the date as '31MAR2012'?
Thank you
If the field is already a SAS date_time field, then you only have to refer to it with a function, namely:
date_you_want=datepart(whateverthedatetimefieldiscalled);
You also may want to add a format statement of the nature:
format date_you_want date9.
Of course, if the field is really only a string in a character variable, you would first have to input it using a datetime informat.
If the field is already a SAS date_time field, then you only have to refer to it with a function, namely:
date_you_want=datepart(whateverthedatetimefieldiscalled);
You also may want to add a format statement of the nature:
format date_you_want date9.
Of course, if the field is really only a string in a character variable, you would first have to input it using a datetime informat.
thank you Art, it worked. much appreciated.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.