topic Re: SAS ouput to existing excel spreadsheet in ODS and Base Reporting

SAS ouput to existing excel spreadsheet

milts — Thu, 31 Jul 2008 03:08:55 GMT

Hi!

Is it possible to send your output to an existing worksheet, and specifying where row and column to put it, and overwriting if the certain cells already have values in it? If it's possible how can it be done?

Thanks!

Re: SAS ouput to existing excel spreadsheet

Olivier — Thu, 31 Jul 2008 07:01:18 GMT

Hi.
To my opinion, there are only two ways to do that :
1) to write ODS to a DDE filename, using a dedicated ODS TAGSET (some can be found on the Internet) ;
2) to write the Output to a dataset with ODS OUTPUT, and then use proc Export to send the dataset where you want -- provided you have licence for SAS/Access to PC Files.

Olivier

Re: SAS ouput to existing excel spreadsheet

milts — Thu, 31 Jul 2008 07:06:59 GMT

Thanks! I'll try that one out

Re: SAS ouput to existing excel spreadsheet

deleted_user — Thu, 31 Jul 2008 07:14:22 GMT

Hi,
I am trying to use the LIBNAME statement to read and write the data from/into the excel file. To access I use also the named ranges as mentioned in http://www2.sas.com/proceedings/sugi31/024-31.pdf

I have the the following question:
is there any possibility to write the SAS data into MS Excel named range without writing the variable names? (I have found the libname option HEADER=NO that for reading without varnames, but this doesn't work when writing into excel).

My SAS version is 9.1.3.

Thank you in advance!
Jaroslav