Apologies, Kurt. I meant to post the log and forgot. 1 The SAS System 08:26 Friday, August 8, 2014 1 rsubmit task1; NOTE: Remote submit to TASK1 commencing. 1475 %put NOTE: Using grid node &SYSHOSTNAME to run task.; NOTE: Using grid node isbsas09 to run task. 1476 %let _EGRC=0; 1477 ;*';*";*/;quit;run; 1478 OPTIONS PAGENO=MIN; 1479 %put NOTE: The current task will be submitted to the grid due to the server configuration policy.; NOTE: The current task will be submitted to the grid due to the server configuration policy. 1480 %LET _CLIENTTASKLABEL='Program1'; 1481 %LET _CLIENTPROJECTPATH='/sascode/myuserID/IHAWeeklyUpdate.egp'; 1482 %LET _CLIENTPROJECTNAME='IHAWeeklyUpdate.egp'; 1483 %LET _SASPROGRAMFILE=; 1484 1485 ODS _ALL_ CLOSE; 1486 OPTIONS DEV=ACTIVEX; 2 The SAS System 08:26 Friday, August 8, 2014 1487 %let sasworklocation="&_eg_gridworkpath/"; 1488 GOPTIONS XPIXELS=0 YPIXELS=0; 1489 FILENAME EGSR "&_eg_gridworkpath/%sysfunc(uuidgen(0))_eggen"; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 1490 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue 1490! STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/x86/SASEnterpriseGuide/5.1/Styles/HtmlBlue.css") NOGTITLE NOGFOOTNOTE 1490! GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on"); 1491 1492 GOPTIONS ACCESSIBLE; 1493 PROC IMPORT OUT=servername.cxb_iha_ops_2014_08_07 1494 DATATABLE='Member Level Data' 1495 DBMS=ACCESS REPLACE; ERROR: DBMS type ACCESS not valid for import. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 44.06k OS Memory 14372.00k Timestamp 08/08/2014 08:39:18 AM Page Faults 0 Page Reclaims 25 Page Swaps 0 Voluntary Context Switches 6 Involuntary Context Switches 5 Block Input Operations 0 Block Output Operations 0 WARNING: Apparent symbolic reference Q not resolved. 1496 DATABASE="&Q:\fakepath\Member Level Detail\Member Level Detail1.accdb" 1496! ; 1497 USEDATE=YES; 1498 SCANTIME=NO; 1499 DBSASLABEL=NONE; 1500 RUN; 1501 1502 GOPTIONS NOACCESSIBLE; 1503 %LET _CLIENTTASKLABEL=; 1504 %LET _CLIENTPROJECTPATH=; 1505 %LET _CLIENTPROJECTNAME=; 1506 %LET _SASPROGRAMFILE=; 1507 1508 ;*';*";*/;quit;run; 1509 ODS _ALL_ CLOSE; 1510 1511 1512 QUIT; RUN; 1513 %sysrput _EGRCGRID=&_EGRC; NOTE: Remote submit to TASK1 complete. 2 %let _EGRC=&_EGRCGRID; 3 Hope that helps. The items in strikethrough (user ID, server name, filepath), have been altered for confidentiality.
... View more