BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
gzr2mz39
Quartz | Level 8

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.

1 ACCEPTED SOLUTION

Accepted Solutions
esjackso
Quartz | Level 8

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

View solution in original post

3 REPLIES 3
Reeza
Super User

Look at querying sashelp.vtable or dictionary.table

OR

Proc contents

OR

Proc datasets

esjackso
Quartz | Level 8

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
Super User Tom
Super User

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

libname = "SAPENG"

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 36281 views
  • 1 like
  • 4 in conversation