|Date: ||Sat, 30 Aug 1997 21:20:06 -0400|
|Reply-To: ||Anthony Ayiomamitis <ayiomamitis@IBM.NET>|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||Anthony Ayiomamitis <ayiomamitis@IBM.NET>|
|Subject: ||Re: Converting excel (xls) file to flat (ASCII) file?|
|Content-Type: ||text/plain; charset=us-ascii|
Ming-Shan Wang wrote:
> Hi, SAS Users,
> I have a big excel (xls) file (1,277K bytes). How can I convert this file
> to flat (SASCII) file so that I can manipulate the data using SAS codes?
> Or, is there another way to do it without convertion?
> Your thoughts and answers will be much appreciated.
> Thanks in advance.
> Ming-Shan Wang
You can avoid the ASCII intermediate step by reading the EXCEL
spreadsheet directly from within SAS. Have a look at PROC ACCESS which
will describe eveything you need. Alternatively, type ACCESS at the
command line and follow the various prompts and screens as they should