Attributes of an XLSX library

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 8
Accepted Solution

Attributes of an XLSX library

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.


Accepted Solutions
Solution
‎05-18-2017 09:51 AM
Super User
Posts: 9,878

Re: Attributes of an XLSX library

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

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

View solution in original post


All Replies
Super User
Posts: 19,194

Re: Attributes of an XLSX library

Those are file properties. Look at the FINFO function

Solution
‎05-18-2017 09:51 AM
Super User
Posts: 9,878

Re: Attributes of an XLSX library

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

proc sql;
 select * from dictionary.EXTFILES
  where Fileref='X' ;
quit;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 127 views
  • 2 likes
  • 3 in conversation