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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.