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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: