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?
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.
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.
@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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.