ODS to multiple Excel worksheets - sheet_name option not
in [SAS]
|
Prev: ODS to multiple Excel worksheets - sheet_name option not working
Next: Relative risk and odds ratio, OR significant and above 1,
From: Gerhard Hellriegel on 9 Oct 2009 11:42 still it would be nice to see the code! Gerhard On Fri, 9 Oct 2009 11:39:45 -0400, mart <martino123(a)HOTMAIL.CO.UK> wrote: >Well the subject describes it all. >I've successfully got multiple worksheets working in Excel 2007, but for >some reason the Sheet_name option doesn't work and I keep getting the >defaults. >I tried downloading the latest 9.1 drivers. > >I have version 9.1.3
From: Joe Matise on 9 Oct 2009 13:16 Sometimes very tempted to agree :) Assuming this is your question and not a reply to something, verify that you are: 1) using the latest version of the tagsets (check on the SAS website) 2) not reopening the file in between - I think you have to do: ods tagsets.excelxp file="file" sheet_name="sheet"; (stuff) ods tagsets.excelxp sheet_name="othersheet"; (stuff) .... ods tagsets.excelxp close; instead of specifying the file each time - when I do that, anyhow, it recreates the file from scratch. -Joe On Fri, Oct 9, 2009 at 11:44 AM, Hurley, Sharon < Sharon.Hurley(a)uphs.upenn.edu> wrote: > Hi, > > > > Excel is a menace and should be outlawed. > > > > - SH > > > > The information contained in this e-mail message is intended only for the > personal and confidential use of the recipient(s) named above. If the reader > of this message is not the intended recipient or an agent responsible for > delivering it to the intended recipient, you are hereby notified that you > have received this document in error and that any review, dissemination, > distribution, or copying of this message is strictly prohibited. If you have > received this communication in error, please notify us immediately by > e-mail, and delete the original message. >
From: Joe Matise on 9 Oct 2009 13:17 Ahah, it was indeed a reply to something, well, consider this replied to the original post :) -Joe On Fri, Oct 9, 2009 at 12:16 PM, Joe Matise <snoopy369(a)gmail.com> wrote: > Sometimes very tempted to agree :) > > Assuming this is your question and not a reply to something, verify that > you are: > 1) using the latest version of the tagsets (check on the SAS website) > 2) not reopening the file in between - I think you have to do: > > ods tagsets.excelxp file="file" sheet_name="sheet"; > (stuff) > ods tagsets.excelxp sheet_name="othersheet"; > (stuff) > ... > ods tagsets.excelxp close; > > instead of specifying the file each time - when I do that, anyhow, it > recreates the file from scratch. > > -Joe > > > On Fri, Oct 9, 2009 at 11:44 AM, Hurley, Sharon < > Sharon.Hurley(a)uphs.upenn.edu> wrote: > >> Hi, >> >> >> >> Excel is a menace and should be outlawed. >> >> >> >> - SH >> >> >> >> The information contained in this e-mail message is intended only for the >> personal and confidential use of the recipient(s) named above. If the reader >> of this message is not the intended recipient or an agent responsible for >> delivering it to the intended recipient, you are hereby notified that you >> have received this document in error and that any review, dissemination, >> distribution, or copying of this message is strictly prohibited. If you have >> received this communication in error, please notify us immediately by >> e-mail, and delete the original message. >> > >
From: Jack Hamilton on 9 Oct 2009 13:46 Excel is good solution for displaying data and making simple graphs. It's not good for data entry, as a substitute for a database, as a statistical engine, or for dealing with historical dates. It can be good as the framework for non-statistical programs, but most Excel users are analysts, not programmers, and may not have received the training needed to create defensible programs. -- Jack Hamilton jfh(a)alumni.stanford.org Tots units fem for�a! On Oct 9, 2009, at 9:44 am, Hurley, Sharon wrote: > Hi, > > > > Excel is a menace and should be outlawed. > > > > - SH > > > > The information contained in this e-mail message is intended only > for the personal and confidential use of the recipient(s) named > above. If the reader of this message is not the intended recipient > or an agent responsible for delivering it to the intended recipient, > you are hereby notified that you have received this document in > error and that any review, dissemination, distribution, or copying > of this message is strictly prohibited. If you have received this > communication in error, please notify us immediately by e-mail, and > delete the original message.
From: Mary on 9 Oct 2009 13:51
Make sure you are using Excel Tagsets- perhaps you are trying ODS HTML? ods listing close; ods tagsets.excelxp file='c:\temp\out.xml' style=style1 options(default_column_width='20,20,10,10,10,10,10,10,10,10,10,10,10,10,10' sheet_label=' ' autofit_height="yes" ORIENTATION = 'landscape' center_horizontal = 'yes' center_vertical = 'yes' PRINT_FOOTER = "run 10/2/2009"); ods tagsets.excelxp options(sheet_name="Sheet1" default_column_width='20,20,10,10,10,10,10,10,10,10,10,10,10,10,10'); proc report... ods tagsets.excelxp options(sheet_name="Sheet2" default_column_width='20,20,10,10,10,10,10,10,10,10,10,10,10,10,10'); proc report... ods tagsets.excelxp close; ods listing; -Mary --- martino123(a)HOTMAIL.CO.UK wrote: From: mart <martino123(a)HOTMAIL.CO.UK> To: SAS-L(a)LISTSERV.UGA.EDU Subject: ODS to multiple Excel worksheets - sheet_name option not working Date: Fri, 9 Oct 2009 11:39:45 -0400 Well the subject describes it all. I've successfully got multiple worksheets working in Excel 2007, but for some reason the Sheet_name option doesn't work and I keep getting the defaults. I tried downloading the latest 9.1 drivers. I have version 9.1.3 |