Data visualization with SAS programming

SGPLOT a href in title statement

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

SGPLOT a href in title statement

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


Accepted Solutions
Solution
‎06-26-2017 09:03 AM
PROC Star
Posts: 1,673

Re: SGPLOT a href in title statement

[ Edited ]

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>";

View solution in original post


All Replies
Solution
‎06-26-2017 09:03 AM
PROC Star
Posts: 1,673

Re: SGPLOT a href in title statement

[ Edited ]

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>";

New Contributor
Posts: 2

Re: SGPLOT a href in title statement

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

Amy

SAS Super FREQ
Posts: 706

Re: SGPLOT a href in title statement

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;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 229 views
  • 0 likes
  • 3 in conversation