I have several large files that I couldn't even open one file at a time.
It is taking 15 minutes for me to open each file. So I was thinking of
importing them into SAS and send them back as txt files. Or is there any
other idea for this?
Of course I have more than 100 xls files in that directory. But all I need
is 40 files to be converted into txt files.
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
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
Hope this is helpful.
Senior Programmer Analyst, IM&R
Russell Investment Group
Global Leaders in Multi-Manager Investing
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
Subject: How to change .xls files into .txt files in SAS
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