topic Re: How do I inventory a mounted LAN folder from SAS Viya? in SAS Viya

How do I inventory a mounted LAN folder from SAS Viya?

Ryanb2 — Wed, 07 Feb 2024 07:02:37 GMT

I'm a base SAS user but getting into SAS Viya. One thing I do frequently in base SAS is inventory files on the local network or my C drive as shown below:

filename pipedir pipe %sysfunc(quote( dir "C:\TEMP" /S )) lrecl=1000;
data indata;
infile pipedir truncover;
input line $char1000.;
run;

It returns raw information about the folder path, the contents of the folder, the subfolder paths and subfolder contents. Each file includes date/time modified, and file size in addition to the filenames. I can parse and combine the raw data to get exactly what I need which I then use to find new files and import them automatically.

However, when I run similar code in SAS Viya using an NFS mounted drive I only get the filenames for the immediate folder. No subfolders and none of the other information. This is useful enough for most purposes but not including the subfolders is going to be a problem. Does anyone know how to get the kind of information I get using my PC SAS version when using SAS Viya for a mounted drive? Because SAS Viya exists on a Linux server are there some Linux commands that can be run from my SAS code that give me what I need?

Re: How do I inventory a mounted LAN folder from SAS Viya?

gwootton — Wed, 07 Feb 2024 18:24:10 GMT

In Windows, dir /S is a recursive path listing, the equivalent command in linux would probably be ls -lR /path/to/read.

Re: How do I inventory a mounted LAN folder from SAS Viya?

Ryanb2 — Wed, 07 Feb 2024 19:11:28 GMT

Wow! I was not sure where to put your changes in my line but it worked on the first try! Very nice. The format is different than in windows but the information is the same and it includes the subfolders. Much appreciated!

filename pipedir pipe %sysfunc(quote( dir ls -lR "C:\TEMP" )) lrecl=1000;

data DIR;
infile pipedir truncover;
input line $char1000.;
run;

Re: How do I inventory a mounted LAN folder from SAS Viya?

gwootton — Wed, 07 Feb 2024 19:24:35 GMT

I'm pleased you got what you were looking for! To clarify, this line:

filename pipedir pipe %sysfunc(quote(dir "C:\TEMP" /S)) lrecl=1000;

Is creating a fileref called "pipedir" that when called runs the command 'dir C:\TEMP" /s' and provides the output of this command through the fileref.

Linux doesn't have drive letters, so it's temp directory is typically /tmp. Instead of running "dir" we are running "ls", so "dir" would not be needed any longer. So, a comparable line for Linux would be (I'm removing the sysfunc and quote pieces since I don't think they're needed here):

filename pipedir pipe "ls -lR /tmp" lrecl=1000;

Re: How do I inventory a mounted LAN folder from SAS Viya?

Ryanb2 — Wed, 07 Feb 2024 19:34:00 GMT

Thanks! Yes. I was masking my path and pasted my example in the wrong format. I appreciate you making that clear and for letting me know I don't need DIR or quotes in the command statement. I pasted some code below that worked as you described.

filename pipedir pipe %sysfunc(quote(ls -lR /TEMP )) lrecl=1000;
data DIR;
     infile pipedir truncover;
     input line $char1000.;
run;

Re: How do I inventory a mounted LAN folder from SAS Viya?

Ryanb2 — Thu, 08 Feb 2024 02:55:29 GMT

I'm very close but I'm getting some strange results:

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

this code returns some values with the year and others with the time.

It will provide one or the other but never both, at least in the sample I reviewed.

Re: How do I inventory a mounted LAN folder from SAS Viya?

Ryanb2 — Thu, 08 Feb 2024 04:38:22 GMT

I looked up ls parameters and came across --full-time. It generates output a little different than before but everything is now consistent.

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