How to take file created date

[thanikondharish]

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

How to take above file created date

[Kurt_Bremser]

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.

[Sathish_jammy]

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;

[Kurt_Bremser]

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.

[Sathish_jammy]

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

[thanikondharish]

This code is not working ,giving zero observations

[Kurt_Bremser]

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