To get the latest dataset in the Library

[#1]

libname lib sqlsvr dsn=EIS schema=SYS user="username" password="password"  READBUFF=1000;

proc sql /*outobs=1*/ noprint;

create table a as select modify_date, NAME into :cif separated by ' '

from Libname.TABLES where NAME LIKE "table_name%" order by modify_date desc;

proc sort; by modify_date;

quit;

data _null_;

set a end=last;

if last;

call symput('outy',compress(name));

run;

Macro variable "OUTY" will contain the name of the latest dataset.