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?
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
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.