Finding a dataset

[deleted_user]

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.

[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.

[Doc_Duke]

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.