Is there any SAS Function to check atleast a dataset present in a location/library?

[suraestar]

Is there any SAS Function to check atleast a dataset present in a location/library?

[ScottBass]

Check out the proc sql dictionary.tables table, or the sashelp.vtable view of the same.

[RichardinOz]

exist() for a SAS dataset, or fexist() for any file or directory

Richard

[suraestar · Accepted solution]

Hi, I used the below code to check whether any dataset is exist in a location.. Is there any simpler way to do this??? libname target 'c:\temp\'; %let lib  = target; proc sql noprint; select count(*) into:lcount from sashelp.vtable where upcase(libname)="%upcase(&lib)" and MEMTYPE='DATA'; quit; %put lcount=&lcount;