Thanks @PaigeMiller. Code is as above in my first post, which did not work, and then I tried the code from from @PGStats sans the first datastep, and changing only the table and variable name in the second to point to my table. here are some of the observations in that variable (March 1rst): 01/03/2020 00:00:00,000 01/03/2020 00:00:01,000 01/03/2020 00:00:02,000 01/03/2020 00:00:03,000 01/03/2020 00:00:04,000 01/03/2020 00:00:05,000 01/03/2020 00:00:06,000 01/03/2020 00:00:07,000 01/03/2020 00:00:08,000 01/03/2020 00:00:09,000 01/03/2020 00:00:10,000 Thanks @DavePrinsloo I will look further at the 8601 formats. my table is from a colleague in the EU.
... View more