topic Re: How to check what data sets locate in a SAS library in SAS Procedures

How to check what data sets locate in a SAS library

Mike_Davis — Fri, 03 Aug 2012 21:54:26 GMT

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 — Fri, 03 Aug 2012 22:07:42 GMT

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;

Reeza — Fri, 03 Aug 2012 22:20:22 GMT

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

proc datasets library=sashelp;

run;

Tom — Sat, 04 Aug 2012 19:50:48 GMT

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 — Sat, 04 Aug 2012 21:19:04 GMT

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;

Ksharp — Mon, 06 Aug 2012 02:56:59 GMT

Arthur,

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

proc sql;

select memname

from dictionary.members

where libname="SASHELP"

;

quit;

Ksharp