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.
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;
Are the files all located in the same directory? 🙂
yes they are in same folder.
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;
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.