Prev: Untitled
Next: The Long and Winding Road to SAS Global Forum 2010
From: Amar Mundankar on 12 Feb 2010 02:39
Hi all,
While executing following code, I am getting error as :
ERROR: Execute: Unable to insert row :

What can be the reason????

Below is the CODE and LOG.

CODE:

LIBNAME SD2 "G:\AppData\InfoOne_SAS\adhoc\IMP\CV\SASDATA";
DATA TEST_PAY;
SET SD2.FPR_ECS_DIST;
WHERE substr(DISTRICT,1,4)= '4Z17';
RUN;


PROC EXPORT DATA = TEST_PAY dbms=excel2000 OUTFILE = "\\tsclient\G
\PUBLIC\! Warning - Files In This Directory are Deleted every 15 days
\Sample\FPR_QC\ECSPAYDIST"; RUN;


LOG:
/*===============================================*/
LIBNAME SD2 "G:\AppData\InfoOne_SAS\adhoc\IMP\CV\SASDATA";
NOTE: Libref SD2 was successfully assigned as follows:
Engine: V9
Physical Name: G:\AppData\InfoOne_SAS\adhoc\IMP\CV\SASDATA
2 DATA TEST_PAY;
3 SET SD2.FPR_ECS_DIST;
NOTE: Data file SD2.FPR_ECS_DIST.DATA is in a format native to another
host or the file encoding
does not match the session encoding. Cross Environment Data
Access will be used, which may
require additional CPU resources and reduce performance.
4 WHERE substr(DISTRICT,1,4)= '4Z17';
5 RUN;

NOTE: There were 122700 observations read from the data set
SD2.FPR_ECS_DIST.
WHERE SUBSTR(DISTRICT, 1, 4)='4Z17';
NOTE: The data set WORK.TEST_PAY has 122700 observations and 47
variables.
NOTE: DATA statement used (Total process time):
real time 40.21 seconds
cpu time 14.75 seconds


6
7 PROC EXPORT DATA = TEST_PAY dbms=excel2000 OUTFILE = "\\tsclient\G
\PUBLIC\! Warning - Files
7 ! In This Directory are Deleted every 15 days\Sample\FPR_QC
\ECSPAYDIST"; RUN;

NOTE: New file "\\tsclient\G\PUBLIC\! Warning - Files In This
Directory are Deleted every 15
days\Sample\FPR_QC\ECSPAYDIST.XLS" will be created if the export
process succeeds.
ERROR: Execute: Unable to insert row
WARNING: File deletion failed for _IMEX_.TEST_PAY.DATA.
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 15.63 seconds
cpu time 11.07 seconds
/* ===========================================*/




Regards,
Amar Mundankar.
 | 
Pages: 1
Prev: Untitled
Next: The Long and Winding Road to SAS Global Forum 2010