Date:         Fri, 30 Jan 2004 18:05:28 -0500
Reply-To:     Mayukh Dass <dass@UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mayukh Dass <dass@UGA.EDU>
Subject:      converting .trf files to .xls
Content-Type: text/plain; charset="us-ascii"

Hi,

I have a SAS transportable file  in .trf  and I need to convert it to
.xls file. I tried the following, but got an error.

Please help.

Mayukh


libname  tranfile  xport  "F:\01dmef100.trf" ;
 proc contents  data=tranfile._ALL_ ;
run;

proc export data= transfile.one
            outfile= "C:\test.xls"
            DBMS=excel2000 replace;
run;


but it is saying:



4
5    proc export data= transfile.one
6                outfile= "C:\test.xls"
7                DBMS=excel2000 replace;
ERROR: Libname TRANSFIL is not assigned.
ERROR: Export unsuccessful.  See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used:
      real time           1.62 seconds
      cpu time            0.06 seconds

8    run;