Here's a great, but longer and in depth, reference for dates and times in SAS https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354   @Ross12345 wrote: I never have an easy time converting dates in this language.   I imported a set of dates from an excel sheet that follow the form "2016/02/23 18:24:00" Once loaded they have the following properties: Type: Char Len: 27   I would like to convert them to a workable SAS date format (date9.). I tried a number of approaches without success - online resources aren't super helpful when it comes to SAS date formats.   Please advise           ... View more

Example of what actual data looks like, as in a few rows of values similar to what you would expect to see in the process. The values need not be actual, just show the behavior. And then describe using that example how to do the actual comparison that you need. Your descriptions don't really provide much to work with.   I am going to guess from the indirect description that a main challenge might be in getting a usable format. ... View more