Date: Fri, 23 Jun 2006 12:11:14 -0700
Reply-To: "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Terjeson, Mark (IM&R)" <Mterjeson@RUSSELL.COM>
Subject: Re: How to change .xls files into .txt files in SAS
Content-Type: text/plain; charset="us-ascii"
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