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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.