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

Exporting to Access with a primary key

Reply
N/A
Posts: 1

Exporting to Access with a primary key

Hi all,

I am wondering if it's possible to export to access and maintain a primary key set up in SAS.

Our program uses SAS to merge several different files that are sent to us on a monthly basis. We then export to Access for further manual data entry, however, we want to maintain a primary key there. Right now, I've been doing it manually, but have forgotten to do so at least a couple of times, leading to problems. If I could automate it, it would help a lot!

The proc export function allows you to manipulate security values, but not much else.

I'm not very familiar with proc sql, but I'm wondering if there is something there that I can use.

Thanks!
Esteemed Advisor
Posts: 5,198

Re: Exporting to Access with a primary key

After loading the MS Access table, you could use SQL pass-thru to create PK, using MS Access syntax.

http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a002282155.htm

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 301 views
  • 0 likes
  • 2 in conversation