I have developed a stored process to receive an XML file as a response to a web service call and deployed it as a web service - something similar to the example here. It is successful and working fine in receiving an XML file which is of ~100KB but failing to receive similar file which is about 3MB. The other system sending the response seems to throw the below error  HTTP Response Code 413 for 'https://mystoredprocessURL'. I understand that this is related payload too large in size. Could you suggest me how to configure the length of payload size that has to be received so that the stored process can receive a larger file. Tried to research but could not find anything relevant. ... View more

Hi   I have a problem where I should receive an XML file as an asynchronous response into my stored process that has been deployed as a web service and save that file on to physical path of SAS grid. In short, system needs to receive an XML file from a different system that will send the XML to the SAS web service URL(URL that's generated after deploying the Stored Process as a web service). The challenge here is I am not able to find a code that captures the XML sent by the other system asynchronously.    To figure this out, I am trying to replicate the example given at https://support.sas.com/kb/63/405.html But I am getting an error into the XML file which says "The server refused this request because the request entity is in a format not supported by the requested resource for the requested method" inside html code. I believe this is something to worry about the input format but not very sure.   I tried to put the below code(as per https://support.sas.com/kb/63/405.html) in my stored process.   libname instream xml; libname outstr xml; proc copy in=instream out=work; run; data outstr.indata; set work.indata; run; Also configured the Data sources and targets as below:   And tried to invoke the web service from Enterprise Guide using proc HTTP as suggested in the example.   Could you please suggest me appropriate code to receive the XML sent from different system into the stored process and put the file into a physical location.    Note: The service needs to receive the file whenever the other system sends it via the stored process URL.    ... View more

Hi,   I have been trying to read some excel data into the SAS stored processes. I use SAS Add-in for microsoft office.  The problem here is, the data is read into SAS but when I input some text into excel i multiple lines using Alt+Enter, the data is still read and stored in a single line. (When I read the data in EG /output this back to excel, I get those two lines concatenated as a sinle line).   Example: Excel cell value contains text in multiple lines (entered using Alt+Enter):  This is line one of my text Here is line two.   This value is stored as This is line one of my text Here is line two.   Note : My text does not have a particular pattern.   I am calling the stored process from VBA. Below are the configurations in my stored process. Input data type : XML Data Source  Expected content type: text/xml.   I use the below code in stored process to read and save the excel cell as dataset. libname myexcelrange xml; data mylib.dummy; set myexcelrange.excel_table; run; Please help me in storing and retrieving this data in multiple lines. ... View more