Hyperlinking in Excel using ODS Excel and PROC REPORT

[cgsmoak56]

Hi,

I am using ODS Excel and PROC REPORT to generate an Excel spreadsheet with multiple worksheets. I am not using tagsets because my understanding is that ExcelXP with tagsets cannot produce an .xlsx file. So, I am specifically looking for a solution using ODS Excel.

In the Excel spreadsheet there is a worksheet called Datasets, The first column is called Domain and can have 30 to 40 values like AE, CM, DM, DS, etc. Each of these domains (AE, CM, DM, DS, etc) can have there own worksheet in the Excel file with specification for creating the particular dataset (AE, CM, DM, DS). The Datasets worksheet provides a general description of each dataset to be created.

What I want to do is to hyperlinking each domain listed in the Datasets tab to the specific worksheet in the Excel file.  For example, I want to be able to click on AE in the Datasets worksheet and have it take me to the AE worksheet in the Excel file.

Thank you in advance for any suggestions. I appreciate it very much.

[Reeza · Accepted solution]

I would first play around in Excel and figure out what you need that hyper link to look like internally - so what does the variable you need to create look like in Excel?
https://www.ablebits.com/office-addins-blog/2014/05/15/excel-insert-hyperlink/

Then figure out how to create that formula in ODS EXCEL using PROC REPORT, example here:.
https://communities.sas.com/t5/ODS-and-Base-Reporting/Hyperlinking-sheets-within-SAS-ODS-Excel/td-p/...

[cgsmoak56]

Thank you. I think that I am on the right path now in figuring out the link in Excel and then seeing how to apply it to PROC REPORT.