topic Re: Can We infile all logs in a folder by their owner ? in SAS Programming

Can We infile all logs in a folder by their owner ?

J111 — Mon, 06 Feb 2023 08:06:12 GMT

We are using infile of all logs in a folder with the code:-

infile 'foldername/*.log'

There is an owner information near the log name, in Linux.

Can we use this owner information in sas ?

Instead of all the logs in the folder - to infile only logs with a specific owner (user name) that created the logs.

ChrisHemedinger — Mon, 06 Feb 2023 12:57:56 GMT

The INFILE wildcard syntax does not support a filter by owner.

You could use an OS command (issued through FILENAME PIPE or SYSTASK) to generate a list of matching files.

find ./*.log -maxdepth 1 -user <ownerid> -ls

Or you can use DATA step functions to FOPEN each file and retrieve "Owner Name" info using FINFO. Documentation here.

J111 — Mon, 06 Feb 2023 13:26:52 GMT

Thanks we shall check it.