tagset.excelXP? HELP! =)

[RUFFyamahaRYDER]

I was researching how to have ODS output to excel and change the orientation to landscape plus change other little options and ran across tagset.excelXP. (

http://support.sas.com/rnd/base/topics/odsmarkup/excltags.tpl)

I downloaded it, modified some colwidth stuff and ran it. The problem is when I try to do anything with it I get an error. Here is my code:
/*******************/
ods tagsets.ExcelXP file="P:\MyDocs\rrt\RRT_Report.xls"
options(row_repeat='header'
embedded_titles='yes'
frozen_headers='yes'
scale='100'
orientation='landscape'
sheet_name='Report'
)
/*style=styles.kaisersmall*/
;
proc print data=rrt noobs;
where DATE gt 17045;
var ID DATE location Primary_reason Outcome Service time Arrived Event_ended DURATION;
Title1 justify=center "RRT Output";
Footnote1 justify=left "Location: 'insert later'";
run;
ods tagsets.excelXP close;
/***********************/
Here is the error:

64492 ods tagsets.ExcelXP file="P:\MyDocs\rrt\RRT_Report.xls"
64493 options(row_repeat='header'
-------
22
ERROR 22-322: Syntax error, expecting one of the following: ;, (, ANCHOR, ARCHIVE, ATTRIBUTES, AUTHOR, BASE, BODY, CHARSET,
CLOSE, CODE, CONTENTS, DATA, ENCODING, EVENT, FILE, FRAME, GFOOTNOTE, GPATH, GTITLE, HEADTEXT, METATEXT,
NEWFILE, NOGFOOTNOTE, NOGTITLE, OPERATOR, PAGE, PARAMETERS, PATH, RECORD_SEPARATOR, STYLE, STYLESHEET, TAGSET,
TEXT, TRANTAB, TYPE.

64494 embedded_titles='yes'
64495 frozen_headers='yes'
64496 scale='100'
64493 options(row_repeat='header'
-
200
ERROR 200-322: The symbol is not recognized and will be ignored.


Any help would be greatly appreciated.

 

[ChrisW75]

Hi Ruff,
I've used the ExcelXP tagset extensively and also made some modifications to it, however, I've not seen this error before. I'd ask two questions.
1 - What version of SAS are you using? The ExcelXP tagset only works with 9.1 and above I think.
2 - Are you sure that this is the source of the error? It looks almost like the previous step hasn't completed correctly, perhaps a missing semi-colon or something. Try taking the code out separately in a clean SAS session and making sure it works on it's own, what you've shown there as your code looks identical to what I do.

Maybe try undoing the changes you've made to the tagset if it doesn't work on it's own.

There's some in depth coverage of this topic in an earlier post on this forum if you want to have a go at tweaking the tagset.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.

 

[RUFFyamahaRYDER]

Hey ChrisW75,

I'm using SAS 9.1. I double checked for errors above this code but there were none. In fact, I can output using ODS PDF just fine using the same dataset. It's almost like SAS doesn't know what to do with the options()...

The changes I made to the tagset were needed to make it work on my machine. It had something to do with the column width variables. I think you ran into that same problem (I read a lot of previous posts on this).

I'm going to upgrade to 9.1.3 and see if that does the trick. If you have any other ideas I'm willing to give it a shot since it will take a few days to get 9.1.3 on here.

Thanks!

 

[ChrisW75]

The 9.1.3 upgrade might do the trick. Yeah, the column width thing was a bit shonky in the initial version. I fed back to them my fixes, and they said they were incorporating them into the next version. No idea what happened to them.


Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.