Thank you very much for the quick reply. max(substr(memname,1,9)) only returns the last table based on alphabetical order. Within my library, I have a table named tmp_ftm2010 and it returned tmp_ftm20. But I think we are getting closer to the solution with the use of dictionary.tables where libname = "FTM". Would it be possible to do something like (VBA like) in SAS or SQL : mydate = 0 For each tables in libname="FTM" if substr(memname,1,3) = "FTM" then if right(memname,1) = "T" then if substr(memname,4,6) > mydate then mydate = substr(memname,4,6) end if end if Next tables mytablename = "FTM" & mydate & "T" Hope you understand what I am trying to do. Thank you for your help and time
... View more