topic Re: macro program to check a data-set exists in library in SAS Programming

macro program to check a data-set exists in library

RTelang — Wed, 18 Nov 2015 09:27:34 GMT

macro program to check a data-set exists in library?

Re: macro program to check a data-set exists in library

RTelang — Wed, 18 Nov 2015 09:31:21 GMT

%let dsname=data1;
%let dslib=work;
%let outputflag=isexist;
%let isexist=0;
%dsexist(dsname=data1,dslib=work,outputflag=isexist);

Re: macro program to check a data-set exists in library

RW9 — Wed, 18 Nov 2015 10:47:20 GMT

Have a look at the SAS documentation, exists() function is the one you are looking for:

https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000210903.htm

Re: macro program to check a data-set exists in library

dcruik — Wed, 18 Nov 2015 16:50:52 GMT

Here's a simple macro program to do what you want. Just need to modify the code based on what you want to do if the data set exists, and what you want to do if the data set doesn't exist. Hope this helps:

%macro check(dsn);
%if %sysfunc(exist(&dsn)) %then %do;
	/***Insert code on what to do if data set exists***/
	proc print data=&dsn;
	run;
%end;

%else %do;
	/***Insert code on what to do if data set doesn't exist***/
	%put "Data set &dsn does not exist!";
%end;
%mend;

%check(datasetname);

Re: macro program to check a data-set exists in library

RTelang — Thu, 19 Nov 2015 05:38:02 GMT

can i add these variables to the code
%let dsname=data1;
%let dslib=work;
%let outputflag=isexist;
%let isexist=0;
%dsexist(dsname=data1,dslib=work,outputflag=isexist);
will it work ?? in ur code

Re: macro program to check a data-set exists in library

RW9 — Thu, 19 Nov 2015 09:22:14 GMT

Why, the sysntax is:

%let dsname=data1;
%let dslib=work;

%let isexist=%sysfunc(exist(&dslib..&dsname.));

Or if for some reason you have to have a macro:

%macro dsexist (dsname=,dslib=);

%sysfunc(exist(&dslib..&dsname.)

%mend dsexist;

data want;

isexist=%dsexist(dslib=work,dsname=your_dataset);

output;

run;

Note that the missing semicolon after the %sysfunc is deliberate so that it can be used directly in code.

Re: macro program to check a data-set exists in library

RTelang — Thu, 19 Nov 2015 10:18:42 GMT

1>dsexist is my macro.
2>variables defined->
%let dsname=data1;
%let dslib=work;
%let outputflag=
%let isexist;->default value is 0 if 1 then dataset exist 0 ds doest not exist.
so how can i incorporate this in your code?

Re: macro program to check a data-set exists in library

RTelang — Thu, 19 Nov 2015 12:01:03 GMT

and can i use %let sysfunc or % to display in d log a msg does the DS exist or not

Re: macro program to check a data-set exists in library

RW9 — Thu, 19 Nov 2015 12:23:50 GMT

%put Dataset (1=Exists, 0=Not Exists): %sysfunc(exist(sashelp.class));

Re: macro program to check a data-set exists in library

RTelang — Thu, 19 Nov 2015 14:14:53 GMT

hello RW9 thanks for d reply but

this issue how can i solve-> so how can i incorporate this in your code?

1>dsexist is my macro.

2>variables defined->

%let dsname=data1;
%let dslib=work;
%let outputflag=isexist;

%let isexist;->its default value is 0 if 1 then dataset exist if 0 DS doest not exist.

Re: macro program to check a data-set exists in library

RTelang — Thu, 19 Nov 2015 14:17:37 GMT

which logic do i apply with these above given parameters.

Re: macro program to check a data-set exists in library

dcruik — Thu, 19 Nov 2015 16:31:34 GMT

You can modified the code to include whatever variables you want. I'm not sure exactly what you're looking to do with your outputflag and isexist macros though. If you're just wanting to know if the data set exists and if it does or doesn't, display that in the log, you can do it by utilizing the exist() function as RW9 showed. The value is either a 0 or 1 returned depending if the data set exists or not, so I don't think you would need to hardcode your outputflag and isexist values. Below would be the macro modified with your variables if all you want to do is display in the log whether the data set exists or not:

%macro dsexist(dsname=,dslib=);

%put &dslib..&dsname outputflag = %sysfunc(exist(&dslib..&dsname));

%mend;

%dsexist(dsname=data1,dslib=work);

Log if data set doesn't exist: "work.data1 outputflag = 0".

Log if data set does exist: "work.data1 outputflag = 1".

Is this what you're trying to achieve?

Re: macro program to check a data-set exists in library

RTelang — Thu, 19 Nov 2015 16:14:10 GMT

Log if data set doesn't exist: "work.data1 outputflag = 0".
Log if data set does exist: "work.data1 outputflag = 1". yes

Re: macro program to check a data-set exists in library

RTelang — Thu, 19 Nov 2015 16:16:56 GMT

RW( i cannot understand your code 😮

Re: macro program to check a data-set exists in library

dcruik — Thu, 19 Nov 2015 16:31:54 GMT

Then the macro code I provided above will get you that. Below is the log from testing it.

When there was no work.data1 data set:

15         %macro dsexist(dsname=,dslib=);
16
17         %put &dslib..&dsname outputflag = %sysfunc(exist(&dslib..&dsname));
18
19         %mend;
20
21         %dsexist(dsname=data1,dslib=work);
data1.work outputflag = 0

When there was a work.data1 data set:

15         %macro dsexist(dsname=,dslib=);
16
17         %put &dslib..&dsname outputflag = %sysfunc(exist(&dslib..&dsname));
18
19         %mend;
20
21         %dsexist(dsname=data1,dslib=work);
work.data1 outputflag = 1
22

Re: macro program to check a data-set exists in library

Tom — Thu, 19 Nov 2015 17:19:55 GMT

@RTelang wrote:
1>dsexist is my macro.
2>variables defined->
%let dsname=data1;
%let dslib=work;
%let outputflag=
%let isexist;->default value is 0 if 1 then dataset exist 0 ds doest not exist.
so how can i incorporate this in your code?

There is no need to define additional macro varaibles beyond the parameters to the macro. It sounds like you want a macro that will set the value into the macro variable named in one of its parameters.

%macro dsexist(_dsn,_lib,_mvar);
%if (&_lib=) %then %let _lib=WORK;
%if (&_mvar=) %then %let _mvar=DSEXIST ;
%if not %symexist(&_mvar) %then %global &_mvar;
%let &_mvar=%sysfunc(exist(&_lib..&dsn));
%mend dsexist;

So if you want to set ISEXIST to indicate if WORK.DATA1 exists then you would call it like this:

%dsexist(data1,work,isexist)

Or like this if you prefer to call with named parameters.

%dsexist(_dsn=data1,_lib=work,_mvar=isexist)

Now if you already have the member name and libref in macro variables then use those in the call instead.

%let dsname=data1;
%let dslib=work;
%let outputflag=isexist;

%dsexist(&dsname,&dslib,&outputflag)