advanced code snippet search

Posted By

webonomic on 02/19/09


Tagged

database access


Versions (?)

Create Access Database from SAS

 / Published in: SAS
 
Expand | Embed | Plain Text 
  1. PROC EXPORT DATA= DATASET_NAME
  2.      OUTTABLE= "TABLE_NAME"
  3.      DBMS=ACCESS REPLACE;
  4. DATABASE="C:\DATABASE_NAME.MDB";

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: mycotropic on August 10, 2009

This works unless you want to re-create a table with the same name. Say I create AllData and then find that I have to add something to it or modify something in it, then I have to manually go to Access and remove the table SAS created and run the SAS code again.

Any chance you've found a way to have SAS dump the old table and replace it with the new one with the same name?

Posted By: webonomic on January 17, 2010

Whoops! I never check my comments on Snipplr.com.

Truth be told, I rarely do much Access DB work with SAS. But to answer your question, you could probably drop the table via Proc SQL and the query: DROP TABLE table_name.

You need to login to post a comment.