topic Re: SAS Script to identify unix files does not have owner and email same report in SAS Programming

SAS Script to identify unix files does not have owner and email same report

JJP1 — Thu, 20 Aug 2020 10:00:16 GMT

hi all ,

would you pleas help on sas script that identify the files in unix environment that does not have owner name and send the report for same please. so that i can verify and delete accordingly.

Sample file in /home/data - directory that does not have owner name

-rwxrwx--- 1 759320 sssssss 24167 24 Oct 2008 FFFFFFFFF.TXT

Re: SAS Script to identify unix files does not have owner and email same report

andreas_lds — Thu, 20 Aug 2020 10:05:24 GMT

I haven't worked with unix for some time, but why do you want to bring sas into this problem, such things should be solvable with bash-commands easily.

Humbly asking @Kurt_Bremser for to share his wisdom.

Re: SAS Script to identify unix files does not have owner and email same report

Kurt_Bremser — Thu, 20 Aug 2020 10:18:22 GMT

I'm coming!

That is a UNIX one-liner:

find /home/data -nouser

To read the list of resulting names into a SAS dataset, do

filename oscmd pipe "find /home/data -nouser 2>&1";

data names;
infile oscmd truncover;
input name $200.;
run;

The "2>&1" construct reroutes stderr output to stdout, so in case of a problem you get one or a few observation(s) containing the problem message.