File date and time

[bubblui]

Hi All,

Have a great day...!

I have a column (file_name) with File names as values. Now I need to obtain each file Date and time of Created and modified.

INPUT Dataset

file_name

File1

File2

File3

File4

File5

Output Dataset

File_name	Moddate
File1	Xx
File2	Xx
File3	Xx
File4	Xx
File5	xx

 Please give me some suggestion.

[PeterClemmensen]

Are the files all located in the same directory? 🙂

[bubblui]

yes they are in same folder.

[BrunoMueller]

Hi

Have a look here http://support.sas.com/kb/40/934.html

Bruno

[BrunoMueller · Accepted solution]

Hi

You can take this code

data have;
  length filename $ 1024;
  input
    filename
  ;
  cards;
c:\temp\anchor.pdf
c:\temp\Book1.csv
;

data a;
  set have;
  rcs = filename("fileref", filename);
  msgs = sysmsg();
  fid=fopen('fileref');
  Bytes=finfo(fid,'File Size (bytes)');
  crdate=finfo(fid,'Create Time');
  moddate=finfo(fid,'Last Modified');
  rc = fclose(fid);
  rcc = filename("fileref");
run;

proc print;
run;

[bubblui]

Hi,

Thank you.

I tried doing it. But when I did it I am getting following note:

Note: Arguement 1 to function finfo at line xxx column xx is invalid.

Any idea on what reason this note occurs 

[bubblui]

Hi Bruno_sas,

Thank you.

I too used the same program, I think i was out of the world by not seeing the path.

When the path was corrected it worked fine.

Thanks a lot.