topic Re: SGPLOT a href in title statement in Graphics Programming

SGPLOT a href in title statement

asludtke — Tue, 20 Jun 2017 22:19:02 GMT

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:

When the variable analyte="2,2',4,4'-TETRABROMODIPHENYLETHER" then the HTML output breaks at the single quote in the name:

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

Re: SGPLOT a href in title statement

ChrisNZ — Tue, 20 Jun 2017 23:29:16 GMT

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

2-Try replacing the single quote in the href with '

3-Try using double quotes only:

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

Re: SGPLOT a href in title statement

BrunoMueller — Wed, 21 Jun 2017 08:25:22 GMT

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;

Re: SGPLOT a href in title statement

asludtke — Wed, 21 Jun 2017 12:55:26 GMT

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

Amy