Prev: NLMIXED convergence with simulated ZINB
Next: "Uplift" Models
From: Jack Hamilton on 15 Jul 2008 13:24
I think the lack of a version number indicates that your version of the
tagset is fairly old.

Did you try looking at the tagset source with PROC TEMPLATE? I don't
remember whether TEMPLATE preserves any kind of comments when it
compiles a tagset.



On Tue, 15 Jul 2008 13:00:44 -0400, "Steven Raimi"
<sraimi(a)MarketingAssociates.com> said:
> Jack,
>
> No invisible characters or missing semicolons. Since I posted, I
> found the new-version download site. However, I wanted to find out the
> current version before stomping on it, and I can't find how to do that.
> Proc template doesn't seem to give any more info that the template name
> and type=TAGSET.
>
> Steven Raimi
> Database Development Manager
> sraimi(a)marketingassociates.com
>
> One Kennedy Square
> 777 Woodward Ave., Suite 500 - Detroit, Michigan 48226
> p 313.202.6338 - c 248.821.6428
> m 313.965.3000 - f 313.965.2800
> www.marketingassociates.com
>
> Complete Solutions
> Marketing Research Analysis - Strategic Communications - Marketing
> Information Services - Program Administration - Sales Promotion
>
>
>
>
> -----Original Message-----
> From: Jack Hamilton [mailto:jfh(a)alumni.stanford.org]
> Sent: Tuesday, July 15, 2008 11:56 AM
> To: Steven Raimi; sas-l(a)listserv.uga.edu
> Subject: Re: [SAS-L] Excelxp Tagsets: is there a way to create multiple
> sheets on the same file?
>
> Maybe there are some invisible characters in there somewhere?
>
> Also, if you are getting a message saying that ExcelXP is experimental,
> you are not using the current version. You should fix that problem
> first. Download the latest from
> <http://support.sas.com/rnd/base/ods/odsmarkup/>. I save it in a file
> and %INCLUDE it, but there are other ways.
>
> From my system:
> =====
> NOTE: SAS 9.1.3 SP4 (E9BX01)
>
> 1 ods tagsets.excelxp file='c:\temp\test.xls' style=statistical;
> NOTE: Writing TAGSETS.EXCELXP Body file: c:\temp\test.xls
> NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.86, 04/15/08). Add
> options(doc='help') to the
> ods statement for more information.
> 2 ods tagsets.excelxp options(sheet_interval='proc');
> NOTE: This is the Excel XP tagset (SAS 9.1.3, v1.86, 04/15/08). Add
> options(doc='help') to the
> ods statement for more information.
> =====
>
>
> On Tue, 15 Jul 2008 11:30:03 -0400, "Steven Raimi"
> <sraimi(a)MARKETINGASSOCIATES.COM> said:
> > Thanks Satindra, Jack, Mary, and others on this thread - this
> addresses a
> > problem I've been working around. However, I've tried to implement
> this
> > with v9.1.3 under Windows XP, and I've been getting the following
> error
> > in
> > my log:
> >
> > 2545 ods tagsets.excelxp file="y:\sas\2008 ad hocs\leads sales
> > match\Revised Counts with 9 sale
> > 2545! limit &sysdate..xml"
> > 2546 style=statistical;
> > NOTE: Writing TAGSETS.EXCELXP Body file: y:\sas\2008 ad hocs\leads
> sales
> > match\Revised Counts
> > with 9 sale limit 14JUL08.xml
> > NOTE: Experimental Excel XP tagset. Each table created will go in it's
> > own
> > worksheet.
> >
> >
> > (So that's okay, but then there's this:)
> >
> >
> > 2547 ods tagsets.excelxp options(sheet_interval='proc');
> > --------
> > 22 200
> > ERROR 22-322: Syntax error, expecting one of the following: ;, (,
> ANCHOR,
> > ARCHIVE, ATTRIBUTES,
> > AUTHOR, BASE, BODY, CHARSET, CLOSE, CODE, CONTENTS,
> DATA,
> > ENCODING, EVENT,
> > EXCLUDE, FILE, FRAME, GFOOTNOTE, GPATH, GTITLE,
> HEADTEXT,
> > METATEXT, NEWFILE,
> > NOGFOOTNOTE, NOGTITLE, OPERATOR, PAGE, PARAMETERS, PATH,
> > RECORD_SEPARATOR,
> > SELECT, SHOW, STYLE, STYLESHEET, TAGSET, TEXT, TRANTAB,
> > TYPE.
> >
> > ERROR 200-322: The symbol is not recognized and will be ignored.
> >
> > I've ruled out commenting problems, verified the statement spelling
> and
> > syntax against your posts, tried changing the file="" specification to
> > single quotes, but SAS won't accept the ods tagsets.excelxp options()
> > statement. Can anyone help?
> >
> > TIA,
> > Steve
>
>
> --
> Jack Hamilton
> Sacramento, California
> jfh(a)alumni.stanford.org <== Use this, not jfh(a)stanfordalumni.org
>
>
>


--
Jack Hamilton
Sacramento, California
jfh(a)alumni.stanford.org <== Use this, not jfh(a)stanfordalumni.org
First  |  Prev  | 
Pages: 1 2 3
Prev: NLMIXED convergence with simulated ZINB
Next: "Uplift" Models