EG uses the MS Jet engine to read Excel files on the local Windows file system and SAS/Access to PC File Formats (I think) on the server file system. Generally, it works fine but, obviously, this can lead to inconsistancies if a spreadsheet is moved. For SAS datasets, assuming your server runs some MS flavour, then follow the other posters advice and use UNC addressing: libname pclib "\\pcnetworkaddress\C$\myproject\sasdata" . For Unix servers, you will need NFS (e.g Samba) configured or you will have to copy SAS files manually. Be careful if you copy files to 64-bit Unix. CEDA may take care of the translation but you need to check large files (>10Gb) carefully. UNC addresses are also good for text files but you could also consider filename ftp. ... View more

Although NOXCMD is in effect, SAS can still make use of the operating system. This works for EG running a workspace server on MS Server2003: data _null_ ; NewDir = dcreate('AnotherNewDir','c:\temp') ; run ; ... View more

You cannot directly replace the functionality of regular SAS using EG. For instance, using EG, try this common control technique: data _null_ ; if &sqlobs = '0' then abort abend 9 ; run ; There are other gotchas as well. ... View more

If the data is not huge then copy and paste in the server list window. Otherwise, you can use a staging area. Assign a network share on your local machine and reference it from a libname assigned to the server (usually SASMain) session e.g. libname c_temp "\\WM200KTBSW10JK2\temp\" ; proc copy in=work out=c_temp ; run ; ... View more

Will your users be running 'Local' or connecting to a SAS Workspace server? ... View more

I just posted a suggestion about using UNC addressing in another thread but would curious for others opinions. I administer multiple SAS9 servers where I have numerous libraries defined in metadata to allow each server to access another's file system e.g. libname proj1 "\\sas01\shareddata\proj1\sasdata" ; My reasoning is that modern LAN connections are faster than I/O on disk drives and SAS has numerous other performance bottlenecks. If I had 10 laptop users, then I would consider putting all the data on a fast file server and allowing users to access it via defined shares. ... View more

We have EG4.1 installed on a Citrix server for evaluation and the Sys Admins seem pretty comfortable with the performance. All the serious processing occurs on dedicated SAS9 Workspace servers. However, they were not so happy with running sas.exe (i.e Local mode under EG) on the Citrix servers themselves. It only took 3 concurrent users running normal work before they pulled the plug on the test because of overloading. Lastly, we have been encouraging users to always use UNC addresses (i.e. \\servername\sharename ) in any libname/filename assignments as it ensures that code is entirely portable. Pathcopy from Ninotech is free utility that helps with UNC addressing. ... View more

I hope that the enhancements planned for EG 4.2 address some of the logging issues. It feels like the internal workings of EG are being deliberately obscured. I have been supporting SAS products for many years and never found a product more difficult to support. Despite the obvious benefits, I have users begging to return to PC/SASv913 or even EG 3.0 because of the opaqueness and perceived instability of EG4.1. ... View more

Very nice. I thought I had applied SP3 but one of my collegues found a SAS note refering to swdepot\client2cd\jps . However, not everything is smooth. Our .sas files are controlled by MS Source Safe and cannot be overwritten by another process. I am still testing but the SP seems to works OK despite the warning messages. Thanks for the tip. ... View more

I have found the copy and paste functionality useful to move stored process from devl to test to live Stored Process subfolders. My biggest gripe is that the same function cannot be used between repositories as our prod environment is a separate server. Copying the whole repository to promote one stored process is a bit extreme. If anyone knows the underlying XML query used by copy/paste I would be grateful. I might try to deduce it using iomlevel parameters on the metadata server log. ... View more