topic Re: Reading REST results with SAS in SAS Programming

Reading REST results with SAS

x97mdr — Fri, 20 Feb 2009 15:40:53 GMT

Hello all,

I have done some research and discovered that SAS can interact with SOAP-based XML WEB Services, however I am looking at developing a REST-based architecture. We want to be able to read a string that is returned by visiting a URL into a SAS dataset and then using that string to determine what data to download.

I asked this question in a separate post and the response was to use FILENAME URL to read from the link. I tried this but it seemed unreliable in that it only worked for my test string if the record length was set to <= record length and the record format was fixed. Varying length records didn't seem to work.

What I'm wondering is if anyone else has tried to utilise a REST architecture with SAS and what has their experience been? I would also like to know how to process XML data received from a REST request?

Re: Reading REST results with SAS

sbb — Fri, 20 Feb 2009 19:10:49 GMT

Due to some known limitations with the discussion forum software, your post was truncated. Suggest you re-post as a reply here and provide SAS code and SASLOG excerpts, where the results observed are not what you expect, when using a SAS DATA step and the FILENAME URL engine.

Scott Barry
SBBWorks, Inc.

Re: Reading REST results with SAS

x97mdr — Fri, 20 Feb 2009 19:23:06 GMT

Thanks Scott. I did not know about the limit on post length

My examples are at work and I'm at home today so I will post them on Monday

Re: Reading REST results with SAS

Zach_sas — Tue, 14 Apr 2009 13:52:39 GMT

You might try looking at proc http which is new in 9.2 Phase 2.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a003286796.htm

Re: Reading REST results with SAS

reneeharper — Tue, 14 Apr 2009 19:11:58 GMT

I checked your post (being the Admin let's me do these things). The problem isn't lenght. It is the fact that you used the less than + equals together. It was seen as an HTML tag. Try encoding using <. It will look like < =