capture stored process input parameters

[bheinsius]

hi,

when I call my stored process from the stored process web application and specify _debug=131, i get a list of stored process input parameters, see below.

is there a way to capture this information and store it in a sas data set?

thanks,

Bart

>>> 0.004 Stored Process Input Parameters:

_debug = 131

_grafloc = /sasweb/graph

_htcook = WT_FPC=id=10.127.157.248-372370784.30267271:lv=1355481518517:ss=1355481518517; JSESSIONID=01316A22BB6CFC2661F02FBF09A626B8.sasserver1

_htua = Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; MS-RTC LM 😎

_program = /Wikker BI/Portal/StoredProcesses/keepAlive

_reqmeth = GET

_rmtaddr = 134.143.119.118

_rmthost = 134.143.119.118

_srvname = wikkerweb-d.eom.nl

_srvport = 80

_url = /SASStoredProcess/do

_userlocale = en_US

_username = bart.heinsius

_version = Version 9.3 (Build 475)

[SGB]

Yes! I think you can store this in a dataset

you can try this..

you can define a library.. 'SEEPARAM'

data seeparam.input_param;

     _version = "&_version ";

     _username = "&_username";

run;

SGB

[BrunoMueller]

Hi Bart

Stored Process Input parameters are written to the corresponding macro varibales. You could use code similar to the one below to capture the contents of the macro variables:

proc sql;
  create table myParms as
  select
    *
  from
    dictionary.macros
  where
    name like "/_%" escape "/"
  order by
    name
  ;
quit;

The code above will only select macro variables starting with "_", but you can change the WHERE clause to get what you need

Bruno