https://communities.sas.com/t5/SAS-Procedures/Exporting-hyperlink-to-Excel-using-Proc-Export/m-p/67842#M19406 Hi.<BR /> I guess you use dbms=excel,<BR /> Maybe you need dbms=xls<BR /> But the url is also not emphasized by underline, you need to manual double click edit column (fx:....).<BR /> And maybe use Microsoft tag flag such as ' /url' around the address.<BR /> <BR /> <BR /> Ksharp Tue, 15 Feb 2011 10:07:32 GMT Ksharp 2011-02-15T10:07:32Z https://communities.sas.com/t5/SAS-Procedures/Exporting-hyperlink-to-Excel-using-Proc-Export/m-p/67841#M19405 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. <BR /> 1. how can I get rid of the single quotes, and<BR /> 2. is there a better way to do this? Tue, 01 Feb 2011 15:23:53 GMT https://communities.sas.com/t5/SAS-Procedures/Exporting-hyperlink-to-Excel-using-Proc-Export/m-p/67841#M19405 StatsPat 2011-02-01T15:23:53Z https://communities.sas.com/t5/SAS-Procedures/Exporting-hyperlink-to-Excel-using-Proc-Export/m-p/67842#M19406 Hi.<BR /> I guess you use dbms=excel,<BR /> Maybe you need dbms=xls<BR /> But the url is also not emphasized by underline, you need to manual double click edit column (fx:....).<BR /> And maybe use Microsoft tag flag such as ' /url' around the address.<BR /> <BR /> <BR /> Ksharp Tue, 15 Feb 2011 10:07:32 GMT https://communities.sas.com/t5/SAS-Procedures/Exporting-hyperlink-to-Excel-using-Proc-Export/m-p/67842#M19406 Ksharp 2011-02-15T10:07:32Z