List all dataset names in a library

[gzr2mz39]

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]

Look at querying sashelp.vtable or dictionary.table

OR

Proc contents

OR

Proc datasets

[esjackso · Accepted solution]

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.

EJ

[Tom]

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

libname = "SAPENG"