The SAS Output Delivery System and reporting techniques

Link to a stored process and call parameters dynamically from proc report

Accepted Solution Solved
Reply
Contributor
Posts: 54
Accepted Solution

Link to a stored process and call parameters dynamically from proc report

[ Edited ]

I am working on a report (use proc report) where I want to link to a Stored Process.I need different link/call for each line. because it is a specific selection in the stored process . Is there a smart way of doing it ???.I use EG testing the link- But right now is my problem that it do not show the link at all (and I had not put any parameters there yet). Next step is how a call a specific parameter in the STP by specifying it in the link. Do you have any examples?

 

Thanks in advance.

 

 

My output so far is this text in the variable opdat:

 

<a href='http://infbisas4wp.int.addom.dk/SASPortal/viewItem.do?com.sas.portal.ItemId=StoredProcess%2Bomi%3A%2...' >Opdatere

 

 

Here is some code and I marked my URL in RED:

 

proc report data=test ls=132 ps=58 nocenter missing nowd split=" "

style(report)=[just=right outputwidth=100% font_face=arial font_size=2 font_style=roman ]

style(column)=[just=left /*outputwidth=100%*/ font_face=arial font_size=2 font_style=roman BACKGROUND=WHITE]

style(summary)=[font_face=arial font_size=2 font_style=roman ]

style(header)=[foreground=#003366 font_face=arial font_size=2 font_style=roman ];

;

COLUMN kpi KPI_bem result KPI_com opdat;

 

 

define kpi/DISPLAY width=10 spacing=1 left "KPI" style(column)={just=left};

define KPI_bem/DISPLAY width=20 spacing=1 left "Besk" style(column)={just=left};

define result/DISPLAY width=20 spacing=1 left "result" style(column)={just=left};

define KPI_com/DISPLAY width=10 spacing=1 left "KPI com" style(column)={just=left};

define opdat/COMPUTED width=200 spacing=1 left "Opdatere" style(column)={just=left};

RBREAK BEFORE / SUMMARIZE SKIP OL UL ;

compute opdat/char length=200;

if kpi='GGGGGG'

then

opdat='http://infbisas4wp.int.addom.dk/SASPortal/viewItem.do?com.sas.portal.ItemId=StoredProcess%2Bomi%3A%2...' >Opdate</a>";

endcomp;

 

run;


Accepted Solutions
Solution
‎12-19-2016 03:06 AM
SAS Super FREQ
Posts: 8,646

Re: Link to a stored process and call parameters dynamically from proc report

Hi:
We have examples of performing drill downs using Stored Processes in our Stored Process 2 course:

However, in that course, we are using the Stored Process Web Application to run the stored process. It appears that you are going through the Portal in your URL (which is very hard to read in yellow on gray).

This is what you have in yellow:
opdat='http://infbisas4wp.int.addom.dk/SASPortal/viewItem.do?com.sas.portal.ItemId=StoredProcess%2Bomi%3A%2...' >Opdate</a>"

I would have expected something like this (with the beginning anchor tag and href=):
opdat='<a href="http://.....rest of url">Opdate</a>';

I am not sure why your OPDAT calculated item begins with a single quote, but ends with a double quote. It seems to me you have some problem with quoting.

cynthia

View solution in original post


All Replies
Solution
‎12-19-2016 03:06 AM
SAS Super FREQ
Posts: 8,646

Re: Link to a stored process and call parameters dynamically from proc report

Hi:
We have examples of performing drill downs using Stored Processes in our Stored Process 2 course:

However, in that course, we are using the Stored Process Web Application to run the stored process. It appears that you are going through the Portal in your URL (which is very hard to read in yellow on gray).

This is what you have in yellow:
opdat='http://infbisas4wp.int.addom.dk/SASPortal/viewItem.do?com.sas.portal.ItemId=StoredProcess%2Bomi%3A%2...' >Opdate</a>"

I would have expected something like this (with the beginning anchor tag and href=):
opdat='<a href="http://.....rest of url">Opdate</a>';

I am not sure why your OPDAT calculated item begins with a single quote, but ends with a double quote. It seems to me you have some problem with quoting.

cynthia
Contributor
Posts: 54

Re: Link to a stored process and call parameters dynamically from proc report

[ Edited ]

I runned it on the stored process server. The problem was that the length of the opdat variable was too short.

Post a Question
Discussion Stats
  • 2 replies
  • 203 views
  • 0 likes
  • 2 in conversation