topic Re: How to deal with proc append and primary key in SAS Procedures

How to deal with proc append and primary key

BETO — Tue, 23 Sep 2014 21:42:37 GMT

HI Ive a

proc append base= myaccdb.table data=work.report4 force;

run;

i need to. Know how I can bypass the primary key that is in access when the primary key is removed it appends but I need the primary key to be there to prevent duplicates..

Re: How to deal with proc append and primary key

ballardw — Tue, 23 Sep 2014 21:59:01 GMT

You might want to provide a few more details about what you mean by "bypass primary key".

Re: How to deal with proc append and primary key

BETO — Wed, 24 Sep 2014 01:50:40 GMT

the proc append works great where it's appending data to the access table when the access table doesn't have a primary key. When I add the primary key to the access table and than run the proc append it fails I get and error message it can't insert data ... Im using force in the proc append but it doesn't append if there is a primary key...thanks again for your assistance

Re: How to deal with proc append and primary key

LinusH — Wed, 24 Sep 2014 07:17:30 GMT

Supplying the log would help. The cause of the error is usually written there.

But from the information that you give, I suppose that you are violating the PK during insert?

If so, you need to take action, primarily by fixing your data before the insert.

Re: How to deal with proc append and primary key

Ksharp — Wed, 24 Sep 2014 12:37:43 GMT

Make a audit trace for Prime Key .

Re: How to deal with proc append and primary key

ballardw — Wed, 24 Sep 2014 15:03:04 GMT

By any chance is the Primary Key field in Access and automatic increment and the SAS data set you are appending have values for that field? You might be getting a collision of some sort.