topic SAS EG Posts a Shutdown Error When Importing Excel Spreadsheet in SAS Enterprise Guide

SAS EG Posts a Shutdown Error When Importing Excel Spreadsheet

cbrotz — Tue, 09 Jan 2018 17:27:49 GMT

Hello,

I pulling quite a few Excel spreadsheets into SAS EG. I have one particular spreadsheet that I just cannot import without EG posting an error that it encountered a problem......it is a shared spreadsheet. I have attached the error. Any ideas would be much appreciated.

Re: SAS EG Posts a Shutdown Error When Importing Excel Spreadsheet

snoopy369 — Tue, 09 Jan 2018 19:07:29 GMT

I'd first check if there is anything weird in the column names that could be causing an issue (special characters, mostly).

If not, then it may be that it's a shared spreadsheet; I have had some issues with them before. Try saving a non-shared version of the same spreadsheet and seeing if that imports correctly.

Re: SAS EG Posts a Shutdown Error When Importing Excel Spreadsheet

cbrotz — Tue, 09 Jan 2018 19:18:11 GMT

Thank you for the response. I did get the data to import. Basically, I just ignored the error and kept shutting it and trying different ways to try and bypass. I changed the default field range and that seemed to allow the data to import. Weird.