Hello Folks, I am having trouble using a variable containing URL values to insert hyperlinks in my Excel output that is generated using the ExcelXP tagset. Here's a short program that generates the results I want in the first Proc Report but I need to use a variable like in the second Proc Report instead of the hard coding: data air; length URL $30; set sashelp.air(obs=10); URL = 'http://microsoft.com'; run; ods tagsets.excelxp file="/home/sasapps/dev/programs/universe/report/report_001.xml" style=printer options(sheet_name="tabone" ); proc report data=air nowd ; column air; compute air; call define(_col_,'url', 'http://google.com' ); endcomp; run; ods tagsets.excelxp options(sheet_name="tabtwo" ); proc report data=air nowd ; column air URL; define URL / group noprint; compute air; call define(_col_,'url', URL ); endcomp; run; ods tagsets.excelxp close; I'm using SAS 9.3 TS Level 1M2 on AIX 7.1 and Excel 2013. Thanks, Paul OldenKamp
... View more