SAS script unable to import Excel file when ran from Batch script but is able when script is ran directly from SAS UI
There are 2 areas I would look at:
-
What security context is the script running under, specifically what user is executing it? It is probably a system security context and that context doesn't have access to the files.
-
Where is the script running and is the path to the place it is running not matching the relative paths defined.