topic Re: import excel file from sharepoint site in SAS Programming

import excel file from sharepoint site

radha009 — Sat, 28 Sep 2019 13:52:39 GMT

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.

Re: import excel file from sharepoint site

ghosh — Sat, 28 Sep 2019 14:41:18 GMT

you have a comma in the URL.

change the portion to

tset.com

Re: import excel file from sharepoint site

radha009 — Sat, 28 Sep 2019 17:05:28 GMT

typo mistake.actual program doesn;t have comma.

Re: import excel file from sharepoint site

SASKiwi — Sat, 28 Sep 2019 21:31:12 GMT

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

Re: import excel file from sharepoint site

Reeza — Sun, 29 Sep 2019 17:25:22 GMT

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.

Re: import excel file from sharepoint site

radha009 — Sun, 29 Sep 2019 19:29:32 GMT

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

Re: import excel file from sharepoint site

Reeza — Sun, 29 Sep 2019 21:34:55 GMT

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?