Proc printto print statement not working in Enterprise Guide
in [SAS]
|
From: sasuser sasuser on 26 May 2010 05:41 I have the following codes, which run successfully in SAS 9.1 but when I run it in EG, the output test.txt is blank. Can someone tell me why? options nodate nonumber nocenter; data test; a="test1"; b="testing1"; output; a="test2"; b="testing2"; output; run; proc printto print="c:\test.txt" new; run; proc print data=test noobs ; title; run; proc printto; run; The EG log file is as following: 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code); 4 %LET _EGTASKLABEL=%NRBQUOTE(Code); 5 %LET _CLIENTPROJECTNAME=%NRBQUOTE(); 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; NOTE: Some of your options or statements may not be supported with the Activex or Java series of devices. Graph defaults for these drivers may be different from other SAS/GRAPH device drivers. For further information, please contact Technical Support. 9 OPTIONS DEV=ACTIVEX; 10 FILENAME EGHTML TEMP; NOTE: Writing HTML(EGHTML) Body file: EGHTML 11 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' STYLE=EGDefault 11 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared %20Files/BIClientStyles/EGDefault.c 11 ! ss") ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/ graph/v91/sasgraph.exe") 11 ! NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation; WARNING: Argument 1 to function TSLVL referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. 12 13 %gaccessible; 14 options nodate nonumber nocenter; 15 16 data test; 17 a="test1"; 18 b="testing1"; 19 output; 20 a="test2"; 21 b="testing2"; 22 output; 23 run; NOTE: The data set WORK.TEST has 2 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 24 25 proc printto print="c:\test.txt" new; 26 run; NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 27 28 proc print data=test noobs ; 29 title; 30 run; The SAS System NOTE: There were 2 observations read from the data set WORK.TEST. NOTE: PROCEDURE PRINT used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 31 32 proc printto; 33 run; NOTE: PROCEDURE PRINTTO used (Total process time): real time 0.04 seconds cpu time 0.00 seconds 34 35 %LET _CLIENTTASKLABEL=; 36 %LET _EGTASKLABEL=; 37 %LET _CLIENTPROJECTNAME=; 38 %LET _SASPROGRAMFILE=; 39 40 ;*';*";*/;quit;run; 41 ODS _ALL_ CLOSE; 42 43 44 QUIT; RUN; 45
From: Tom Abernathy on 26 May 2010 10:54 It looks like it ran fine. What about it is not working? Did you look for the file on the C drive of the server that is running SAS? On May 26, 5:41 am, sasuser sasuser <sasus...(a)gmail.com> wrote: > I have the following codes, which run successfully in SAS 9.1 but when > I run it in EG, the output test.txt is blank. Can someone tell me why? > > options nodate nonumber nocenter; > > data test; > a="test1"; > b="testing1"; > output; > a="test2"; > b="testing2"; > output; > run; > > proc printto print="c:\test.txt" new; > run; > > proc print data=test noobs ; > title; > run; > > proc printto; > run; > > The EG log file is as following: > > 1 ;*';*";*/;quit;run; > 2 OPTIONS PAGENO=MIN; > 3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code); > 4 %LET _EGTASKLABEL=%NRBQUOTE(Code); > 5 %LET _CLIENTPROJECTNAME=%NRBQUOTE(); > 6 %LET _SASPROGRAMFILE=; > 7 > 8 ODS _ALL_ CLOSE; > NOTE: Some of your options or statements may not be supported with the > Activex or Java series of > devices. Graph defaults for these drivers may be different from > other SAS/GRAPH device > drivers. For further information, please contact Technical > Support. > 9 OPTIONS DEV=ACTIVEX; > 10 FILENAME EGHTML TEMP; > NOTE: Writing HTML(EGHTML) Body file: EGHTML > 11 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' > STYLE=EGDefault > 11 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared > %20Files/BIClientStyles/EGDefault.c > 11 ! ss") ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/ > graph/v91/sasgraph.exe") > 11 ! NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation; > WARNING: Argument 1 to function TSLVL referenced by the %SYSFUNC or > %QSYSFUNC macro function is out > of range. > 12 > 13 %gaccessible; > 14 options nodate nonumber nocenter; > 15 > 16 data test; > 17 a="test1"; > 18 b="testing1"; > 19 output; > 20 a="test2"; > 21 b="testing2"; > 22 output; > 23 run; > > NOTE: The data set WORK.TEST has 2 observations and 2 variables. > NOTE: DATA statement used (Total process time): > real time 0.00 seconds > cpu time 0.00 seconds > > 24 > 25 proc printto print="c:\test.txt" new; > 26 run; > > NOTE: PROCEDURE PRINTTO used (Total process time): > real time 0.00 seconds > cpu time 0.00 seconds > > 27 > 28 proc print data=test noobs ; > 29 title; > 30 run; > > The SAS System > > NOTE: There were 2 observations read from the data set WORK.TEST. > NOTE: PROCEDURE PRINT used (Total process time): > real time 0.03 seconds > cpu time 0.00 seconds > > 31 > 32 proc printto; > 33 run; > > NOTE: PROCEDURE PRINTTO used (Total process time): > real time 0.04 seconds > cpu time 0.00 seconds > > 34 > 35 %LET _CLIENTTASKLABEL=; > 36 %LET _EGTASKLABEL=; > 37 %LET _CLIENTPROJECTNAME=; > 38 %LET _SASPROGRAMFILE=; > 39 > 40 ;*';*";*/;quit;run; > 41 ODS _ALL_ CLOSE; > 42 > 43 > 44 QUIT; RUN; > 45
From: YingTzu Tan on 26 May 2010 21:59 It runs successfully in EG but the test.txt file is blank with 0kb. On May 26, 10:54 pm, Tom Abernathy <tom.aberna...(a)gmail.com> wrote: > It looks like it ran fine. What about it is not working? > Did you look for the file on the C drive of the server that is running > SAS? > > On May 26, 5:41 am, sasuser sasuser <sasus...(a)gmail.com> wrote: > > > > > I have the following codes, which run successfully in SAS 9.1 but when > > I run it in EG, the output test.txt is blank. Can someone tell me why? > > > options nodate nonumber nocenter; > > > data test; > > a="test1"; > > b="testing1"; > > output; > > a="test2"; > > b="testing2"; > > output; > > run; > > > proc printto print="c:\test.txt" new; > > run; > > > proc print data=test noobs ; > > title; > > run; > > > proc printto; > > run; > > > The EG log file is as following: > > > 1 ;*';*";*/;quit;run; > > 2 OPTIONS PAGENO=MIN; > > 3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code); > > 4 %LET _EGTASKLABEL=%NRBQUOTE(Code); > > 5 %LET _CLIENTPROJECTNAME=%NRBQUOTE(); > > 6 %LET _SASPROGRAMFILE=; > > 7 > > 8 ODS _ALL_ CLOSE; > > NOTE: Some of your options or statements may not be supported with the > > Activex or Java series of > > devices. Graph defaults for these drivers may be different from > > other SAS/GRAPH device > > drivers. For further information, please contact Technical > > Support. > > 9 OPTIONS DEV=ACTIVEX; > > 10 FILENAME EGHTML TEMP; > > NOTE: Writing HTML(EGHTML) Body file: EGHTML > > 11 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' > > STYLE=EGDefault > > 11 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared > > %20Files/BIClientStyles/EGDefault.c > > 11 ! ss") ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/ > > graph/v91/sasgraph.exe") > > 11 ! NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation; > > WARNING: Argument 1 to function TSLVL referenced by the %SYSFUNC or > > %QSYSFUNC macro function is out > > of range. > > 12 > > 13 %gaccessible; > > 14 options nodate nonumber nocenter; > > 15 > > 16 data test; > > 17 a="test1"; > > 18 b="testing1"; > > 19 output; > > 20 a="test2"; > > 21 b="testing2"; > > 22 output; > > 23 run; > > > NOTE: The data set WORK.TEST has 2 observations and 2 variables. > > NOTE: DATA statement used (Total process time): > > real time 0.00 seconds > > cpu time 0.00 seconds > > > 24 > > 25 proc printto print="c:\test.txt" new; > > 26 run; > > > NOTE: PROCEDURE PRINTTO used (Total process time): > > real time 0.00 seconds > > cpu time 0.00 seconds > > > 27 > > 28 proc print data=test noobs ; > > 29 title; > > 30 run; > > > The SAS System > > > NOTE: There were 2 observations read from the data set WORK.TEST. > > NOTE: PROCEDURE PRINT used (Total process time): > > real time 0.03 seconds > > cpu time 0.00 seconds > > > 31 > > 32 proc printto; > > 33 run; > > > NOTE: PROCEDURE PRINTTO used (Total process time): > > real time 0.04 seconds > > cpu time 0.00 seconds > > > 34 > > 35 %LET _CLIENTTASKLABEL=; > > 36 %LET _EGTASKLABEL=; > > 37 %LET _CLIENTPROJECTNAME=; > > 38 %LET _SASPROGRAMFILE=; > > 39 > > 40 ;*';*";*/;quit;run; > > 41 ODS _ALL_ CLOSE; > > 42 > > 43 > > 44 QUIT; RUN; > > 45
From: YingTzu Tan on 26 May 2010 22:24 Btw, the EG is running on my local PC On May 27, 9:59 am, YingTzu Tan <tying...(a)gmail.com> wrote: > It runs successfully in EG but the test.txt file is blank with 0kb. > > On May 26, 10:54 pm, Tom Abernathy <tom.aberna...(a)gmail.com> wrote: > > > > > It looks like it ran fine. What about it is not working? > > Did you look for the file on the C drive of the server that is running > > SAS? > > > On May 26, 5:41 am, sasuser sasuser <sasus...(a)gmail.com> wrote: > > > > I have the following codes, which run successfully in SAS 9.1 but when > > > I run it in EG, the output test.txt is blank. Can someone tell me why? > > > > options nodate nonumber nocenter; > > > > data test; > > > a="test1"; > > > b="testing1"; > > > output; > > > a="test2"; > > > b="testing2"; > > > output; > > > run; > > > > proc printto print="c:\test.txt" new; > > > run; > > > > proc print data=test noobs ; > > > title; > > > run; > > > > proc printto; > > > run; > > > > The EG log file is as following: > > > > 1 ;*';*";*/;quit;run; > > > 2 OPTIONS PAGENO=MIN; > > > 3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code); > > > 4 %LET _EGTASKLABEL=%NRBQUOTE(Code); > > > 5 %LET _CLIENTPROJECTNAME=%NRBQUOTE(); > > > 6 %LET _SASPROGRAMFILE=; > > > 7 > > > 8 ODS _ALL_ CLOSE; > > > NOTE: Some of your options or statements may not be supported with the > > > Activex or Java series of > > > devices. Graph defaults for these drivers may be different from > > > other SAS/GRAPH device > > > drivers. For further information, please contact Technical > > > Support. > > > 9 OPTIONS DEV=ACTIVEX; > > > 10 FILENAME EGHTML TEMP; > > > NOTE: Writing HTML(EGHTML) Body file: EGHTML > > > 11 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' > > > STYLE=EGDefault > > > 11 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared > > > %20Files/BIClientStyles/EGDefault.c > > > 11 ! ss") ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/ > > > graph/v91/sasgraph.exe") > > > 11 ! NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation; > > > WARNING: Argument 1 to function TSLVL referenced by the %SYSFUNC or > > > %QSYSFUNC macro function is out > > > of range. > > > 12 > > > 13 %gaccessible; > > > 14 options nodate nonumber nocenter; > > > 15 > > > 16 data test; > > > 17 a="test1"; > > > 18 b="testing1"; > > > 19 output; > > > 20 a="test2"; > > > 21 b="testing2"; > > > 22 output; > > > 23 run; > > > > NOTE: The data set WORK.TEST has 2 observations and 2 variables. > > > NOTE: DATA statement used (Total process time): > > > real time 0.00 seconds > > > cpu time 0.00 seconds > > > > 24 > > > 25 proc printto print="c:\test.txt" new; > > > 26 run; > > > > NOTE: PROCEDURE PRINTTO used (Total process time): > > > real time 0.00 seconds > > > cpu time 0.00 seconds > > > > 27 > > > 28 proc print data=test noobs ; > > > 29 title; > > > 30 run; > > > > The SAS System > > > > NOTE: There were 2 observations read from the data set WORK.TEST. > > > NOTE: PROCEDURE PRINT used (Total process time): > > > real time 0.03 seconds > > > cpu time 0.00 seconds > > > > 31 > > > 32 proc printto; > > > 33 run; > > > > NOTE: PROCEDURE PRINTTO used (Total process time): > > > real time 0.04 seconds > > > cpu time 0.00 seconds > > > > 34 > > > 35 %LET _CLIENTTASKLABEL=; > > > 36 %LET _EGTASKLABEL=; > > > 37 %LET _CLIENTPROJECTNAME=; > > > 38 %LET _SASPROGRAMFILE=; > > > 39 > > > 40 ;*';*";*/;quit;run; > > > 41 ODS _ALL_ CLOSE; > > > 42 > > > 43 > > > 44 QUIT; RUN; > > > 45
From: YingTzu Tan on 26 May 2010 23:55 I've managed to find the solution for this. It got something to do with EG default output. Apparently, the default output is to HTML. So I overwrite the output to text and it is working now. To do so, 1) right click and go to the properties of the task that runs the codes 2) go to results and click on "Override the preferences set in Tools - > Options " 3) check on "Text" only 4) click ok More information, go to: http://www.dummies.com/how-to/content/discovering-reporting-options-in-sas-enterprise-gu.html On May 27, 10:24 am, YingTzu Tan <tying...(a)gmail.com> wrote: > Btw, the EG is running on my local PC > > On May 27, 9:59 am, YingTzu Tan <tying...(a)gmail.com> wrote: > > > > > It runs successfully in EG but the test.txt file is blank with 0kb. > > > On May 26, 10:54 pm, Tom Abernathy <tom.aberna...(a)gmail.com> wrote: > > > > It looks like it ran fine. What about it is not working? > > > Did you look for the file on the C drive of the server that is running > > > SAS? > > > > On May 26, 5:41 am, sasuser sasuser <sasus...(a)gmail.com> wrote: > > > > > I have the following codes, which run successfully in SAS 9.1 but when > > > > I run it in EG, the output test.txt is blank. Can someone tell me why? > > > > > options nodate nonumber nocenter; > > > > > data test; > > > > a="test1"; > > > > b="testing1"; > > > > output; > > > > a="test2"; > > > > b="testing2"; > > > > output; > > > > run; > > > > > proc printto print="c:\test.txt" new; > > > > run; > > > > > proc print data=test noobs ; > > > > title; > > > > run; > > > > > proc printto; > > > > run; > > > > > The EG log file is as following: > > > > > 1 ;*';*";*/;quit;run; > > > > 2 OPTIONS PAGENO=MIN; > > > > 3 %LET _CLIENTTASKLABEL=%NRBQUOTE(Code); > > > > 4 %LET _EGTASKLABEL=%NRBQUOTE(Code); > > > > 5 %LET _CLIENTPROJECTNAME=%NRBQUOTE(); > > > > 6 %LET _SASPROGRAMFILE=; > > > > 7 > > > > 8 ODS _ALL_ CLOSE; > > > > NOTE: Some of your options or statements may not be supported with the > > > > Activex or Java series of > > > > devices. Graph defaults for these drivers may be different from > > > > other SAS/GRAPH device > > > > drivers. For further information, please contact Technical > > > > Support. > > > > 9 OPTIONS DEV=ACTIVEX; > > > > 10 FILENAME EGHTML TEMP; > > > > NOTE: Writing HTML(EGHTML) Body file: EGHTML > > > > 11 ODS HTML(ID=EGHTML) FILE=EGHTML ENCODING='utf-8' > > > > STYLE=EGDefault > > > > 11 ! STYLESHEET=(URL="file:///C:/Program%20Files/SAS/Shared > > > > %20Files/BIClientStyles/EGDefault.c > > > > 11 ! ss") ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/ > > > > graph/v91/sasgraph.exe") > > > > 11 ! NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation; > > > > WARNING: Argument 1 to function TSLVL referenced by the %SYSFUNC or > > > > %QSYSFUNC macro function is out > > > > of range. > > > > 12 > > > > 13 %gaccessible; > > > > 14 options nodate nonumber nocenter; > > > > 15 > > > > 16 data test; > > > > 17 a="test1"; > > > > 18 b="testing1"; > > > > 19 output; > > > > 20 a="test2"; > > > > 21 b="testing2"; > > > > 22 output; > > > > 23 run; > > > > > NOTE: The data set WORK.TEST has 2 observations and 2 variables. > > > > NOTE: DATA statement used (Total process time): > > > > real time 0.00 seconds > > > > cpu time 0.00 seconds > > > > > 24 > > > > 25 proc printto print="c:\test.txt" new; > > > > 26 run; > > > > > NOTE: PROCEDURE PRINTTO used (Total process time): > > > > real time 0.00 seconds > > > > cpu time 0.00 seconds > > > > > 27 > > > > 28 proc print data=test noobs ; > > > > 29 title; > > > > 30 run; > > > > > The SAS System > > > > > NOTE: There were 2 observations read from the data set WORK.TEST. > > > > NOTE: PROCEDURE PRINT used (Total process time): > > > > real time 0.03 seconds > > > > cpu time 0.00 seconds > > > > > 31 > > > > 32 proc printto; > > > > 33 run; > > > > > NOTE: PROCEDURE PRINTTO used (Total process time): > > > > real time 0.04 seconds > > > > cpu time 0.00 seconds > > > > > 34 > > > > 35 %LET _CLIENTTASKLABEL=; > > > > 36 %LET _EGTASKLABEL=; > > > > 37 %LET _CLIENTPROJECTNAME=; > > > > 38 %LET _SASPROGRAMFILE=; > > > > 39 > > > > 40 ;*';*";*/;quit;run; > > > > 41 ODS _ALL_ CLOSE; > > > > 42 > > > > 43 > > > > 44 QUIT; RUN; > > > > 45
|
Pages: 1 Prev: removing rows Next: Exporting 3D Graphs from SAS EIS to external formats- TIFF, GIF, PDF |