Read Query String in Stored Process

arnab61 — Sun, 20 May 2012 00:15:59 GMT

I am passing value from a stored process to another stored process using query string.

Now I would like to use this query string age as a macro variable. So that I can run some filters on it. Pleas Help...

Re: Read Query String in Stored Process

shivas — Mon, 21 May 2012 10:03:50 GMT

Hi,

You can pass this way..try this...

First stored process creating links and passing parameters:

proc report data=want nowd ;

column age ;

define age/left;

compute age;

length nexturl $500;

nexturl = "&_URL?_program=/Users/sasdemo/My+Folder/KPPOC/agefiltercode" ||

'&age=' || urlencode(trim(left(age))) ;

call define(_col_,"URL",nexturl);

endcomp;

run;

write you filtering code in second SP:(stored process name : agefiltercode)

Thanks,

Shiva