sas 9.4 en microsoft office 2010

BartDekeyser — Wed, 07 Jun 2017 10:41:10 GMT

Dear all,

our company recently moved from sas 9.3 to sas 9.4 so we moved from 32bit to 64bit.

Now i have performance issues. Some programs ran for 30 mins now turned into 5-6 hours.... And the main issue is Microsoft office.

Loading data into accdb (300k records and 8 variables takes approx 40 minutes... it used to be like 5 minutes).

Is it possible that issue is : SAS 9.4 = 64 bits, Microsoft Office 2010 : 32 bits.

Is there a workaround?

I use libname odbc to access accdb files

We have following licenses :

---Base SAS Software

---SAS/STAT

---SAS/GRAPH

---SAS/ETS

---SAS/FSP

---SAS/OR

---SAS/AF

---SAS/IML

---SAS/CONNECT

---SAS/Secure 168-bit

---SAS/Secure Windows

---SAS Enterprise Guide

---OR OPT

---OR PRS

---OR IVS

---OR LSO

---SAS/ACCESS Interface to ODBC

---SAS/IML Studio

---SAS Workspace Server for Local Access

---High Performance Suite

Re: sas 9.4 en microsoft office 2010

ballardw — Wed, 07 Jun 2017 14:43:16 GMT

Did you install the PC Files Server?

Did you perhaps also change to a Server configuration?

Re: sas 9.4 en microsoft office 2010

BartDekeyser — Thu, 08 Jun 2017 06:03:14 GMT

I work in a big company.

I dont think we have PC Files Server

Configuration changed from SAS 9.3 to 9.4. (We also have a server environment)

topic sas 9.4 en microsoft office 2010 in SAS Programming

sas 9.4 en microsoft office 2010

Re: sas 9.4 en microsoft office 2010

Re: sas 9.4 en microsoft office 2010