07-18-2016 09:02 AM
Hi, this program is to export one file to microsoft office when we have a one table,
but i if have more datas??
07-18-2016 09:15 AM
1. Write multiple proc exports.
2. Use the libname method instead
libname out accesscs 'path to mdb file';
07-18-2016 09:25 AM
I *think* that @Reeza's solution is elegant -- but the actual syntax would be LIBNAME PCFILES (not ACCESSCS). And it requires the PC Files Server, but if you have 64-bit SAS on Windows and 32-bit Office, it's probably all set up. ACCESSCS has the same requirement, so if you're using that, you're good.
08-18-2016 01:29 PM
I've got a similar situation here, and I'm not sure what I need. I have SAS EG 6.1 64-bit and 7.1 64-bit, but I don't have SAS itself on my PC (we're running on a GRID server). I need to export to Access (I have Office Professional 2010, 32-bit), but I don't see that option within EG. Can I do it if I install the PC Files Server (and is that something for my PC or for the SAS GRID server?)? Or do I need something else to be able to do this export?
07-18-2016 09:18 AM
This is OT because it interfaces SAS and R, so I just providing a link. You can export multiple SAS dataets to one access database without the SAS Access to PC-Files product. You do not need to worry abut bitness, however it is a good idea to have a macro inerface to 64 and 32bit R.
Probaly not useful for this list.
Here is the link
07-18-2016 04:08 PM
You can use a LIBNAME with Access without the PC Files Server if you have the Microsoft ACE database components (free download from Microsoft) installed on the same computer as your SAS installation. You just need to make sure the bitness matches: 32bit ACE with 32bit SAS or 64bit ACE with 64bit SAS.