Date:         Thu, 18 Mar 2010 15:43:04 -0400
Reply-To:     Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject:      Re: reading xls without proc import or changing file type

So if you not sold on xls and you need it in SAS, why not writing it to a
SAS dataset?
This is from documentation:

ods output Table=energyoutput(keep=region division type expenditures_sum);


You can use that e.g. for PROCs, which normally have no SAS output
dataset, like TABULATE.

Gerhard





On Thu, 18 Mar 2010 12:15:31 -0700, Captain <apsteinberg@HOTMAIL.COM>
wrote:

>I am trying to figure out a way to read an ods generated xls file from
>sas that has been manipulated back into sas without using a proc
>import or changing the file to csv or another file type.  I am a can
>not use any sas interactive features such as dde.  Additionally I am
>not sold on the output from sas to xls so if you have have a better
>method that is ok as well.