SAS Support Communities

hi, Yes, I do want this encrypted using asymmetric keys because the intention is to grant only a specific set of users, who have the special key, to decrypt the data. And, i would want this to be done only to specific records- not something to be configured at the dataset level. ... View more

Thanks Vince for the response- I did mention the Stream option. In the meantime, I fixed my issues.   Just in case, it helps anyone - I am listing down the mistakes/ corrections I made during the last couple of days: 1. After getting annoyed with _WEBOUT, I decided to use another fileref in my SAS code and registered that in Data target tab while creating the stored process (Once I find some time, I will recheck _WEBOUT again- conceptually it should work- i guess!) 2. I spent some hours to realise that the endpoint URl is different for getting the Streamed results/ Output parameters eg. https://<webserverUrl>/SASBIWS/rest/storedProcesse s/<StoredProcess Path >/<stpName>/outputParameters/<macrovariable> https://<webserverUrl>/SASBIWS/rest/storedProcesse s/<StoredProcess Path >/<stpName>/dataTargets/<fileref> 3. In dataTargets, it took me some time to configure the correct content-type for associated file File Type content-type File Type content-type pdf application/pdf xls/csv application/vnd.ms-excel  zip  application/x-zip-compressed 4. At client side, I gave content-type: text/xml as I pass the parameters   There are still lot of areas to explore in this topic. Eventhough, I read about XMLA webservice, i havent still understood its use case. Since RESTClient is easy to use, I felt RESTful webservices comparatively simple to operate.   Thanks, Dilip ... View more

Hi All,   Just to update on this topic- I had raised this issue to SAS tech Support but unfortunately did not recieve any useful solution.   My application has now migrated to SAS9.4. I did a quick search in SAS docs but couldnt find any major enhancements to ODS package in 9.4 (that could preserve the encoding type of the file).   If there are any thoughts, please let me know.   Thanks, Dilip ... View more

latest Update: I managed to pass the parameter as Body in the RESTClient and it worked:   <any> <parameters> <parameter1>value1</parameter1> </parameters> </any>   But, now it fails in SAS as I had given fileref as _WEBOUT in the code- SAS tries to write _webout.dat in the SAS Foundation library where it doesnt have write access.   MPRINT(FSTREAM):   data _null_; MPRINT(FSTREAM):   infile ".../saswork/SAS_work470C0026F545_sla06469/SAS_work8ECA0026F545_sla06469/temp.csv" recfm=f lrecl=1; MPRINT(FSTREAM):   file _WEBOUT recfm=n; MPRINT(FSTREAM):   input c $char1. @@; MPRINT(FSTREAM):   put c $char1. @@; MPRINT(FSTREAM):   run;     Now, I am wondering if I have to define "Data Targets" for this stored process.   Any suggestions? ... View more