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
Did you install the PC Files Server?
Did you perhaps also change to a Server configuration?
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)
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.