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?
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.