Desktop productivity for business analysts and programmers

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

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

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

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.


Accepted Solutions
Solution
‎08-11-2011 09:30 AM
Valued Guide
Posts: 2,111

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

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

View solution in original post


All Replies
Frequent Contributor
Frequent Contributor
Posts: 94

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

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.

Frequent Contributor
Frequent Contributor
Posts: 94

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

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!

Solution
‎08-11-2011 09:30 AM
Valued Guide
Posts: 2,111

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

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

Regular Contributor
Regular Contributor
Posts: 166

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

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 276 views
  • 3 likes
  • 4 in conversation