thanks for the reply, yes the service is running ! PLEASE SEE BELOW LOG, tried 2 kinds of codes, one for unix location and another for windows 1 The SAS System 02:54 Monday, September 28, 2020 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTNAME=''; 7 %LET _SASPROGRAMFILE=; 8 9 ODS _ALL_ CLOSE; 10 OPTIONS DEV=ACTIVEX; 11 GOPTIONS XPIXELS=0 YPIXELS=0; 12 FILENAME EGSR TEMP; 13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 14 STYLE=HtmlBlue 15 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome2/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 16 NOGTITLE 17 NOGFOOTNOTE 18 GPATH=&sasworklocation 19 ENCODING=UTF8 20 options(rolap="on") 21 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 22 23 GOPTIONS ACCESSIBLE; 24 /*Tried for unix location*/ 25 PROC EXPORT DATA=sashelp.class 26 OUTTABLE="class" 27 DBMS= ACCESSCS REPLACE ; 28 DATABASE="/tmp/class.mdb"; 29 SERVER='pscpmverstudio01.juniper.com'; 30 PORT=9621; 31 RUN; ERROR: Connection Failed. See log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.07 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 462.18k OS Memory 21412.00k Timestamp 09/28/2020 02:58:34 AM Step Count 6 Switch Count 0 Page Faults 0 Page Reclaims 122 Page Swaps 0 Voluntary Context Switches 20 Involuntary Context Switches 3 Block Input Operations 0 Block Output Operations 0 32 /*Tried for windows location*/ 33 PROC EXPORT DATA=sashelp.class 34 OUTTABLE="class" 2 The SAS System 02:54 Monday, September 28, 2020 35 DBMS= ACCESSCS REPLACE ; 36 DATABASE="C:\temp\class.mdb"; 37 SERVER='pscpmverstudio01.juniper.com'; 38 PORT=9621; 39 RUN; ERROR: Connection Failed. See log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.07 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 438.65k OS Memory 21668.00k Timestamp 09/28/2020 02:58:34 AM Step Count 7 Switch Count 0 Page Faults 0 Page Reclaims 38 Page Swaps 0 Voluntary Context Switches 24 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0 40 41 GOPTIONS NOACCESSIBLE; 42 %LET _CLIENTTASKLABEL=; 43 %LET _CLIENTPROCESSFLOWNAME=; 44 %LET _CLIENTPROJECTPATH=; 45 %LET _CLIENTPROJECTNAME=; 46 %LET _SASPROGRAMFILE=; 47 48 ;*';*";*/;quit;run; 49 ODS _ALL_ CLOSE; 50 51 52 QUIT; RUN; 53
... View more