topic Link to a stored process and call parameters dynamically from proc report in ODS and Base Reporting

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

ANLYNG — Wed, 14 Dec 2016 06:45:27 GMT

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%2F%2FFoundation%2Freposname%3DFoundation%2FClassifierMap%3Bid%3DA5JEP4Y9.BD001U9L' >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%2F%2FFoundation%2Freposname%3DFoundation%2FClassifierMap%3Bid%3DA5JEP4Y9.BD001U9L' >Opdate</a>";

endcomp;

run;

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

Cynthia_sas — Tue, 13 Dec 2016 17:15:53 GMT

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

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

ANLYNG — Wed, 14 Dec 2016 08:18:38 GMT

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