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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.