SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Yes, but can SAS IMPORT from a Sharepoint Excel file?

Reply
N/A
Posts: 0

Yes, but can SAS IMPORT from a Sharepoint Excel file?

I saw where we can write a spreadsheet to Sharepoint using ODS, but...

How would I import an Excel file with a URL address?
I'm using SAS 9.2 (XP Pro) and Office 2007. We want to store some metadata Excel files on our Sharepoint site (to aid in audit trails, etc.) and grab them with our processes to build on-the-fly subroutines. This works great when pulling the Excel files from a shared server with a regular path-style address, but when I run the example code below I get the error that PROC IMPORT won't work with URL files.

filename test url "https://myintranet.com/sites/project/test.xlsx";
proc import file=test out=testout dbms=excel replace; range='test';
getnames=yes; scantext=yes; run;

ERROR: This "filename URL" access method is not supported by "proc import". Please copy the file to local disk before running the procedure.

I'd rather not copy the file (either manually or via an X command.) Ideas?

Thanks!
Ask a Question
Discussion stats
  • 0 replies
  • 1152 views
  • 0 likes
  • 1 in conversation