topic Re: How do I get output of GREP command in SAS. in SAS Programming

How do I get output of GREP command in SAS.

aj34321 — Wed, 11 May 2016 03:04:36 GMT

Hi, Im running some GREP commands and was wondering if I can execute GREP command from SAS and the output is directed directly into SAS dataset instead of text file followed by import. Pls guide.

Re: How do I get output of GREP command in SAS.

LinusH — Wed, 11 May 2016 03:38:11 GMT

Try filename pipe.

Re: How do I get output of GREP command in SAS.

Reeza — Wed, 11 May 2016 03:57:57 GMT

See this thread for a very similar question

https://communities.sas.com/t5/Base-SAS-Programming/Obtaining-quot-Shell-Output-quot-in-sas-with-SAS-function-quot/m-p/269120

Re: How do I get output of GREP command in SAS.

aj34321 — Wed, 11 May 2016 05:40:57 GMT

Thank you LinusH. filename pipe works like anything..

Re: How do I get output of GREP command in SAS.

aj34321 — Wed, 11 May 2016 05:41:58 GMT

Thank you Reeza.. filename pipe worked for me...

Re: How do I get output of GREP command in SAS.

aj34321 — Wed, 11 May 2016 06:33:35 GMT

Hi Linus, Although the code is working but I think I'm doing something wrong in this.

Below is the command I run from unix and I get 300 rows for this sample pattern.

grep -H -R 'real time' /path/pattern_2016*

In SAS i have written this below macro

filename grep_src pipe "grep -H -R &gpattern. &grep_path.&gfilter.";
data grep_&glev._&gstream.;
infile grep_src;
length runtime_str $ 300;
input runtime_str $ 300.;
run;

And the output is exactly half of the rows when compared with actual unix executed grep command.

What do you think the issue may be?

Re: How do I get output of GREP command in SAS.

FreelanceReinh — Wed, 11 May 2016 16:07:22 GMT

@aj34321 wrote:
(...)
And the output is exactly half of the rows when compared with actual unix executed grep command.

What do you think the issue may be?

Hi @aj34321,

Your log contains the note

NOTE: SAS went to a new line when INPUT statement reached past the end of a line.

doesn't it? This is because with formatted input (input runtime_str $300.;) and the default option FLOWOVER, SAS attempts to read more data from the next record when the record length is less than the format length (here: 300). But this doesn't make sense here and fails. Thus, only one output record is created per two input records.

Just add the TRUNCOVER option to your INFILE statement and everything should be fine:

infile grep_src truncover;

Re: How do I get output of GREP command in SAS.

aj34321 — Thu, 12 May 2016 07:13:58 GMT

Yes that was missing and it works...