Prev: Proc Template
Next: Drop down to SCL and R in your datastep
From: Sid N on 23 Feb 2010 15:29
Hi all,

Here is my environment:
OS: Windows 7 64-bit
Application: SAS 9.2
ExcelXP tagsets version 1.94

I am trying to use the ODS tagsets.excelxp to output data from a TABULATE
procedure using the options (sheet_interval = 'bygroup' contents = 'yes').
The generated "contents" worksheet does not have valid hyperlinks to the
other "bygroup" worksheets; when I looked at the links in the "contents"
worksheet, I see that the single quotes around the worksheet names are
missing, which is causing the links to give the "Reference is not valid"
error. However, the hyperlinks are working well when I use the "contents
= 'yes'" option without the "sheet_interval = 'bygroup'" option. Has any
one faced this problem before? I am not sure if this has to do with the OS
or the tagsets file. I appreciate your suggestions.

Thanks,
Sid
 | 
Pages: 1
Prev: Proc Template
Next: Drop down to SCL and R in your datastep