topic Re: Importing Excel data after Excel file location changes in SAS EG in SAS Enterprise Guide

Importing Excel data after Excel file location changes in SAS EG

TashaChapman14 — Wed, 10 Oct 2018 18:08:02 GMT

I'm still having some trouble getting used to the EG interface.

I have a project where I'm importing data from an Excel spreadsheet. I recently moved some folders around on my LAN, so the Excel file is now in a new location. Nothing else about the Excel data has changed. However, when I try to open the "Modify Import Data" task so I can point it to the new location, EG freaks out, says that it can't find the data, and ends the process.

Are there any other solutions besides starting from scratch (and hoping that I remember all the settings from the last time I imported the data)?

Re: Importing Excel data after Excel file location changes in SAS EG

ChrisHemedinger — Wed, 10 Oct 2018 18:56:32 GMT

Right-click on the Excel file icon, select Properties. Then select Change... to change the Excel file location to its new home.

Re: Importing Excel data after Excel file location changes in SAS EG

TashaChapman14 — Wed, 10 Oct 2018 20:26:06 GMT

Thank you, Chris! Worked like a charm.