DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

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

[ Edited ]

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?


Accepted Solutions
Solution
‎03-17-2016 11:40 AM
Super User
Posts: 19,878

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


All Replies
Solution
‎03-17-2016 11:40 AM
Super User
Posts: 19,878

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

Contributor
Posts: 41

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

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

Super User
Super User
Posts: 7,997

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

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 337 views
  • 0 likes
  • 3 in conversation