I currently receive a daily file with an odd naming format. The file name format is CFXTRN(9.5.2019), no extension. I need to change the name to CFXTRN0905. I use the code below to change the name which works great, except when it is a 1 digit day of the month, such as 9/5/2019. How can I update my code so that it works for 1 or 2 digit day of the month?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.