Date:         Fri, 12 Feb 2010 05:02:29 -0800
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Error in Proc Export (ERROR: Execute: Unable to insert row : )
Comments: To: Amar Mundankar <amarmundankar@gmail.com>
In-Reply-To:  <aebb667c-451e-4a23-9865-19cd649665d6@u19g2000prh.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

Amar,

Sounds like the file already exists.  If you have the correct write
permission, you might succeed with including the REPLACE option.

HTH,
Art
-----------
On Feb 12, 2:39 am, Amar Mundankar <amarmundan...@gmail.com> wrote:
> 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.