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.
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=;
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;
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.
26 %LET _CLIENTTASKLABEL=;
27 %LET _EGTASKLABEL=;
2 The SAS System 10:32 Wednesday, October 21, 2009
Yes, i open all tables including those 2. The most estrange is because i can see the both dataset results and i can export the 2 tables via wizard. Only in code Proc Export doesn’t work and doesn’t export.
There are 50 queries that end's with tables (x001, x002, etc) and only those 2 doesn't export.
but i find a "solution". if i save the query result on a sasuser server instead of saswork, the PROC EXPORT runs without errors...
thanks for your interess