SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAs 9.3 and upgrade to office 2016 from office 2010

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

SAs 9.3 and upgrade to office 2016 from office 2010

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?


Accepted Solutions
Solution
‎03-23-2017 10:45 AM
Esteemed Advisor
Posts: 6,646

Re: SAs 9.3 and upgrade to office 2016 from office 2010

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎03-23-2017 10:45 AM
Esteemed Advisor
Posts: 6,646

Re: SAs 9.3 and upgrade to office 2016 from office 2010

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 3

Re: SAs 9.3 and upgrade to office 2016 from office 2010

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.

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 259 views
  • 0 likes
  • 2 in conversation