I want to extract the following execution property of a Stored Process.
I have tried Proc STP; list group=executtion; run; but could only get the following properties:
How can I find out the server type on which the SP is to be executed?
Note: I want to produce a SAS data set listing all properties of SAS Stored Process, including the above property I mentioned.
Thanks in Advance,
Here you go:
%let path_to_my_stp="/some/path/mySTP"; data _null_; length uri type serveruri $256.; path="&path_to_my_stp"; if metadata_pathobj("",path,"StoredProcess",type,uri)>0 then call symputx('uri',uri); run; data associations; keep assoc assocuri name; length assoc assocuri name $256; rc1=1;n1=1; do while(rc1>0); /* Walk through all possible associations of this object. */ rc1=metadata_getnasl("&uri",n1,assoc); rc2=1;n2=1; do while(rc2>0); /* Walk through all the associations on this machine object. */ rc2=metadata_getnasn("&uri",trim(assoc),n2,assocuri); if (rc2>0) then do; rc3=metadata_getattr(assocuri,"Name",name); output; end; call missing(name,assocuri); put arc= rc2=; n2+1; end; n1+1; end; run; proc sort data=associations; by assoc name; run; data attrprop; keep type name value; length type $4 name $256 value $32767; rc1=1;n1=1;type='Prop'; do while(rc1>0); rc1=metadata_getnprp("&uri",n1,name,value); if rc1>0 then output; n1+1; end; rc1=1;n1=1;type='Attr'; do while(rc1>0); rc1=metadata_getnatr("&uri",n1,name,value); if rc1>0 then output; n1+1; end; run; proc sort data=attrprop; by type name; run;
By the way - the above code was taken from our free SAS 9 web application for exploring metadata - you can check it out and deploy it yourself, it's the web equivalent of METABROWSE: https://github.com/Boemska/metanav
On the off-chance that you're extracting all these details so you can make your own STP, programmatically - let me save you some time:
Thank you so much for your quick reply.
I executed the provided code, it is giving me all properties except the one I mentioned, which is to see the how a particular stored process is configured to execute on which server - Workspace, SP or default.
Thanks in Advance,
I suggest deploying the metanav application to see how to extract this info: https://github.com/Boemska/metanav
You can try running this using PROC HTTP, and then use DATA step code to parse the HTML that is returned:
It provides some of the properties of all stored processes on the system. Execute the URL using a Web browser to see the properties that are returned.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.