topic Re: import and export im ms access on windows os in SAS Enterprise Guide

import and export im ms access on windows os

TarunKumar — Sat, 19 Mar 2016 10:48:52 GMT

Dear Team ,

Any an idea how we can import sasdata set in ms access. by import wizard i am able to do the import & export. but i want to done by sas coding.

Regards

Tarun Kumar

Re: import and export im ms access on windows os

JuanS_OCS — Sat, 19 Mar 2016 15:40:11 GMT

If you have the license of SAS/ACCESS Interface to PC Files, which I guess you do, you can use libname statements, then access the data with data steps or proc sql statements:

http://www2.sas.com/proceedings/sugi27/p025-27.pdf

http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#p0psac3j16cioen1nq2hkwrnk55y.htm

Re: import and export im ms access on windows os

PGStats — Sun, 20 Mar 2016 19:25:58 GMT

Are your versions of MS-Office and SAS of the same "bitness" (32 or 64 bits)? If not, you are trapped into using SAS PCFILES server which provides some, but not all, of the SAS-Office interface.

After wasting some time on this issue, we switched back from 64 to 32 bits versions of SAS, until we are ready to upgrade Office to 64 bits.