GETTING LAST MODIFIED DATE OF THE FILE IN SAS

[Kirito1]

I want to get last modified date of a file in my folder using SAS how can I do that? Any help is appreciated.

[LinusH]

A number of ways.

Completely in SAS you can use a combination of SAS external file functions:

https://documentation.sas.com/doc/en/imlcdc/14.2/imlug/imlug_langref_sect561.htm

Or you can use X command/filename pipe to execute a dir/ls command to retrieve that information.

[Kirito1]

I read it all but unable to use it, Although what I found using google says the physical file does not exist but its there in my network folder. And I am able to import that same file using proc import

The below is my code:

%let filepath = /SAS_library/NAS_CA/QR/QR/Import_file/MERMAST_INFILE.csv;

data _null_;
lastmod = attrn("&filepath.", "LM");
put "Last Modified Date: " lastmod datetime.;
run;

Please suggest what I should Do. Is there any solution for this.

[ballardw]

Is the file in question a SAS data set, other SAS file or something external to SAS such as a text file read for data?

[Kirito1]

Its not a SAS data set its an external CSV file in my network folder. 

Just to be clear I am able to import that CSV file using proc import. The task here for me is to check if the dumped file has last modified date of today then I want to schedule that job.

[grace_sas · Accepted solution]

Does this give you what you need?

https://support.sas.com/kb/40/934.html

[Kirito1]

Thank You very much Yes it solve my problem.

[yabwon]

How about using BasePlus package and the dirsAndFiles macro? 

%dirsAndFiles(
  </path/to/your/directory>
  ,ODS=work.outputDataSet
  ,keepDirs=0 /* ignore directories */
  ,details=1 /* get details */
  ,maxDepth=1 /* don't look in subdirectories */
)

And then use "LastModified" variable.

All the best

Bart

P.S. To install and use basePlus package do: 

• Enable the framework [first time only]: 

• filename SPFinit url "https://raw.githubusercontent.com/yabwon/SAS_PACKAGES/main/SPF/SPFinit.sas";
  %include SPFinit; /* enable the framework */

• Install the framework and the package on your machine in the folder you created:

• filename packages "</your/directory/for/packages/>"; 
  %installPackage(SPFinit basePlus) 

• From now on, in your SAS session just run it like this (you can put those 3 lines in autoexec): 

• filename packages "</your/directory/for/packages/>";
  %include packages(SPFinit.sas);
  
  %loadPackage(basePlus)  

Link to details.