topic Re: Converting Dates SAS PROC SQL in SAS Enterprise Guide

Converting Dates SAS PROC SQL

itshere — Fri, 23 Sep 2016 18:13:27 GMT

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!!!!

JediApprentice — Fri, 23 Sep 2016 18:49:56 GMT

You will need to do something like this:

PROC SQL;
  CREATE TABLE Want AS
  SELECT PUT(datepart(Date1),DATETIME20.) as Date1
  FROM have;
QUIT;

ballardw — Fri, 23 Sep 2016 19:07:23 GMT

input(date1,anydtdtm32.) as DatetimeVar format=datetime20.