Prev: Incorporating images in output
Next: proc gplot question
From: Captain on 18 Mar 2010 15:15
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.
From: Andrew Karp Sierra Info Services on 18 Mar 2010 17:27
On Mar 18, 12:15�pm, Captain <apsteinb...(a)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.

One method to try might be the EXCEL Libname Engine if you have SAS
Access to PC File Formats as part of your install.

I am not exactly sure what you mean, however, by an "ODS generated XLS
file." Strictly speaking, ODS cannot create a file in the proprietary
Microsoft Excel Spreadsheet file type. It _can_ create an HTML, CSV
or XML file, all of which can be opened by MS Excel Software.

One option you might want to explore is to save your SAS procedure
generated output as a SAS data set using the ODS Output destination
and then manipulate it in a SAS data step. I have several examples of
that approach in my ODS-related papers available for free download at
my company web site http://www.sierrainformation.com. Just click on
the "free downloads" link and take things from there.

Hope this helps...

Andrew Karp
Sierra Information Services
http://www.sierrainformation.com
 | 
Pages: 1
Prev: Incorporating images in output
Next: proc gplot question