topic How to read 32 bit MS access db into SAS EG 64 bit in SAS Programming

How to read 32 bit MS access db into SAS EG 64 bit

ktkv5 — Thu, 17 Mar 2016 15:22:32 GMT

Hi,

Please let me know how I can read a MS access DB (32 bit ) and create a data set in SAS Enterprise Guide(64 bit). I know one way is to install a SAS EG 32 bit on the same machine, but is there a way to achieve this programmatically?

Re: How to read 32 bit MS access db into SAS EG 64 bit

Reeza — Thu, 17 Mar 2016 15:34:00 GMT

PC File Server?

http://support.sas.com/kb/43/802.html

Re: How to read 32 bit MS access db into SAS EG 64 bit

RW9 — Thu, 17 Mar 2016 15:35:02 GMT

Dump the data out of Access to CSV then read it in via datastep.

Re: How to read 32 bit MS access db into SAS EG 64 bit

ktkv5 — Thu, 17 Mar 2016 15:51:08 GMT

When I was trying to Install PC SAS, its installing to default location(which can't be changed), and as there is a newer SAS installation, 64 bit, it's unable to proceed. Not sure how to change the path