Re: How to change .xls files into .txt files in SAS

Hi Gadde,

Can you just open them in Excel,
do a SaveAs, change the filetype
to .txt and click OK?

or do you have so many files that
you want to automate this process?

Are you wanting SAS to find all the
..xls files in a directory and then
convert and output them? SAS can
do that.

and if you have so many files, we
have to ask if these are of "like"
things, and would it not be better
to have them consolidated, but of
course we have no idea what you
circumstances are.




Hope this is helpful.


Mark Terjeson
Senior Programmer Analyst, IM&R
Russell Investment Group


Russell
Global Leaders in Multi-Manager Investing






-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
SUBSCRIBE SAS-L Chandra Gadde
Sent: Friday, June 23, 2006 11:57 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: How to change .xls files into .txt files in SAS


Hi All,

I have several excel files saved in a directory. How can I change all
the excel files into .txt files in SAS? Is there a way to do that? I
think we can import one file at a time into SAS and then send them back
as text files. Please help me if there is a possibility to do this.

Thanks for the help

Gadde