Date:         Thu, 7 Jul 2005 17:24:49 -0400
Reply-To:     "P. Gao" <pgao79@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "P. Gao" <pgao79@YAHOO.COM>
Organization: Columbia University
Subject:      Re: Proc Export error
Comments: To: sas-l@uga.edu

Thanks for your input. Here is the code.

PROC EXPORT DATA= WITHDRAW.Rg_u34ago

OUTFILE= "D:\ermineJ 2.1 annotation files\RG-U34A GO.xls"

DBMS=EXCEL REPLACE;

SHEET=U34aGO;

RUN;



""Howard Schreier <hs AT dc-sug DOT org>"" <nospam@HOWLES.COM> wrote in
message news:200507071916.j67JGOQh013388@listserv.cc.uga.edu...
> It's hard to say without more information. 65K would be an issue if Excel
> is the target, but the ERROR regarding inserting a row smells more like a
> DBMS.
>
> Please idenify the target and show code.
>
> On Thu, 7 Jul 2005 12:13:52 -0400, P. Gao <pgao79@YAHOO.COM> wrote:
>
>>Hi, all,
>>
>>I just realize that my dataset has more than 65K observations. It must be
> the cause for the error. Please let me know if it is not the case. Thanks.
>
> On Thu, 7 Jul 2005 12:02:49 -0400, P. Gao <pgao79@YAHOO.COM> wrote:
>
>>Hi, all,
>>
>>This is my first time using SAS9.1. I keep getting the following error no
> matter the Export wizard or a program is  used. Can someone help me out
> here? Thank you.
>>
>>  ERROR: Execute: Unable to insert row
>>
>>  WARNING: File deletion failed for _IMEX_.U34AGO.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 6.54 seconds
>>
>>  cpu time 5.51 seconds
>>
>>Best,
>>
>>P.