topic Re: SAS Date and Time format in SAS Programming

SAS Date and Time format

zimcom — Sat, 30 Jan 2021 14:05:01 GMT

Greetings!

I want the date and time displayed as "2018-09-15T14:52:22" in my report and I found the foolowing code in SAS help, but when I tried the output still show up as "1852642342", not "2018-09-15T14:52:22".

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=leforinforref&docsetTarget=n03vr57gdozvean1klfaaa14c9c0.htm&locale=en#n15bfl5myitg9xn17h1i0ju8vseo

What do I missed??

data one;
mydt='15sep2018 14:52:22'dt;
put mydt e8601dt25.3;
run;

Value of mydtResult

1852642342

2018-09-15T14:52:22.000

Re: SAS Date and Time format

novinosrin — Sat, 30 Jan 2021 14:13:41 GMT

format mydt e8601dt25.3;

PUT statement writes to the LOG. However you need a format statement to display the formatted value in your output dataset. Hope this helps?

data one;
mydt='15sep2018 14:52:22'dt;
format mydt e8601dt25.3;
run;

Re: SAS Date and Time format

zimcom — Sat, 30 Jan 2021 14:18:19 GMT

Thnak you su much, you have been always so helpful!!!