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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.