import excel file from sharepoint site

[radha009]

Getting error when trying to get data from the sharepoint -Please help

FILENAME website HTTP 'https://tset,com/Shared%20Documents/people_counts.xlsx';

data file;
n=-1;
infile website recfm=s nbyte=n length=len;
input;
file "C:/test/Summary.xls" recfm=n;
put _infile_ $varying32767. len;
run;

ERROR: Unauthorized to retrieve URL. Use the debug option for more info.
NOTE: UNBUFFERED is the default with RECFM=N.

[ghosh]

you have a comma in the URL.

change the portion to

tset.com

[radha009]

typo mistake.actual program doesn;t have comma.

[SASKiwi]

You probably need to add user and password options given the authorisation problem. Also add DEBUG as suggested.

[Reeza]

You're aware that this just copies the data set to your C drive and doesn't import the data? I believe you can import the xls file directly from SharePoint, you don't need to have an intermediary step, you do need the correct path though. Usually, I view the file in Windows Explorer to get the path and then import it, though it's been a while since I've had to do this.

[radha009]

I view excel on sharepoibt only thru url. I can’t view thru windows explorer. How can I directly import from sharepoint?

[Reeza]

Is this an internal company site? Go to the document library, in Internet Explorer (not Chrome). Open the list and select view in Windows Explorer. 

---

@radha009 wrote:
I view excel on sharepoibt only thru url. I can’t view thru windows explorer. How can I directly import from sharepoint?

---