| Date: | Thu, 7 Jul 2011 19:26:33 -0700 |
|---|
| Reply-To: | Jack Hamilton <jfh@STANFORDALUMNI.ORG> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Jack Hamilton <jfh@STANFORDALUMNI.ORG> |
|---|
| Subject: | Re: Looking for ExcelXP feature |
|---|
|
| In-Reply-To: | <201107061150.p66AmSGn014425@waikiki.cc.uga.edu> |
|---|
| Content-Type: | text/plain; charset=UTF-8 |
|---|
The only way I've found to do it is with a data step - write all the data to an array, and then write the array to excel using the object oriented interface.
A lot of work, but it lets you do things that are otherwise not easy to do
--
jfh mobile
Richard Devenezia <rdevenezia@GMAIL.COM> wrote:
With destination tagsets.ExcelXP is there a way I can specify which tab and
cell the next output will start at?
This does not work...
----
ods tagsets.excelxp
file="%sysfunc(pathname(WORK))\sample.xls.xml"
options (sheet_name='one' sheet_interval='none');
;
proc print noobs data=sashelp.class;
run;
ods tagsets.excelxp
options (goto='G5') %* <--- anything like this ? ;
;
proc print noobs data=sashelp.class;
run;
ods tagsets.excelxp close;
----
Thanks,
Richard
| 
