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?
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.
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.
Thanks - very helpful!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: