topic Re: GETTING LAST MODIFIED DATE OF THE FILE IN SAS in SAS Programming

GETTING LAST MODIFIED DATE OF THE FILE IN SAS

Kirito1 — Wed, 20 Dec 2023 11:26:53 GMT

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

Re: GETTING LAST MODIFIED DATE OF THE FILE IN SAS

LinusH — Wed, 20 Dec 2023 11:34:02 GMT

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.

Re: GETTING LAST MODIFIED DATE OF THE FILE IN SAS

ballardw — Wed, 20 Dec 2023 15:14:52 GMT

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?

Re: GETTING LAST MODIFIED DATE OF THE FILE IN SAS

grace_sas — Wed, 20 Dec 2023 20:53:24 GMT

Does this give you what you need?

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

Re: GETTING LAST MODIFIED DATE OF THE FILE IN SAS

Kirito1 — Thu, 21 Dec 2023 06:30:52 GMT

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.

Re: GETTING LAST MODIFIED DATE OF THE FILE IN SAS

Kirito1 — Thu, 21 Dec 2023 06:36:59 GMT

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.

Re: GETTING LAST MODIFIED DATE OF THE FILE IN SAS

Kirito1 — Thu, 21 Dec 2023 06:40:24 GMT

Thank You very much Yes it solve my problem.

Re: GETTING LAST MODIFIED DATE OF THE FILE IN SAS

yabwon — Thu, 21 Dec 2023 07:18:54 GMT

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.