03-12-2018 05:44 AM
Hi looking for code which can check for the latest file based on its created date and time, if it find latest file then it should execute the process flow.
Hint: the file can be of any sas readable format.
eg. if a.xlx was last modified/created Today's date at 3:13 pm then it should import and execute.
if not updated then ...it should terminate the execution.
03-12-2018 05:55 AM
First, using file data/time is not a good way of doing any process - it can easily be modified.
Second, define "SAS readable" as SAS can read almost any file type. What are the specifications for the process, what do you have written down in the functional design definition for the process. What agreement do you have on what data will be given? Just saying you want to do something on anything that appears is not going to work, ever. Clear process, clear documentation, fixed inputs, fixed outputs.
03-12-2018 09:27 AM
Assuming your on Windows:
filename tmp pipe 'dir "yourdirectory/*.xlsx" /b /o-d'; data _null_; infile tmp dlm="¬"; if _n_=1 then call execute('proc import datafile='||strip(_infile_)||' out=want; run;'); run;
This will use DOS to return a list of files sorted by date reversed, then on first one generate a proc import statement.
That being said, your code will fall over each run, the process is way to vague, Excel is a poor data medium. What happens if they post a file called xlsx but its not, or not in the right form, or don't post the file, or put a picture in it...
03-12-2018 09:46 AM
This code will read a directory and find the creation times for .xlsx files:
filename indir '<directory>'; data test; dirid=dopen('indir'); do filenum=1 to dnum(dirid); name=dread(dirid,filenum); if upcase(scan(name,-1,'.')) ne 'XLSX' then continue; fileid=mopen(dirid,name); if fileid=0 then do; put _all_; continue; end; Created=finfo(fileid,'Create Time'); output; rc=fclose(fileid); end; keep name created; run;
The created variable will be a datetime, but formatted according to your national language settings in Windows, you then have to find the correct informat for reading it into a numeric datetime. After that, it should be as simple as to sort by the date and take the last record.
03-13-2018 12:41 AM
03-13-2018 03:16 AM
03-13-2018 04:02 AM