SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Check if the access table exists from SAS

Reply
N/A
Posts: 0

Check if the access table exists from SAS

Hi, Is there a way to check if the table in MS Access 2000 database exists, before creating a new table or inserting/updating the existing table from within SAS. (base v 9.1.3)

thanks
N/A
Posts: 0

Re: Check if the access table exists from SAS

If you are accessing the Access database through a library assignment with SAS/Access to PC File Formats, then the tables and table structures should be transparent to the SAS session.

Reading the Dictionary.Tables and Dictionary.Columns SQL views will show you what exists in that library assignment.

Kind regards

David
Ask a Question
Discussion stats
  • 1 reply
  • 236 views
  • 0 likes
  • 1 in conversation