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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.