Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Where statement during Merging table

Reply
Regular Contributor
Posts: 218

Where statement during Merging table

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;

Super User
Super User
Posts: 7,988

Re: Where statement during Merging table

Hi,

Data out;

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

by ID1;  /*Common variable*/

if a=0;

run;

Ask a Question
Discussion stats
  • 1 reply
  • 285 views
  • 0 likes
  • 2 in conversation