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

Importing data from Excel 2016

Reply
New Contributor
Posts: 2

Importing data from Excel 2016

Procedures which worked for Office 2010 is no longer working for Office 2016.  Not even DDE exchange is working with 2016.  Does someone know the status of SAS 9.4 TS1M3 and this version of Office?  I have ran into many issues with importing Excel and Access data into SAS.

Grand Advisor
Posts: 17,312

Re: Importing data from Excel 2016

Not surprised about DDE. 

 

What Procs aren't working?

Esteemed Advisor
Posts: 6,636

Re: Importing data from Excel 2016

Office 2016 is from this year. In my definitions for Microsoft software, this means it is in open beta test and is not nearly mature enough to be used in production environment. Wait until 2018 and some service packs before using it.

 

The next thing is that API's and interfaces change with every release of MS software and that often causes problems in interacting.

Instead of using MS proprietary pieces like the Excel format or DDE, use simple interfaces that never change.

Use an open, readable format like csv to transfer data between SAS and MS Office.

DDE in particular is not yet dead, but it already smells funny.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 2 replies
  • 549 views
  • 1 like
  • 3 in conversation