topic CRDATE for a CSV file? in SAS Programming

CRDATE for a CSV file?

alr — Fri, 02 Jan 2015 13:14:48 GMT

Hi,
Is it possible to get creation date (crdate) and/or last modified date of a CSV file with SAS before import of the file?

data mydata;
infile 'C:\MyData\thedata.csv' dlm='3B'x;
   input var1 :$7.
            var2 :8.
            ;
run;

Also, creation date of the file thedata.csv.

Re: CRDATE for a CSV file?

ballardw — Fri, 02 Jan 2015 16:09:40 GMT

Yes.

Look at the functions, and online help examples for functions FINFO, FOPTNUM, FOPTNAME and related. You can get the system information available from your operating system.

Re: CRDATE for a CSV file?

CTorres — Fri, 02 Jan 2015 16:11:57 GMT

Assuming the operating system is Windows, the following program creates the macrovariable CRDATE with the date and time the file was last modified. You can later use this value in any SAS data or proc step:

%let folder=C:\MyData;

%let csvfile=THEDATA.CSV;

filename folder pipe "dir &folder";

data _null_;

infile folder lrecl=256 pad;

length file $32 date $10 time $5 ampm $2;

input;

file=scan(_infile_,5,' ');

if upcase(trim(file))="&csvfile" then do;

date=scan(_infile_,1,' ');

time=scan(_infile_,2,' ');

ampm=scan(_infile_,3,' ');

datenum=input(date,mmddyy10.);

timenum=input(time,time5.);

if ampm='PM' then timenum=timenum+(12*3600);

dtnum=dhms(datenum,hour(timenum),minute(timenum),second(timenum));

call symputx('CRDATE',put(dtnum,datetime19.));

stop;

end;

run;

%put &crdate;

CTorres

Re: CRDATE for a CSV file?

art297 — Fri, 02 Jan 2015 16:25:19 GMT

Take a look at: 40934 - Retrieve file size, create time, and last modified date of an external file