Hello Experts, I just want to ask some questions on how to create a stored process with input parameters and output data stream (xml) and deploy it as web service? I have stored process here that fetch a string input parameter and I would like to output stream a data set as xml. But when I test it on soap UI as a webservice no value was displayed on xml. Kindly see the code below and the output from SOAP UI. I also attached the screenshots of the properties of the stored process. CODE: options symbolgen mlogic mprint; %global tbl_name tbl_nm tbl_id id; proc printto log="/sasdata/ooc/Logs/test.log"; run; libname b "/sasdata/ooc/Lookup_Tables"; data _null_; call symputx("tbl_nm","&tbl_name"); run; %macro tbl_var_lst; proc sql; select TABLE_ID into:tbl_id from b.ABT_TBL_LOOKUP where TABLE_NAME="&tbl_nm"; quit; data _null_; call symputx("id",&tbl_id); run; proc sql; create table vrbl_list as select variable_nm from b.ABT_VRBL_LOOKUP where VARIABLE_FLG="Y" and TABLE_ID=&id; quit; libname out XML; data out.vrbl_list; set vrbl_list; run; %mend; %tbl_var_lst; OUTPUT: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Body> <n:aBT_VRBL_Lookup2Response xmlns:n="http://tempuri.org/qwerty"> <n:aBT_VRBL_Lookup2Result> <n:Streams/> </n:aBT_VRBL_Lookup2Result> </n:aBT_VRBL_Lookup2Response> </soapenv:Body> </soapenv:Envelope> THANK YOU, Aaron
... View more