Have an excel file on a shared LAN drive (Novell) that serves as a datasource. SAS is running on a Unix server. How do I access the Excel file from Unix?? This needs to be run in a non-interactive (batch) fashion.
I'm sure there are probably other details that I am leaving out, so don't hesitate to ask.
If you are using SAS/Access to PCFiles and the SAS Libname Engine for Excel, then you will probably need to provide, at minimum, the SERVER= and PATH= option on the LIBNAME statement, as shown here (from the doc):
LIBNAME myxls PCFILES SERVER=D2323 PATH='c:\demo.xls';
Cynthia, thanks for the info. We've got SAS/ACCESS for PC File formats on our Unix license, but I'm confused about where I get the PC File Server (service) up and running. Do I just pick a PC on the network, since the source file is on a LAN drive? I think that solution still falls short for us since I computers are routinely rebooted after update pushes (and I assume the service would not be restarted until I log-in on that PC??).
Since the method you use will be version-specific and specific to whether you use the PC File Server or not, you might want to open a track with Tech Support on this issue. To open a track with Tech Support, go to: http://support.sas.com/ctx/supportform/createForm