SAS ouput to existing excel spreadsheet

[milts]

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!

[Olivier]

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

[milts]

Thanks! I'll try that one out

[deleted_user]

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