topic Re: Retrieve file size, create time, and last modified date of a file within Sharepoint document lib in SAS Programming

Retrieve file size, create time, and last modified date of a file within Sharepoint document library

Rodcjones — Wed, 16 Oct 2019 21:45:28 GMT

I am seeking to use the code in this usage note

http://support.sas.com/kb/40/934.html

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;

fid=fopen('fileref');

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

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

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

run;

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

Re: Retrieve file size, create time, and last modified date of a file within Sharepoint document lib

ChrisNZ — Wed, 16 Oct 2019 22:31:20 GMT

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

It's all in the documentation.

See here.

Re: Retrieve file size, create time, and last modified date of a file within Sharepoint document lib

ScottBass — Thu, 17 Oct 2019 04:54:19 GMT

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:

https://github.com/scottbass/SAS/blob/master/Macro/dirlist.sas

Re: Retrieve file size, create time, and last modified date of a file within Sharepoint document lib

Rodcjones — Tue, 22 Oct 2019 19:09:25 GMT

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.

Re: Retrieve file size, create time, and last modified date of a file within Sharepoint document lib

ChrisNZ — Tue, 22 Oct 2019 20:09:53 GMT

Yes, Active Directory probably demands proper authentication.