SAs 9.3 and upgrade to office 2016 from office 2010

[khsundet]

We use SAS 9.3.1 64-bit on Windows 7Pro, and integrate with MS office 2010 Excel through Access PC files and SAS ODS HTML3 or ODS TAGSETS.EXCEXP.  IT will move us to Office 2016/365.  Does sas 9.3.1 support office 2016? I have received conflicting information. Do we need to get any additional software short of upgrading to SAS 9.4 to be able to interface with Excel?

[Kurt_Bremser · Accepted solution]

ODS TAGSETS.EXCELXP and ODS HTML3 are independent of any Microsoft shenanigans, so they should not be affected.

When using ACCESS to PC Files for pre-xlsx formats, bitness might be an issue. Make sure that SAS and Office have the same bitness.

[khsundet]

Thank you for your reply. We use xlsx files, so the bitness should not be an issue but I'll definitely ask for 64-bit to be sure of compatibility with SAS and WIN 7.