Help using Base SAS procedures

Exporting hyperlink to Excel using Proc Export

Reply
N/A
Posts: 1

Exporting hyperlink to Excel using Proc Export

I am trying to export data that contains hyperlinks (to files on the same server) using Proc Export. I have created the addresses as character strings, but when I open the Excel spreadsheet, they have single quotes at the beginning, and the links won't work until I manually remove them.
1. how can I get rid of the single quotes, and
2. is there a better way to do this?
Super User
Posts: 9,687

Re: Exporting hyperlink to Excel using Proc Export

Hi.
I guess you use dbms=excel,
Maybe you need dbms=xls
But the url is also not emphasized by underline, you need to manual double click edit column (fx:....).
And maybe use Microsoft tag flag such as ' /url' around the address.


Ksharp
Ask a Question
Discussion stats
  • 1 reply
  • 246 views
  • 0 likes
  • 2 in conversation