| 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
Ming,
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
be straight-forward.
Anthony.
|
