Thank you for your response. I think this may be the way to go. I'm having trouble creating my strings in my proc http statements. I added a field "listout" to my table that has the resulting location and name of the desired XML file. I also added a field "url" to the table with the url of my SharePoint surveys. data _null_;
set Listid_viewid;
call execute('proc http out = '||listout||'
url="'||url||'?Cmd=Display&List=&'||ListID||'&View=&'||ViewID||'&XMLDATA=TRUE"
METHOD = "GET"; RUN;');
run; When I run this I get Error 22-322 Syntax error for each of the surveys proc http out = T:\Folder\Subfolder\ha_data28.xml - 22 76 ERROR 22-322: Syntax error, expecting one of the following: ;, AUTH_ANY, AUTH_BASIC, AUTH_NEGOTIATE, AUTH_NONE, AUTH_NTLM, CLEAR_CACHE, CLEAR_CONN_CACHE, CLEAR_COOKIES, CT, EXPECT_100_CONTINUE, FOLLOWLOC, HEADERIN, HEADEROUT, HEADEROUT_OVERWRITE, HTTP_TOKENAUTH, IN, METHOD, NOFOLLOW, NOFOLLOWLOC, NO_CONN_CACHE, NO_COOKIES, OUT, PROXYHOST, PROXYPASSWORD, PROXYPORT, PROXYUSERNAME, PROXY_AUTH_BASIC, PROXY_AUTH_NEGOTIATE, PROXY_AUTH_NONE, PROXY_AUTH_NTLM, URL, VERBOSE, WEBAUTHDOMAIN, WEBPASSWORD, WEBUSERNAME. ERROR 76-322: Syntax error, statement will be ignored.
... View more