- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 07-15-2024 12:55 AM
(572 views)
Hi Team,
I am trying to convert the dates below to IS8601DA , but one date was not considering that one is in date9. format.
Thank you,
Raja.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I am trying to convert the dates below to IS8601DA
Are you trying to convert strings to SAS dates with a IS8601DA format?
If so:
data HAVE;
A='2014-05-01T05:01'; output;
A='2014-05-01 '; output;
A='12oct2014 '; output;
run;
data WANT;
set HAVE;
DATE=input(A,anydtdte10.);
format DATE date9.;
put DATE=;
run;
DATE=01MAY2014
DATE=01MAY2014
DATE=12OCT2014
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
What is your original data source?
Should the values be stored as dates only, as datetimes, or as separate date and time?