Where statement during Merging table

[mlogan]

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;

[RW9]

Hi,

Data out;

merge Table1(in=a where=(name="jack")) apple.Table2(in=b);

by ID1;  /*Common variable*/

if a=0;

run;