topic Re: check for the existance of a data set or group of data sets? in SAS Procedures

check for the existance of a data set or group of data sets?

SASguyCO — Wed, 15 Jun 2011 21:40:34 GMT

I'm curious, is there a way to basically evaluate an "if" statement on whether a certain data set or group of data sets exist and if so run one process and if not, then a different process.

In other words:

%macro exists;
%if libname.dset_201104 "exists" %then %do;
data;
set;
code code code;
run;
%end;

%else %do;
data;
set;
code code code;
run;
%end;
%mend;
%exists

Re: check for the existance of a data set or group of data sets?

Reeza — Wed, 15 Jun 2011 22:46:45 GMT

I don't know if you do can do it in one if statement but you can use the open function to check if the dataset exists.

see open function, page 2 of the following paper.

http://www2.sas.com/proceedings/sugi26/p095-26.pdf

Re: check for the existance of a data set or group of data sets?

SASguyCO — Wed, 15 Jun 2011 23:03:16 GMT

Genius! That method works perfect, thanks so much!

Re: check for the existance of a data set or group of data sets?

SASKiwi — Thu, 16 Jun 2011 04:02:21 GMT

There's also the EXIST function for checking if a SAS dataset exists or not:

if EXIST('library.dataset') then......;

Re: check for the existance of a data set or group of data sets?

SASguyCO — Thu, 16 Jun 2011 19:22:48 GMT

Thanks Kiwi, I didn't realized the "exist" function existed :). How convenient!