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

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

suraestar — Tue, 21 May 2013 05:18:34 GMT

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

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

ScottBass — Tue, 21 May 2013 07:58:54 GMT

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

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

RichardinOz — Tue, 21 May 2013 10:09:44 GMT

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

Richard

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

suraestar — Thu, 23 May 2013 06:41:29 GMT

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;