The SAS Output Delivery System and reporting techniques

Interactive rtf/pdf document with links

Accepted Solution Solved
Reply
Regular Contributor
Posts: 214
Accepted Solution

Interactive rtf/pdf document with links

Hi all,

 

Could you please help with the table reporting that should contain links on the correspondent files. I have a dataset that with tables names and should receive a one column with the names and each name should be an interactive.

 

It has to be an rtf and pdf documents. Is it possible with SAS?

  

data test;
  format TABLE $6. LINK $25.;
  input TABLE LINK;
  datelines;
Table1 C:\ProjectX\Table1.rtf
Table2 C:\ProjectX\Table2.rtf
Table3 C:\ProjectX\Table3.rtf
;
run;

 

Thank you!

 


Accepted Solutions
Solution
‎03-29-2018 06:06 AM
SAS Super FREQ
Posts: 830

Re: Interactive rtf/pdf document with links

Posted in reply to DmytroYermak

You can use Proc REPORT with the CALL DEFINE and the URL attribute to set your link. See sample code below.

 

Also have a look at http://support.sas.com/kb/24/182.html concerning the color around the link

 

data test;
  format TABLE $6. LINK $25.;
  input TABLE LINK;
  datalines;
Table1 C:\ProjectX\Table1.rtf
Table2 C:\ProjectX\Table2.rtf
Table3 C:\ProjectX\Table3.rtf
;
run;

ods pdf file="c:\temp\sample.pdf";
proc report data=test;
  column table link _dummy;
  define table / display;
  define link / display noprint;
  define _dummy / computed noprint;
  compute _dummy;
    call define ("table", "URL", link);
/*    call define("table", "style", "style={LINKCOLOR=white}");*/
  endcomp;
run;
ods pdf close;

View solution in original post


All Replies
Solution
‎03-29-2018 06:06 AM
SAS Super FREQ
Posts: 830

Re: Interactive rtf/pdf document with links

Posted in reply to DmytroYermak

You can use Proc REPORT with the CALL DEFINE and the URL attribute to set your link. See sample code below.

 

Also have a look at http://support.sas.com/kb/24/182.html concerning the color around the link

 

data test;
  format TABLE $6. LINK $25.;
  input TABLE LINK;
  datalines;
Table1 C:\ProjectX\Table1.rtf
Table2 C:\ProjectX\Table2.rtf
Table3 C:\ProjectX\Table3.rtf
;
run;

ods pdf file="c:\temp\sample.pdf";
proc report data=test;
  column table link _dummy;
  define table / display;
  define link / display noprint;
  define _dummy / computed noprint;
  compute _dummy;
    call define ("table", "URL", link);
/*    call define("table", "style", "style={LINKCOLOR=white}");*/
  endcomp;
run;
ods pdf close;
Regular Contributor
Posts: 214

Re: Interactive rtf/pdf document with links

Posted in reply to Bruno_SAS
Thank you, Bruno! It has worked.
☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 181 views
  • 0 likes
  • 2 in conversation