Sample 49224: How to check whether a view or a table exists using DS2
The sample code on the Full Code tab demonstrates how to check whether a view or a table exists using DS2 code.
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
The sample code below demonstrates how to check whether a view or a table exists using DS2 code.
/* NOTE: The SQLEXEC function was called SQLSUB prior to SAS 9.4. */
proc ds2;
data _null_;
method init();
sqlexec('create table foodata (a double)');
sqlexec('create view fooview as select * from foodata');
end;
enddata;
run;
data _null_;
method init();
declare int rc;
rc = sqlexec('select * from fooview');
if (rc eq 0) then put 'fooview exists';
else put 'fooview does not exist';
rc = sqlexec('select * from foodata');
if (rc eq 0) then put 'foodata exists';
else put 'foodata does not exist';
rc = sqlexec('select * from foonone');
if (rc eq 0) then put 'foonone exists';
else put 'foonone does not exist';
end;
enddata;
run;
quit;
These sample files and code examples are provided by SAS Institute
Inc. "as is" without warranty of any kind, either express or implied, including
but not limited to the implied warranties of merchantability and fitness for a
particular purpose. Recipients acknowledge and agree that SAS Institute shall
not be liable for any damages whatsoever arising out of their use of this material.
In addition, SAS Institute will provide no support for the materials contained herein.
| Date Modified: | 2013-04-26 14:23:03 |
| Date Created: | 2013-02-20 14:35:16 |
Operating System and Release Information
| SAS System | Base SAS | z/OS | 9.4 TS1M0 | |
| Z64 | 9.4 TS1M0 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.4 TS1M0 | |
| Microsoft® Windows® for x64 | 9.4 TS1M0 | |
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M0 | |
| Microsoft Windows 8 Pro x64 | 9.4 TS1M0 | |
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M0 | |
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M0 | |
| Microsoft Windows 8.1 Pro | 9.4 TS1M0 | |
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M0 | |
| Microsoft Windows Server 2008 R2 | 9.4 TS1M0 | |
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M0 | |
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M0 | |
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M0 | |
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M0 | |
| Microsoft Windows Server 2012 Std | 9.4 TS1M0 | |
| Windows 7 Enterprise x64 | 9.4 TS1M0 | |
| Windows 7 Professional x64 | 9.4 TS1M0 | |
| 64-bit Enabled AIX | 9.4 TS1M0 | |
| 64-bit Enabled HP-UX | 9.4 TS1M0 | |
| 64-bit Enabled Solaris | 9.4 TS1M0 | |
| HP-UX IPF | 9.4 TS1M0 | |
| Linux for x64 | 9.4 TS1M0 | |
| Solaris for x64 | 9.4 TS1M0 | |
