topic Importing data from Excel 2016 in Microsoft Integration with SAS

Importing data from Excel 2016

UNLStats — Wed, 22 Jun 2016 19:08:13 GMT

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.

Re: Importing data from Excel 2016

Reeza — Wed, 22 Jun 2016 19:17:51 GMT

Not surprised about DDE.

What Procs aren't working?

Re: Importing data from Excel 2016

Kurt_Bremser — Thu, 23 Jun 2016 05:55:00 GMT

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.