topic Re: File date and time in SAS Programming

File date and time

bubblui — Fri, 10 Feb 2017 07:39:33 GMT

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.

Re: File date and time

PeterClemmensen — Fri, 10 Feb 2017 07:44:03 GMT

Are the files all located in the same directory? 🙂

Re: File date and time

BrunoMueller — Fri, 10 Feb 2017 07:55:40 GMT

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

Bruno

Re: File date and time

BrunoMueller — Fri, 10 Feb 2017 08:03:36 GMT

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;

Re: File date and time

bubblui — Fri, 10 Feb 2017 09:14:23 GMT

yes they are in same folder.

Re: File date and time

bubblui — Fri, 10 Feb 2017 09:30:24 GMT

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

Re: File date and time

bubblui — Fri, 10 Feb 2017 09:49:25 GMT

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.