topic Re: Hyperlink which open pop up with data in SAS Programming

Hyperlink which open pop up with data

radha009 — Thu, 24 Oct 2019 20:10:48 GMT

I am looking to create a hyperlink to ‘this week changes’ once I click pop up opens with data.

How can I do it.

Re: Hyperlink which open pop up with data

Cynthia_sas — Thu, 24 Oct 2019 20:39:01 GMT

Hi:

What is your destination of interest, RTF, PDF, HTML? When do you mean by "popup" -- a popup Word doc, a popup window, a flyover window, a new HTML page?

What code have you tried? What procedures are you using? There are several ways to create hyperlinks in SAS and then to generate links for "drill-down" from a summary report to a detail report, for example. Here's one Forum posting, with code: https://communities.sas.com/t5/SAS-Procedures/How-to-do-a-Drill-Down/td-p/103086 and here's another with a PDF example that is a bit different: https://communities.sas.com/t5/ODS-and-Base-Reporting/links-with-PDF-destination/td-p/62869 .

Cynthia

Re: Hyperlink which open pop up with data

radha009 — Fri, 25 Oct 2019 12:03:12 GMT

i am looking for html format. a link at the end of the report. onclick should open popup window with dataset.(sh1.deployments)

ods html body='ttest.htm' style=HTMLBlue;

proc report data=sh1.deployments;
run;
ods html close;

ods _all_ close;
ods html body='ttest.htm'
style=HTMLBlue;
title2 j=l height = 14 pt link="ttest.htm/";
ods html close;
ods html;

Re: Hyperlink which open pop up with data

Cynthia_sas — Fri, 25 Oct 2019 15:20:18 GMT

Hi:

I am confused because your BODY= option is creating TTEST.HTM in BOTH of the ODS HTML statement but your LINK= is pointing to the SAME file TTEST.HTM -- that doesn't make sense to me.

This works for me:

Notice how 2 separate files are created: detail.htm and master.htm. Notice that the detail.htm file (yellow) has a link to master.htm (blue). And notice also that master.htm, the summary file, (blue) has a link to detail.htm(yellow).

It would not work if all the links referred to "detail.htm" or "master.htm".

You should be able to try my code to see how it works. It just uses sashelp.class.

Cynthia