I have a report that outputs about 60 tabs plus a table of contents page to jump to them. At my last job, we used SAS 9.2 and Office 2007, and the report worked fine. Now, with Office 2010 and SAS 9.3, the links only work in the original document. I've determine this is because the hyperlink contains the full URL, instead of just the sheet name (I don't know if the change is from SAS 9.3 or something inherent to Office 2010, but I find it irritating, either way). I need to be able to send this report to other individuals, so I need the hyperlink to work no matter where the file is stored.
I came across this post - https://communities.sas.com/message/31142 - which seems to be discussing my exact problem, but when I try to follow the links, I'm told I don't have permission to view the page.
Can anybody help?
Here's the code I'm currently using. Note: Community1 - Community60 references a list of the 60 communities that are covered in the report - the source of my 60 tabs.
%macro run_tagset;
ods listing close;
ods tagsets.ExcelXP file="C:\Users\[blah blah blah]\Community_Report_&sysdate..xml" style=statistical;
%do i=1 %to &tabs.;
ods tagsets.ExcelXP options(sheet_name="&&Community&i." index='on');
proc print data=All_Stats noobs;
where Community_Name = "&&Community&i.";
run;
%end;
ods tagsets.ExcelXP close;
ods listing;
%mend run_tagset;
%run_tagset;
Thanks!
Hi:
I think the message that the post pointed to got moved or something. When I searched for the topic, I found this link, which has code:
https://communities.sas.com/message/17739#17739
But I'm not sure about the full URL versus getting only the sheet name. You may need to work with Tech Support on that part of the question.
cynthia
Hi,
I have the exactly same issue when I use the SAS 9.4. Did you find a way to solve this problem?
Thank you very much!
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: