topic Re: How to take file created date in SAS Procedures

How to take file created date

thanikondharish — Thu, 12 Dec 2019 09:09:55 GMT

I have one file .path is 'D:\testing.xlsx'

How to take above file created date

Re: How to take file created date

Kurt_Bremser — Thu, 12 Dec 2019 09:51:01 GMT

Use the file functions fopen, foptnum, foptname and finfo:

filename fref 'D:\testing.xlsx';

data fileinfo;
fid = fopen("fref");
do i = 1 to foptnum(fid);
  opt = foptname(fid,i);
  val = finfo(fid,opt);
  output;
end;
run;

One of the information items will contain what you look for. Be aware that the names and values are specific to the operating system and the system's locale.

Re: How to take file created date

Sathish_jammy — Thu, 12 Dec 2019 09:51:04 GMT

data have;
  input filename$1024.;
cards;
D:\testing.xlsx
;

data want;
  set have;
  rcs = filename("fileref", filename);
  fid=fopen('fileref');
  Bytes=finfo(fid,'File Size (bytes)');
  crdate=finfo(fid,'Create Time');
  moddate=finfo(fid,'Last Modified');
run;

proc print;
run;

Re: How to take file created date

Kurt_Bremser — Thu, 12 Dec 2019 10:18:10 GMT

As I said, the optnames are locale- and system-specific. In my case (AIX, German), there is no "Create Time" at all (it is misleading information anyway), but a "Zuletzt geändert" (modification time).

This is why I strongly prefer to use system commands for this, as they can be directed by parameters (see GNU ls) to return specific information in a specific format (like ISO-timestamps), independent of the current environment.

Re: How to take file created date

Sathish_jammy — Thu, 12 Dec 2019 10:22:23 GMT

I agree with your points, Thank you for your valuable comment.

Re: How to take file created date

thanikondharish — Thu, 12 Dec 2019 11:36:49 GMT

This code is not working ,giving zero observations

Re: How to take file created date

Kurt_Bremser — Thu, 12 Dec 2019 11:38:58 GMT

Please post the log. "Does not work" on its own is USELESS.