03-19-2016 06:48 AM
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.
03-19-2016 11:40 AM
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:
03-20-2016 03:25 PM
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.