topic Re: Converting ISO date to date. format in SAS Programming

Converting ISO date to date. format

JulieB — Sun, 18 Jul 2021 23:32:18 GMT

I have a dataset with dates in E8601DA10. format. I looked this up and it seems it's an ISO date. I have not worked with this format before. I have a lot of data and need to search for rows with dates occurring in 2020 or 2021. Can anyone tell me how to search for dates in this range using the format I have, or help me convert to the more conventional date. format which I am more comfortable working with?

Re: Converting ISO date to date. format

ChrisNZ — Sun, 18 Jul 2021 23:45:41 GMT

A format only affects the way a value is displayed. The value remains the same.

If your value is a SAS date, you can use it as you are used to, regardless of the format applied. In your case, it looks like you should use the year() function.

Re: Converting ISO date to date. format

JulieB — Sun, 25 Jul 2021 15:50:17 GMT

Thanks - very helpful!