BookmarkSubscribeRSS Feed
Obsidian | Level 7

I am seeking to use the code in this usage note

but applied to a file that resides within a Sharepoint document library. I took a stab at putting in the http address, like this



/** Non-macro technique **/

filename fileref 'http://sites/philtest/Shared%20Documents/runs.xlsx';

data a(drop=fid);

infile fileref truncover obs=1;


Bytes=finfo(fid,'File Size (bytes)');

crdate=finfo(fid,'Create Time');

moddate=finfo(fid,'Last Modified');


proc print; run;



But I get the error

ERROR: A component of C:\sas\sasconfig\Lev1\SASApp\http:\\sites\philtest\Shared%20Documents\runs.xlsx is not
a directory.


I would welcome any hints on how to adjust my code to get this to work. Thanks!


I am using SAS 9.04 TS1M6  EG 7.1 

Tourmaline | Level 20

You need to specify a device type. URL in your case.

It's all in the documentation.

See here.

Rhodochrosite | Level 12

And if you get the device type working, this macro may give you some code ideas, even if you don't use the macro itself:

Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.
Obsidian | Level 7

I'm still unable to get it to work -- same error -- despite using URL. My best guess at this point is that AUTHODOMAIN= might be needed to get me through to the site (which is an on-prem SharePoint document library). Still working on it.


Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 3 in conversation