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
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.
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
IN= defines a boolean (=numeric) variable that is not included in output datasets and is intended for use in conditions.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.