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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.