I have a program that outputs multiple plots using SGPLOT and multiple XLSX output. I'm using an "<a href" in a title statement to link to the XLSX file. Within the title statement I'm resolving a macro variable. All works fine, until the macro variable as a " ' " (single quote) in the name and then the link breaks. My code looks like: proc sgplot data=plotdata; title1 h=5 "Blind Sample Determination:" ; title2 underlin=1 italic color=blue "<a href='Data_&&analyte&i...xlsx'; title='Data Link' >Open Data Set</a>"; /*Link to XLSX file */ When the variable analyte="Triclosan" then the HTML a href output reads correctly: <a href='Data_4433_TRICLOSAN.xlsx'; title='Data Link' >Open Data Set</a> When the variable analyte="2,2',4,4'-TETRABROMODIPHENYLETHER" then the HTML output breaks at the single quote in the name: <a href='Data_4433_2,2',4,4'-TETRABROMODIPHENYLETHER.xlsx'; title='Data Link'>Open Data Set</a> I need the double quotes to resolve the analyte macro variable and can't seem to figure out how to get around this. Any suggestions would be very much appreciated, Amy
... View more