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?
>
 
Manuel,
 
    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';
         labels;
         reset;   /* plus other options .... */
    run;
 
    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).
 
Anthony.