Hi,
I’m trying to output a lot of query results to a Excel workbook. All querys export correctly with the exception of the last 2 of them. This first part is the code that runs all correctly if I remove the last 2 code. In the end, that’s the log-report. I’ve check the server, check the table name, I’ve check if the table runs or not, I’ve tried to change the label of the columns, format the numbers. The most strange is that all tables are very similar, all export except that 2. I’m already sick with this. Please help me.
code --- >>>----------------------------------------------------------------------------------->>>
PROC EXPORT DATA= WORK.EXP_X005
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X005";
PROC EXPORT DATA= WORK.EXP_X008_1
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X008_1";
PROC EXPORT DATA= WORK.EXP_X008_2
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X008_2";
PROC EXPORT DATA= WORK.EXP_X009_X032
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X009_X032";
PROC EXPORT DATA= WORK.EXP_X011_1
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X011_1";
PROC EXPORT DATA= WORK.EXP_X011_2
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X011_2";
PROC EXPORT DATA= WORK.EXP_X013
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X013";
PROC EXPORT DATA= WORK.EXP_X014
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X014";
PROC EXPORT DATA= WORK.EXP_X015
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X015";
PROC EXPORT DATA= WORK.EXP_X016
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X016";
PROC EXPORT DATA= WORK.EXP_X017
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X017";
PROC EXPORT DATA= WORK.EXP_X018
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X018";
PROC EXPORT DATA= WORK.EXP_X019
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X019";
PROC EXPORT DATA= WORK.EXP_X024
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X024";
PROC EXPORT DATA= WORK.EXP_X003
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X003";
PROC EXPORT DATA= WORK.EXP_X020
OUTFILE= "E:\base.xls"
DBMS=EXCEL REPLACE;
SHEET="EXP_X020";
RUN;
log error --- >>>----------------------------------------------------------------------------------->>>
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL=%NRBQUOTE(TESTEE resultados);
4 %LET _EGTASKLABEL=%NRBQUOTE(TESTEE resultados);
5 %LET _CLIENTPROJECTNAME=%NRBQUOTE(E:\Rx Docs\GCS\Rx SAS Projects\Projectos
5 ! Efectivos\GIGA FILES\100 Indicadores Gestão v1.egp);
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
11 ! .css") ATTRIBUTES=("CODEBASE"="http://www2.sas.com/codebase/graph/v91/sasgraph.exe")
11 ! NOGTITLE NOGFOOTNOTE GPATH=&sasworklocation;
12
13 %gaccessible;
14 PROC EXPORT DATA= WORK.EXP_X003
15 OUTFILE= "E:\base.xls"
16 DBMS=EXCEL REPLACE;
17 SHEET="EXP_X003";
1 The SAS System 12:02 Thursday, October 22, 2009
ERROR: File WORK.EXP_X003.DATA does not exist.
18 PROC EXPORT DATA= WORK.EXP_X020
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.71 seconds
cpu time 0.06 seconds
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
19 OUTFILE= "E:\base.xls"
20 DBMS=EXCEL REPLACE;
21 SHEET="EXP_X020";
22
23 RUN;
1 The SAS System 12:02 Thursday, October 22, 2009
ERROR: File WORK.EXP_X020.DATA does not exist.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.54 seconds
cpu time 0.06 seconds
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
24
25
26 %LET _CLIENTTASKLABEL=;
27 %LET _EGTASKLABEL=;
2 The SAS System 10:32 Wednesday, October 21, 2009
28 %LET _CLIENTPROJECTNAME=;
29 %LET _SASPROGRAMFILE=;
30
31 ;*';*";*/;quit;run;
32 ODS _ALL_ CLOSE;
33
34
35 QUIT; RUN;
36