Hello, We've the below macro defined in appserver_autoexec_usermods.sas which is helpful when accessing spreadsheets, csv files and access DB files when using PC File Server. /* Macro defined in appserver_autoexec_usermods.sas */ %global srv;
data _null_;
call symput("srv",compress("&_CLIENTMACHINE"));
run; /* EXAMPLE of reading a Spreadsheet */ PROC IMPORT DBMS=excelcs
OUT=test_import
DATAFILE="\\location\abc\pqr\xyz\excel test.xlsx" REPLACE;
PORT=9621;
SERVER=&srv;
serveruser="&da_lanid";
serverpass="&da_pwd";
RUN; ISSUE: Users are able to read in and write the files using PC File server successfully. But in the Workspace server logs we see a message saying, WARNING: Apparent symbolic reference _CLIENTMACHINE not resolved. Due to this warning message, we're getting the state of all jobs as FAILED even though the job was ran successfully. We don't wan't to ask all the Users in our environment to their change their code to access files when using PC File Server. How to overcome this scenario without reinstalling EG? Please suggest! SAS 9.4 M6 with SWO Thanks.
... View more
