I want to know how the IN= operator works in merge . Need to know what it happens in PDV

[ambadi007]

Hi Team,

Iam new to SAS and I want to know how the IN= variable in works in merge , need exaples how it varies from all joins example left join right join inner join and full joins . I need how it different in PDV

Thanks 

Manesh KP

[LinusH]

Wow. There are literally tons of examples using merge with in=. Just search support.sas.com.
In= isn't typically used with SQL joins.

[ambadi007]

Hi Linush,

Thanks for the reply . I just want to know how in the background (PDV) it works . 

what is in= ?

how it works?

Thanks 

Manesh

[Kurt_Bremser]

IN= defines a boolean (=numeric) variable that is not included in output datasets and is intended for use in conditions.

[RW9 · Accepted solution]

You would be best off reading the manual on the subject:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000131134.htm

For instance.  In is a bit like an alias in SQL, so the statement:

if a...

a is 1 or 0 depending on if the record comes from that dataset which a references.