Help using Base SAS procedures

Finding a dataset

Reply
N/A
Posts: 0

Finding a dataset

Hi

I am having 20 libraries and in each library there are 200 datasets.I am having a Dataset names final_trans.Now how can i find that dataset as in which library it is.
N/A
Posts: 0

Re: Finding a dataset

Posted in reply to deleted_user
In your SAS session you have some dictionary's view that can help you.
In your case is necessary to use the view Sashelp.vstable that has this structure
libname and memname for example:

data wheretable;
set sashelp.vstable(where=(memname='FINAL_TRANS'));
call symput ('tellme',libname );
run;

Other view that can help you could be "Sashelp.VCOLUMN" where there are the same columns, but the view is bigger why there are all the columns for each tables, so the query is slower.
Trusted Advisor
Posts: 2,116

Re: Finding a dataset

Posted in reply to deleted_user
An addendum to sirius' response.

For it to work, all of the libraries need to be defined with LIBNAME statements in that SAS program or interactive session.
Ask a Question
Discussion stats
  • 2 replies
  • 123 views
  • 0 likes
  • 2 in conversation