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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: