I am trying to import excel workbooks from a SharePoint folder using the Import Data option in SAS EG. It has worked for several other files, but for 3 in particular I am getting the following error:
SAS Enterprise Guide has encountered a problem
We recommend that you save your work and restart SAS Enterprise Guide.
Object reference not set to an instance of an object.
Also, I did restart SAS EG and the error is still occurring for those 3 files.
Can you give an example of the type of path you're providing to the Import Data task? Is this an on-premise SharePoint with a mapped drive or \\network\path style of path?
Chris
"C:\Users\XXXX\XXXX\SharePoint Folder\Filename.xlsm"
Are you using 64-bit SAS Enterprise Guide? If so, you might need the 64-bit version of the Microsoft data access tools. The components that EG uses to read these proprietary XLSM files are basically part of the operating system, but the bitness (32-bit or 64-bit) usually matches that of the Microsoft Office you have installed. If using 32-bit Office and 64-bit EG, this presents an incompatibility problem.
Or, if possible, get a version of the Excel file that isn't macro-enabled (XLSM), like XLSX. EG can read those directly.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.