Reading an Excel file from Sharepoint/Intranet with a URL address that request NT login

medsam81 — Mon, 09 Mar 2020 19:29:33 GMT

Hi,

I was trying to access file hosted on our intranet, espace : sharepoint location that request NT login.

filename csvFile url "filepath.com/mycsv.csv" puser="myNT" pass="mypsw" termstr=crlf;

proc import datafile=csvFile out=foo replace dbms=csv; run;

I got this error :

ERROR: Unauthorized to retrieve URL. Use the debug option for more info.

ERROR: Import unsuccessful. See SAS Log for details.

is there way to access this file.

Re: Reading an Excel file from Sharepoint/Intranet with a URL address that request NT login

Kurt_Bremser — Mon, 09 Mar 2020 20:05:03 GMT

Please post the complete log. Use the {i} button for posting logs.