SAS Enterprise Guide manages this by using your local Windows components to read data from Exchange, then transform it into a SAS data set. It works...but it relies on that Windows-specific connection and it's sensitive to bit architecture (as you mentioned). No SAS code is at play here, so it cannot be automated outside of the SAS Enterprise Guide app.
If you're using Microsoft Office 365, you can use REST APIs to accomplish the task. This requires a little bit of setup for authentication/access, but then the process can be automated in code.
Check out SAS Innovate on-demand content! Watch the main stage sessions, keynotes, and over 20 technical breakout sessions!
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.