Where statement during Merging table

mlogan — Thu, 07 May 2015 14:48:34 GMT

Hi All,

Can anyone tell me where and how should I add the 'where clause' in the following code for merging two table. I want to add where name='Jack' for tabl1.

Data out;

merge Table1(in=a) apple.Table2(in=b);

by ID1; /*Common variable*/

if a=0;

run;

Re: Where statement during Merging table

RW9 — Thu, 07 May 2015 15:01:16 GMT

Hi,