topic Re: Attributes of an XLSX library in SAS Programming

Attributes of an XLSX library

Batman — Fri, 12 May 2017 17:36:56 GMT

Can I obtain the attributes of a SAS XLSX library, such as "creation date" and "last modified date"? I tried the list option, proc contents and proc datasets, but none supplied those attributes.

Re: Attributes of an XLSX library

Reeza — Fri, 12 May 2017 19:34:35 GMT

Those are file properties. Look at the FINFO function

Re: Attributes of an XLSX library

Ksharp — Sat, 13 May 2017 04:02:19 GMT

filename x '/folders/myfolders/have.xlsx';

proc sql;
 select * from dictionary.EXTFILES
  where Fileref='X' ;
quit;