topic Re: Links in ODS in ODS and Base Reporting

Links in ODS

sasjourney — Fri, 31 Oct 2014 14:26:14 GMT

Hello all,

I was trying to create links internally based on the values of a variable but wasn't able to create a link when the word I wanted to create a link for is a string.

For example, say I have a variable "Text" as below and have information on different pages of a PDF document for each of the values.

obs Text

1 Apples

2 Grapes

3 Apples Oranges

4 Apples Oranges Grapes

5 Apples are good

I was able to create links when there is only one value (Apples or Grapes) but wasn't successful in creating links when there is some other text associated with the text I wanted to create the link or to create different links for each valid word (different links for Apples, Oranges in obs 3 or link to Apples in obs 4). Can someone please help me on how to get this right.

Thanks

Re: Links in ODS

RW9 — Fri, 31 Oct 2014 14:38:27 GMT

Mmm, from experience links are a pain. I had a discussion on this type of thing some time back: https://communities.sas.com/thread/42000

I would assign each link a unique identifier in a datastep and use that rather than just text, e.g. L0001 = Apples, L0002=Grapes etc.

Re: Links in ODS

Ksharp — Sat, 01 Nov 2014 08:28:42 GMT

data have;
input obs Text & $400.;
cards;
1     Apples
2     Grapes
3     Apples Oranges
4     Apples Oranges Grapes
5     Apples are good
;
run;
data temp(drop=i temp text);
 set have;
 length t temp $ 400;
 do i=1 to countw(text);
  temp=scan(text,i);
  if temp='Apples'     then temp=catx(' ','~S={url="http://www.wwe.com"}',temp);
   else if temp='Oranges'     then temp=catx(' ','~S={url="http://www.sas.com"}',temp);
  t=catx(' ',t,temp);
 end;
run;
ods listing close;
ods html file='x.html' style=sasweb;
ods escapechar='~';
proc report data=temp nowd ;run;
ods html close;
ods listing;

Xia Keshan

Re: Links in ODS

sasjourney — Sat, 01 Nov 2014 21:57:50 GMT

Hi Xia,

Your example only works for HTML output but not for PDF.

Thanks

Re: Links in ODS

sasjourney — Sat, 01 Nov 2014 22:01:42 GMT

Thanks for the reply RW, I was using text as anchor as discussed in your posted thread below but that seems not working. I will try using mix of numbers and see if that works.

Thanks

Re: Links in ODS

Ksharp — Sun, 02 Nov 2014 11:13:17 GMT

Contact with SAS Technical Support .

Cynthia@sas might give you an answer.

Xia Keshan