Date: Tue, 29 Nov 2005 22:18:47 -0800
Reply-To: David L Cassell <davidlcassell@MSN.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David L Cassell <davidlcassell@MSN.COM>
Subject: Re: How to create a SAS transport
In-Reply-To: <200511292230.jATLPQGd004725@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed
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/
| 
