topic Re: How to read File system - df -g | tail +2 using SAS DI transformations in SAS Data Management

How to read File system - df -g | tail +2 using SAS DI transformations

JJP1 — Wed, 09 Sep 2020 05:24:25 GMT

I am trying to create an SAS DI job for following code by making use of SAS existing transformation.

so i tried with new-->external file/Delimited/user written file reading options but none of them are having options to read or pass the file options from unix section in SAS DI.

can anyone please suggest any idea on this request ?

filename cccc pipe 'df -g | tail +2' lrecl=32767;
data cccc ;
infile cccc truncover;
input;
infile=compbl(_infile_);
run;

Re: How to read File system - df -g | tail +2 using SAS DI transformations

LinusH — Wed, 09 Sep 2020 07:31:22 GMT

Not sure exactly what problem you are facing. At least in my Linux env I had to change the tail syntax (tail -n 2). Once done I get the desired (?) output from File Reader.

Re: How to read File system - df -g | tail +2 using SAS DI transformations

JJP1 — Wed, 09 Sep 2020 07:55:35 GMT

Thanks @LinusH ,

How can i put the command df -g | tail in file please using SAS DI so that as you showed i can use file reader transformation to read the file.

yes this is what ia m expecting.

would you please help how you created df -g node (file node) in provided screen shot please ?

i tried with external file,delimited file options using SAS DI but not able to find options clearly.

so how do i create the file (df -g | tail ) please ? so that i can use file reader transformation to read same ?

Re: How to read File system - df -g | tail +2 using SAS DI transformations

LinusH — Wed, 09 Sep 2020 08:19:11 GMT

Re: How to read File system - df -g | tail +2 using SAS DI transformations

JJP1 — Wed, 09 Sep 2020 08:28:59 GMT

Thanks @LinusH i am not getting the option to paste the code and it is asking for file parameters to pass,
may i know how you created the file please (options please) i tried with following
new --->external-->delimited file/user written/fixed width options al,l i tried but none of them are allowing me to paste the code. please suggest