topic Re: Finding a dataset in SAS Procedures

Finding a dataset

deleted_user — Thu, 03 Sep 2009 08:29:35 GMT

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.

Re: Finding a dataset

deleted_user — Thu, 03 Sep 2009 09:52:16 GMT

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.

Re: Finding a dataset

Doc_Duke — Thu, 03 Sep 2009 14:21:19 GMT

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.