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.
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?
SAS provides relatively simple-to-use tools for this purpose. Take a look:
https://blogs.sas.com/content/iml/2016/11/11/anydtdte-informat-read-any-date-sas.html
SAS provides relatively simple-to-use tools for this purpose. Take a look:
https://blogs.sas.com/content/iml/2016/11/11/anydtdte-informat-read-any-date-sas.html
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.