EXIST

EXIST

Verifies the existence of a SAS data library member

Category: SAS File I/O

Syntax
Arguments
Details
Examples
See Also

Syntax

EXIST(member-name<,member-type>)

Arguments

member-name

specifies the SAS data library member. If member-name is blank or a null string, EXIST uses the member specified by the system variable _LAST_ .

member-type

specifies the type of SAS data library member:

ACCESS	an access descriptor created using SAS/ACCESS software.
CATALOG	a SAS catalog or catalog entry.
DATA	a SAS data file (default).
VIEW	a SAS data view.

Details

EXIST returns 1 if the library member exists, or 0 if member-name does not exist or member-type is invalid. Use CEXIST to verify the existence of an entry in a catalog.

Examples

This example verifies the existence of a data set. If the data set does not exist, the example displays a message in the log.

%let dsname=sasuser.houses;
%if %sysfunc(exist(&dsname)) %then
   %let dsid=%sysfunc(open(&dsname,i));
%else %put Data set &dsname does not exist.;

This example verifies the existence of the SAS data view TEST.MYVIEW. If the view does not exist, the example displays a message in the log.
```
data _null_;
dsname="test.myview";
   if (exist(dsname,"VIEW")) then
      dsid=open(dsname,"i");
   else put dsname 'does not exist.';
run;
```

See Also

Functions:

CEXIST

FEXIST

FILEEXIST

Chapter Contents
Previous
Next
Top of Page