topic Re: Appending data to access in SAS Programming

Appending data to access

Gil_ — Wed, 31 Oct 2018 15:20:42 GMT

Here is my code

proc export data=sashelp.class
   table=class
   dbms=access2007 replace;
   database='c:\data\test.accdb';
run;

libname myaccdb 'c:\data\test.accdb';

proc append base=myaccdb.class data=sashelp.class;
run;

libname myaccdb clear
My question is i have a primary key thats get removed which will allow duplication. How can i keep my primary key?

Re: Appending data to access

pink_poodle — Wed, 31 Oct 2018 15:41:35 GMT

In this post, they use proc datasets with some success:

https://communities.sas.com/t5/Integration-with-Microsoft/How-do-I-append-a-SAS-data-set-into-ACCESS-database/td-p/400828

proc datasets library = accdb nolist;
append base = myaccdb.class 
data = sashelp.class;
force;
run;
quit;

Re: Appending data to access

singhsahab — Wed, 31 Oct 2018 16:32:37 GMT

Hi Gil,

if you want to append data sets , first you have to remove Primary key constraint, as you know it wouldn't allow duplicate values.

Proc append will run without any error but in log you will get warning . Like " Add/Update failed for data set because data value(s) do not comply with integrity constraint primary key, number of observations rejected."

Thanks,