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
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>";
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>";
Thanks, option 3 (double-double quotes) worked!
Amy
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.