Hi - PLEASE HELP!
my Date1 column is in the following format "2012-01-25 12:44:44.0" - [ FORMAT $28 ]
and I need to convert it to 25JAN2012:00:00:00 - [ FORMAT DATETIME20]
THANK You!!!!
You will need to do something like this:
PROC SQL;
CREATE TABLE Want AS
SELECT PUT(datepart(Date1),DATETIME20.) as Date1
FROM have;
QUIT;
input(date1,anydtdtm32.) as DatetimeVar format=datetime20.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.