Thank you very much for your valuable suggestions. Perhaps, as you suggested, there was already an incomplete file on the I drive before I sent the command. I deleted the file now and ran the proc copy command again. I am waiting to see the results. Thank you very much for the assistance. I'll let you know the results.

Libin

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of David L Cassell Sent: Wednesday, November 30, 2005 1:19 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: How to create a SAS transport

Libin.Xu@IRS.GOV wrote: > I submitted the question to the list a few months ago and got the >problem solved. Due to a server problem, I lost four-month files including >the SAS syntax file to create a SAS transport file. Now I could not get the >SAS program to generate the transport file. Searching the SAS Help and >Documentation and SAS web site with the key word transport file did not >help >me very. Can anyone there give me a hint on this? I attach part of the log >file below for you to review. Thanks a lot. > >Libin > >LOG: > >LIBNAME INSOURCE 'I:\'; > >NOTE: Libref INSOURCE was successfully assigned as follows: > > Engine: V9 > > Physical Name: I:\ > > LIBNAME TRANS XPORT 'I:\TransRet.XPT'; > >NOTE: Libref TRANS was successfully assigned as follows: > > Engine: XPORT > > Physical Name: I:\TransRet.XPT > > > > > > DATA tranfile; > > SET &tranfile; > > RUN; > > > > PROC COPY IN=work OUT=trans; > > SELECT tranfile; > > RUN; > > > >NOTE: Copying WORK.TRANFILE to TRANS.TRANFILE (memtype=DATA). > >NOTE: There were 5858 observations read from the data set WORK.TRANFILE. > >ERROR: Undetermined I/O failure. > >ERROR: File TRANS.TRANFILE.DATA has not been saved because copy could not >be >completed. >NOTE: Statements not processed because of errors noted above. > >NOTE: PROCEDURE COPY used (Total process time): > > real time 54.85 seconds > > cpu time 0.34 seconds > > > >NOTE: The SAS System stopped processing this step because of errors.

You forgot a part. You are not using any macro debugging options, like MPRINT, so no one can tell what your &TRANFILE is, or what that could mean here.

But the code looks okay, and the note suggests that SAS likes it. Where is your I: drive? Is it a network drive? It looks as though you had an I/O problem, which might not be connected with your code. Was there already a file 'I:\TransRet.XPT' on your drive? If so, then the problem could be that it was locked, or has privileges keeping SAS from writing to it, or something like that.

Maybe you could try again, and not use drive I: , and see how things go.

HTH, David -- David L. Cassell mathematical statistician Design Pathways 3115 NW Norwood Pl. Corvallis OR 97330

_________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/