topic Re: List all dataset names in a library in SAS Procedures

List all dataset names in a library

gzr2mz39 — Thu, 12 Jun 2014 17:13:35 GMT

I'm trying to view a list of all dataset names in a library called SAPEng that begin with /BIC/ (the datasets were created in SAP).

Any ideas?

Thank you.

Reeza — Thu, 12 Jun 2014 17:57:53 GMT

Look at querying sashelp.vtable or dictionary.table

Proc contents

Proc datasets

esjackso — Thu, 12 Jun 2014 18:00:59 GMT

You should be able to use SQL and the sas dictionary tables to get what you want.

Proc sql;

select *

from sashelp.vmember

where libname = "SAPEng " and memname like "BIC%"

;

quit;

See if that helps.

Tom — Fri, 13 Jun 2014 21:07:11 GMT

Note that the value of LIBNAME will always be in uppercase in the dictionary tables. So you would need

libname = "SAPENG"