Attributes of an XLSX library

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
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
Grand Advisor
Posts: 9,574

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
Grand Advisor
Posts: 17,325

Re: Attributes of an XLSX library

Those are file properties. Look at the FINFO function

Solution
‎05-18-2017 09:51 AM
Grand Advisor
Posts: 9,574

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
  • 107 views
  • 2 likes
  • 3 in conversation