https://communities.sas.com/t5/SAS-Programming/Checking-for-Date-formats-in-a-character-variable/m-p/536593#M147472 <P>I have a dataset where the Date Variable column is defined as a character and the dates are recorded in different formats - dd/mm/yyyy and also yyyy/mm/dd formats.</P><P>&nbsp;</P><P>I need to convert them to numeric dates for calculation purposes. Are there any built in SAS functions to check the date formats, so that I can use the right "format" in the input function based on the data?</P> Mon, 18 Feb 2019 21:50:24 GMT Abby19 2019-02-18T21:50:24Z https://communities.sas.com/t5/SAS-Programming/Checking-for-Date-formats-in-a-character-variable/m-p/536593#M147472 <P>I have a dataset where the Date Variable column is defined as a character and the dates are recorded in different formats - dd/mm/yyyy and also yyyy/mm/dd formats.</P><P>&nbsp;</P><P>I need to convert them to numeric dates for calculation purposes. Are there any built in SAS functions to check the date formats, so that I can use the right "format" in the input function based on the data?</P> Mon, 18 Feb 2019 21:50:24 GMT https://communities.sas.com/t5/SAS-Programming/Checking-for-Date-formats-in-a-character-variable/m-p/536593#M147472 Abby19 2019-02-18T21:50:24Z https://communities.sas.com/t5/SAS-Programming/Checking-for-Date-formats-in-a-character-variable/m-p/536602#M147475 <P>SAS provides relatively simple-to-use tools for this purpose.&nbsp; Take a look:</P> <P>&nbsp;</P> <P><A href="https://blogs.sas.com/content/iml/2016/11/11/anydtdte-informat-read-any-date-sas.html" target="_blank">https://blogs.sas.com/content/iml/2016/11/11/anydtdte-informat-read-any-date-sas.html</A></P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 18 Feb 2019 22:17:28 GMT https://communities.sas.com/t5/SAS-Programming/Checking-for-Date-formats-in-a-character-variable/m-p/536602#M147475 Astounding 2019-02-18T22:17:28Z