topic Re: I want to know how the IN= operator works in merge . Need to know what it happens in PDV in SAS Programming

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

ambadi007 — Tue, 26 Apr 2016 04:32:46 GMT

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

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

LinusH — Tue, 26 Apr 2016 05:50:09 GMT

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

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

ambadi007 — Tue, 26 Apr 2016 05:53:49 GMT

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

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

Kurt_Bremser — Tue, 26 Apr 2016 06:53:05 GMT

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

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

RW9 — Tue, 26 Apr 2016 07:37:48 GMT

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.