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".
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 |
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;
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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.