Hi, this program is to export one file to microsoft office when we have a one table,
proc export
data=work.rr_if_datos_basicos_stl_201603
outtable='ACCESSCS'
dbms=ACCESSCS replace;
database='D:\Users\fmartinb\Desktop\prueba.mdb';
run;
but i if have more datas??
thanks
1. Write multiple proc exports.
2. Use the libname method instead
libname out accesscs 'path to mdb file';
data out.table1;
set table1;
data out.table2;
set table2;
run;
libname out;
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.
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?
Hi Team
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: