Checks whether a dataset OR a view exists. More...

Go to the source code of this file.

Detailed Description

Can be used in open code, eg as follows:

%if %mf_existds(libds=work.someview) %then %put  yes it does!;

NOTE - some databases have case sensitive tables, for instance POSTGRES with the preserve_tab_names=yes libname setting. This may impact expected results (depending on whether you 'expect' the result to be case insensitive in this context!)

Parameters

libds

library.dataset

Returns

output returns 1 or 0

Warning

Untested on tables registered in metadata but not physically present

Version

9.2

Author

Allan Bowe

Definition in file mf_existds.sas.