🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 01-30-2021 09:05 AM
(692 views)
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 |
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thnak you su much, you have been always so helpful!!!