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;
I runned it on the stored process server. The problem was that the length of the opdat variable was too short.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.