topic Re: Problem with x command in SAS Programming

Problem with x command

sfffdg — Wed, 24 Jan 2018 05:21:39 GMT

The below command is not working properly.

x " tac &archivefile. | awk '!NF {print ""};NF {if (n) {print} else {n=1}}' | tac > &rawfile. ";

Ideally it should create a &rawfile with some lines,ignoring last non empty line from archive file.

But it is creating just an empty &rawfile.

There is no problem with the linux command,it is worling fine in linux .

The comand is shown below after resolving the macro variables.

$ tac APPDIRECT_PROD_2018011107.dat | awk '!NF {print ""};NF {if (n) {print} else {n=1}}' | tac > /vfau/vfau_sit/sit05/datain/AppDirect/Landing/APPDIRECT_PROD_2018011107.dat

What exactly the problem with my x command ?

Re: Problem with x command

Kurt_Bremser — Wed, 24 Jan 2018 05:34:01 GMT

Add

2>&1

to the end of your command, and you'll find any eventual error message(s) in your .dat file.

Re: Problem with x command

sfffdg — Wed, 24 Jan 2018 06:42:56 GMT

Thank you sir!!

Re: Problem with x command

Kurt_Bremser — Wed, 24 Jan 2018 06:49:05 GMT

Hi!

Glad I could be of help.

What did you find?