topic Re: Datasets in Library in SAS Programming

Datasets in Library

briani — Tue, 08 Jan 2013 19:57:23 GMT

What is the most efficient to create a dataset that has the names of all datasets in a given library?

Re: Datasets in Library

Reeza — Tue, 08 Jan 2013 20:00:53 GMT

Querying dictionary.tables

Re: Datasets in Library

ballardw — Tue, 08 Jan 2013 23:53:01 GMT

An example:

proc sql;

create table WorkDatasets as

select memname

from dictionary.tables

where libname='WORK'

;

QUIT;

Re: Datasets in Library

SASKiwi — Wed, 09 Jan 2013 01:49:24 GMT

Sometimes dictionary tables perform slowly because there are lots of libraries and tables and/or some libraries point to external databases. PROC DATASETS can be a lot faster. This example uses ODS to create a dataset CONTENTS containing a list of all tables in the WORK library.

proc datasets library = WORK nolist;

contents data = _ALL_ nods;

ods output members = contents (rename = (name = memname));

run;

ods output close;

quit;