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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.