Help using Base SAS procedures

How to check what data sets locate in a SAS library

Reply
Regular Contributor
Posts: 222

How to check what data sets locate in a SAS library

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

PROC Star
Posts: 7,364

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

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;

Super User
Posts: 9,687

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

Arthur,

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

proc sql;

  select memname

    from dictionary.members

      where libname="SASHELP"

  ;

quit;

Ksharp

Super User
Posts: 17,905

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

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

proc datasets library=sashelp;

run;

Super User
Super User
Posts: 6,502

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

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.

Contributor
Posts: 42

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

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;

Ask a Question
Discussion stats
  • 5 replies
  • 247 views
  • 0 likes
  • 6 in conversation