Date:         Sat, 31 Jan 2004 00:09:23 GMT
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: converting .trf files to .xls

Mayukh,

Have you tried using proc cimport? E.g.,
proc cimport file='F:\01dmef100.trf' data=whatever;
run;


Art

-----------

"Mayukh Dass" <dass@UGA.EDU> wrote in message
news:001e01c3e785$8de249f0$2202a8c0@Dreamer...
> 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;