topic DateTimeStamp format in SAS Programming

DateTimeStamp format

laxmanpai — Thu, 28 Jan 2021 11:53:38 GMT

Hi,

I am having an input '05AUG2019:09:00:00.000000' which is to be formatted to

2019-08-05:09:00:00.000000

i am using below code to achieve this but it returns me "ERROR" in the column.

proc format ;

picture mdyhms other = '%Y-%0m-%0d %0H:%0M:%0S.000000' (datatype=datetime);

Re: DateTimeStamp format

Kurt_Bremser — Thu, 28 Jan 2021 11:58:32 GMT

Read with the DATETIME informat, and assign your display format:

proc format ;
picture mdyhms other = '%Y-%0m-%0d %0H:%0M:%0S.000000' (datatype=datetime);
run;

data test;
invar = '05AUG2019:09:00:00.000000';
outvar = input(invar,datetime25.);
format outvar mdyhms.;
run;

Re: DateTimeStamp format

PaigeMiller — Thu, 28 Jan 2021 12:02:12 GMT

So wait a minute here

@laxmanpai wrote:

I am having an input '05AUG2019:09:00:00.000000'

You have a character string that looks like 05AUG2019:09:00:00.00000? You can't format a character string that way. You'd have to convert it to numeric first. Then you should be able to use the E8601DTw.d format

But before I come up with code to do this, please confirm that you mean you really do have a character string.

Re: DateTimeStamp format

Ksharp — Thu, 28 Jan 2021 13:22:14 GMT

If it was
05AUG2019:09:00:00.999999
how to display this datetime ?

Re: DateTimeStamp format

laxmanpai — Fri, 29 Jan 2021 05:20:53 GMT

Hi,

The input is coming from Oracle Timestamp(6) column and i am reading it from SAS EG.

The Actual data is in format 3/19/2018 12:53:09.000000 PM

i want the data to be displayed as 2018-03-19 12:53:09.000000

If i dont use any format function it is being read as "Timestamp Not Recognized" while trying to load into Snowflake .