BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I have an anoying problem with my source files (that are .xls, .csv and others) and my EG project. I update these source files quite often and I would like EG to import the new updated contents of these files. I haven't been able to do this without closing Enterprise Guide and then re-opening it, if the file has been updated after the first time I read it in my project on the current session.

The files are on SAS server (EG is only client and I do not have local SAS on my workstation) and I access them in EG via SAS Servers icon, under which I find the folder that I have configured. The files are then read in locally on the SAS server.

Could someone help me with this topic?
Message was edited by: Jouni at Aug 9, 2006 10:42 AM
2 REPLIES 2
ChrisHemedinger
Community Manager
Hi,

I'm afraid you've hit a limitation of EG. When EG accesses your remote Excel file, it actually downloads a version of it locally and caches it. It must do this so that EG can read the contents of the file.

EG currently performs this download only once during the session -- that is, it does not refresh the local copy even if the remote file is updated.

I believe that when you are using a local Excel file to begin with, EG will get the refreshed content when you update the file.

As a workaround to your issue, you could use PROC IMPORT instead of the Import Data task. This would require:
- your remote SAS session to be on Windows
- licensed and installed SAS/ACCESS to PC File Formats
- and of course, you would have to craft a SAS program to run PROC IMPORT.

Chris
It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
deleted_user
Not applicable
Hello Chris,
thanks for your reply. Now I see the big picture more clearly. I tested it with a local file and it worked as you suggested. I was a bit confused about what should be local (for server) and what should be local (for client = EG).

Clearly making my files local for the server is useless, if I cannot import them with proc import or data step. I saw that EG refreshed the contents of my remote files if add them to my project via "My Computer" and my mapped network drives...

-Jouni-

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 712 views
  • 0 likes
  • 2 in conversation