The short answer is that it is rather difficult in SAS 9.1, but will get better in SAS 9.2.
Can you provide more details on this project? How do you normally execute Web Services now? That is, what Web Service client framework do you currently use (e.g., Axis, JWSDP). Do you use Java or some other language? Do you have a pointer to a sample Web Service that you would like to execute from with in a stored process? If not, can you tell us what the expected inputs/outputs are?
We have an external system HMDM (Hyperion Master Datamart) that provides a Web Service with different services that we from the SAS side should be able to use.
E.g. When the HMDM needs input data from the Data Warehouse in SAS, it really would be nice if it was possible from SAS to have a job to be scheduled that exported the data from SAS, talked to the web services in HMDM system and then again used the web service available to addData to HMDM.
As for your suggestion with the pointer to the web service to execute that from a stored process this is something we was thinking about, but didn't quite get the syntax of. I know that we can setup a libname to a URL and from there sort of be a consumer, but this means I have to write all the XML syntax to make things happen?! Very hard I believe.
The implementation today is supported by exporting the data to SQL server and having the DTS to do the talking with the web service.
My whish list is filled up with the ability to both read and use external web services from the SAS Data Integration Studio. What plans are there here in SAS9.2? Heard in SUGI the Dan Jahn presentation, but I feel still a little confused here. Can you enlighten my knowledge a bit?