Date: Thu, 31 Jul 1997 12:59:36 -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: Saving a dataset into an ascii file
Content-Type: text/plain; charset=us-ascii
Manuel Garcia-Ayuso wrote:
> Hello, there,
> I am a SAS beginner and this is my first time in comp.soft-sys.sas, so
> sorry if my question is too naive.
> Can anyone tell me if it is possible to save a SAS dataset in ascii
> format so that it can be retrieved with Excel or handled with some
> other statistical package/languaje?
If the ultimate destination of your SAS dataset is Excel, then have
a look at PROC DBLOAD which will do exactly what you want ...
proc dbload dbms=xls data=manuel;
path = 'c:\manuel.xls';
reset; /* plus other options .... */
Now, if your target is also other languages/applications etc, look
up a SUGI paper from about 2 years called %FLATFILE which will take a
SAS dataset and dump it out in ASCII format.
If you would like to invest an hour, write such a macro yourself
which will do exactly the same thing ... it is a very easy task (have a
look at the dictionary tables for supplemental information).