The SAS Output Delivery System and reporting techniques

SAS ouput to existing excel spreadsheet

Reply
Super Contributor
Posts: 319

SAS ouput to existing excel spreadsheet

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!
Super Contributor
Posts: 260

Re: SAS ouput to existing excel spreadsheet

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
Super Contributor
Posts: 319

Re: SAS ouput to existing excel spreadsheet

Thanks! I'll try that one out
N/A
Posts: 0

Re: SAS ouput to existing excel spreadsheet

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
Ask a Question
Discussion stats
  • 3 replies
  • 164 views
  • 0 likes
  • 3 in conversation