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