BookmarkSubscribeRSS Feed
BETO
Fluorite | Level 6
What is the syntax to create a hyperlink in a SAS data set then have it export out to Excel with a workable hyperlink?
I read up online one option is using ODS ... Thank you for your assitance
1 REPLY 1
Cynthia_sas
Diamond | Level 26
Hi,
It does depend on how you are getting your output from SAS into Excel. For example, if you are using Proc Export or ODS CSV then I would not expect a hyperlink to be possible because if you were just typing data in cells, you would have to use Excel drop down menus to create hyperlinks ...and those two methods are the equivalent of just typing data in cells -- with no way to control Excel menu items until you get the file opened in Excel.

But if you were using HTML or XML methods to send ODS output to a file that Excel could open (ODS MSOFFICE2K or ODS TAGSETS?EXCELXP) then it might be possible to do. Previous forum postings can be found by searching for these previous post numbers: 17219, 18602 and /or searching for how hyperlinks are created in Microsoft "flavor" of HTML (such as that created by ODS) or Microsoft 2003 "flavor" of XML (such as that created by ODS).

Cynthia

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1892 views
  • 0 likes
  • 2 in conversation