Date:         Tue, 7 Dec 2010 06:16:58 -0800
Reply-To:     "DUELL, BOB (ATTCINW)" <BD9439@ATT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "DUELL, BOB (ATTCINW)" <BD9439@ATT.COM>
Subject:      Re: ods tagsets.EXCELXP options
Comments: cc: js8765@GOOGLEMAIL.COM
In-Reply-To:  <201012071303.oB7Blo5A025719@willow.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Quick reference:
http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_help.html

To print the documentation to your SAS log, run this:

ODS tagsets.excelxp file="test.xml" options(doc="help");

Be sure to notice which version of the tagset you have installed!

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Gerhard Hellriegel
Sent: Tuesday, December 07, 2010 5:03 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: ods tagsets.EXCELXP options

I don't know much about tagsets, but I think that they are simply
formatting options, not something what has influence on contents. If I
use
HTML for example, I can influence colors, fonts, layout options and
more,
but what is printed comes from the proc I use.
What is that for EXCEL? PROC EXPORT or something like that? I think that
there are options for the behaviour you expect.

Gerhard




On Tue, 7 Dec 2010 11:35:14 +0100, js8765 <js8765@GOOGLEMAIL.COM> wrote:

>Hi,
>
>I was wondering if anyone knows where there is documentation on the
>options available for ods tagsets.EXCELXP. I have searched extensively
>and can only find information on ods tagsets in general and not for the
>EXCELXP mode.
>
>In particular, I was trying to find which option would place the
>variable name as opposed to the variable label in the top row on each
>excel sheet.
>
>Thanks in advance for any advice!