Exporting SAS data to access

[MrBadger]

I wish to export SAS data to an MS Access table, however I wish to append the data to the table rather than overwrite it.

Any Ideas?

 

[klaz2002]

There is a way. Using the SAS ODBC engine in Ver. 8.0 and later you can append data to an Access table.
1) You must have an ODBC license from SAS. This should appear in the Setinit.sss file as 'ODBC'.
2) Set up an ODBC DSN file. In the control panel click on ODBC setup (this could be in admin tools in the control panel). Choose the system DSN tab and then choose the driver, in this case Access. Name the DSN file and select the database (select button). Click OK and your done.

Now in SAS you would use the new option with the libname statement.

libname mytemp odbc dsn="name_of_your_dsn_file";*spelled exactly the way you named it;
*Then use the proc append from sas to do your data add.;

proc append base=mytemp.customers data =proto.finances;run;


Viola! That should work. (just tested it and it did work.)