How to check what data sets locate in a SAS library

[Mike_Davis]

Hi guys

Could anyone tell me how to check what datasets located in a SAS folder such as WORK or sashelp.

I want to see the whole list of all dataset's names in sashelp folder

Thanks

[art297]

It's pretty easy with a proc sql call, however it won't work unless the libname is in CAPS.

proc sql;

  select memname

    from dictionary.tables

      where libname="SASHELP"

  ;

quit;

[Ksharp]

Arthur,

I think using MEMBERS table is pretty faster than TABLES table.

proc sql;

  select memname

    from dictionary.members

      where libname="SASHELP"

  ;

quit;

Ksharp

[Reeza]

And if you just want to see it, check the log.

proc datasets library=sashelp;

run;

[Tom]

Why not use proc contents?  proc contents data=sashelp._all_; run;

Are you running SAS interactively?  Then use the DIR command.  DIR WORK or DIR SASHELP will pop up a list of the files in a library.

[econ]

add the nods option to just get the list. you can also out= it to get a table.

proc contents data=sashelp._all_ nods; run;