Hi All, Greetings. We have a scenario like, there is an external file with value as below. "January 27, 2020 10:55:00 AM" "January 27, 2019 12:23:00 PM" .... ... etc.. we need to validate this each time when we receive, whether this column has all values with same format (as mentioned above) or not. if not we need to flag them as error. this is the requirement along with many other with other variables. Question : So here, to convert above date values into sas date type, which date informat we can use . Please suggest. (I know WORDDATE20. will read when we have only date in words. But we need SAS informat, which converts into sas date format, when both date and time is present as mentioned above). Thanks in advance. Regards, Hari.
... View more