topic EG4.1 - Import Task - Get EG to recognise an update in the file to be imported in SAS Enterprise Guide

EG4.1 - Import Task - Get EG to recognise an update in the file to be imported

DaveShea — Thu, 11 Aug 2011 04:48:07 GMT

Hi,

At present I have a situation where some data is being stored on an Excel (2007) workbook and periodically imported into

SAS Enterprise Guide 4.1 (4.1.0.1016) with the Import Task.

I realise what is going on behind the scenes when I run the Import task for the first time in a SAS session is that an asterisk-delimited text file is created on the server hosting my SAS session and the Import Task does its work from that copy of my original Excel workbook.

However, if, whilst still running that same SAS session, I update and save the Excel workbook and re-run the Import Task, my changes are not reflected in the

asterisk-delimited text file or the resultant SAS dataset that is produced by the Import Task.

The only way around this that I have found so far, is to close down the SAS session and re-start a new one. When I run the Import Task for the first time in that new session, a fresh look is taken at the underlying Excel workbook and my resultant SAS dataset reflects the updates that I made.

Does anyone know a way around this without resorting to Proc Import?

Cheers,

Downunder Dave

Wellington.

EG4.1 - Import Task - Get EG to recognise an update in the file to be imported

DF — Thu, 11 Aug 2011 09:39:00 GMT

This is probably the most annoying thing I've came across in EG.

What seems to work is if you save and close your project (but don't disconnect your session or close EG), then reopen it. This seems to be enough to trick SAS into reloading the file from source.

That's still pretty bad in terms of usability, so I normally sidestep EG's own import process wherever possible and FTP files to our SAS server.

EG4.1 - Import Task - Get EG to recognise an update in the file to be imported

DF — Thu, 11 Aug 2011 09:40:01 GMT

Oh, we're using SAS Enterprise Guide 4.1 (4.1.0.1009) so I can't say for certain it'll work in your version, or that SAS haven't fixed this properly in a later version!

EG4.1 - Import Task - Get EG to recognise an update in the file to be imported

Doc_Duke — Thu, 11 Aug 2011 13:30:36 GMT

Fixed in EGuide 4.3. I no longer have 4.2 to check.

EG4.1 - Import Task - Get EG to recognise an update in the file to be imported

NN — Thu, 11 Aug 2011 17:17:57 GMT

We had faced the same issue . The problem arose due to some patch that was installed. Contacted the tech support and they were able to resolve it. You should do the same