BookmarkSubscribeRSS Feed
UNLStats
Calcite | Level 5

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.

2 REPLIES 2
Reeza
Super User

Not surprised about DDE. 

 

What Procs aren't working?

Kurt_Bremser
Super User

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 2 replies
  • 1873 views
  • 1 like
  • 3 in conversation