topic Re: How do I extract filename, path, and date modified from a mounted directory? in SAS Viya

How do I extract filename, path, and date modified from a mounted directory?

Ryanb2 — Wed, 18 Sep 2024 04:55:40 GMT

I had been using the code below and do some parsing to create an inventory of the contents of a folder and subfolders including path, name of file, file extension, date modified, time modified, and file size. However, our IT department is taking away our ability to use the ls command inside Viya making this code obsolete.

	filename pipedir pipe %sysfunc(quote(ls -lR --full-time "&pathDir" )) lrecl=1000;
	data DIR_RAW;
		infile pipedir truncover;
		input line $char1000.;
	run;

I was directed to other SAS options such as data information functions (Paper Template (lexjansen.com) but from what I can tell they're pretty limited. For example, I can get the filename but not the path if the file is in a sub-folder. I also can't seem to find a way to get the date modified, time modified, or file size.

If I only needed to inventory SAS datasets then I could use proc datasets (SAS Help Center: Requesting a Directory Listing for a SAS Library) to get most of the information I need, but I need all file types. It also doesn't seem to include sub-folders.

Any ideas? Using SAS Viya V.03.05M0P111119

Re: How do I extract filename, path, and date modified from a mounted directory?

Patrick — Wed, 18 Sep 2024 06:37:40 GMT

The %dirtree() macro should provide the functionality you need.

https://github.com/sasutils/macros/blob/master/dirtree.sas

Re: How do I extract filename, path, and date modified from a mounted directory?

yabwon — Wed, 18 Sep 2024 07:07:39 GMT

I'd recommend using the BasePlus package, in particular the %dirsandfiles() macro. The macro gives you the list of files and sub-directories (with content) plus all that "metadata" stuff. It works OS independent, so on Win/Linux/UNIX.

This article, Appendix B, page 20, gives you quick instruction on how to install and use the package.

Bart

Re: How do I extract filename, path, and date modified from a mounted directory?

Kurt_Bremser — Wed, 18 Sep 2024 09:30:10 GMT

If you want to code this yourself instead of using a foreign macro, look at my presentation Talking to Your Host

Re: How do I extract filename, path, and date modified from a mounted directory?

yabwon — Wed, 18 Sep 2024 10:36:45 GMT

Kurt, the macro I mentioned essentially uses your paper code (plus add some additional features to it). I'm even attaching your article to the package.

Bart