SGPLOT a href in title statement

[asludtke]

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

[ChrisNZ · Accepted solution]

1-Quotes in file names are not the best idea.

2-Try replacing the single quote in the href with &apos;

3-Try using double quotes only: 

title2  "<a href=""Data_&&analyte&i...xlsx""; title='Data Link' >Open Data Set</a>";

[asludtke]

Thanks, option 3 (double-double quotes) worked!

Amy

[BrunoMueller]

How about using the the LINK=option. then you have two different strings and it is easier to manage. See sample below.

title link="https://communities.sas.com" "Here we go";

proc sgplot data=sashelp.cars;
  vbar type;
run;