BookmarkSubscribeRSS Feed
RinaShaikhLesko
Calcite | Level 5
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!
1 REPLY 1
LinusH
Tourmaline | Level 20
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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 930 views
  • 0 likes
  • 2 in conversation