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;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!
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.