topic Re: PROC HTTP in SAS Programming

PROC HTTP

vkrishna — Tue, 06 Mar 2018 00:07:23 GMT

Hi,

I'm trying to run the below SAS code in SAS EG.

Filename Resp temp;

Proc HTTP
 url="http://**************"
 method="GET"
 out=resp;
run;

libname Test JSON fileref=Resp;

It is working if we use username and Password in the EG connection profile but If we use IWA in EG connection profile noticed below errors.

ERROR: Invalid JSON in input near line 1 column 1: Encountered an illegal character.
ERROR: Error in the LIBNAME statement.

Do I need to make any changes to use IWA?

Re: PROC HTTP

ChrisHemedinger — Mon, 05 Mar 2018 21:54:26 GMT

If you're using IWA to connect EG to SAS, you need the SAS server machine to be Trusted for Delegation to pass your identity onto the next network location (SharePoint, in this case).

An admin needs to set this up for you. See the doc in the SAS admin guide. Here's another topic about using Kerberos.

Re: PROC HTTP

vkrishna — Mon, 05 Mar 2018 22:11:44 GMT

@ChrisHemedinger, SAS server machine is trusted for delegation. We are using IWA it's working but when I try to connect to the WEB API its not working.

Re: PROC HTTP

ChrisHemedinger — Tue, 06 Mar 2018 12:22:27 GMT

Beginning with SAS 9.4 Maint 3, PROC HTTP allows you to specify several authentication options: NTLM, Negotiate, WebAuthdomain (SAS metadata). See the options in the PROC HTTP doc.