BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ANLYNG
Pyrite | Level 9

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;

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ
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

2 REPLIES 2
Cynthia_sas
SAS Super FREQ
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
ANLYNG
Pyrite | Level 9

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

sas-innovate-2024.png

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.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1057 views
  • 0 likes
  • 2 in conversation