Hi All, I have a date at the beginning of my code. %let crundate=161028; I need to use the above to return '28Oct2016' as a date and "28 October 2016" as a string and "oct2016" as a string and if possible the 1st and last day of the month (in this case October) I use this %let ssrundate=%substr(&crundate,1,4); to return '1610'. But I cant seem to get any other formats I want. The reason I need this, is that there a numerous sas files dropped into my folders and all have different naming conventions. Examples: FileAoct2016, FileB28Oct2016, FileC1610 (FileA, FileB ect are not the actual names, but the dates at the end are actual values). In addition I would like to use the 161028 to returns date values as mentioned above %StartofMonth = &crundate ( this would return 01Oct2016) atm I'm coding this as %let StartofMonth= "01Oct2016"d; %EndofMonth = &crundate ( this would return 31Oct2016) atm I'm coding this as %let StartofMonth= "31Oct2016"d; %Drundate= &crundate ( this would return oct16) atm I'm coding this as %let Drundate= oct16;
... View more