Interview Questions   Tutorials   Discussions   Programs   Videos   

SAS - What are the joins, types of joins and their functions?




350
views
asked mar September 20, 2014 06:29 AM  

What are the joins, types of joins and their functions?


           

2 Answers



 
answered By vishnoiprem   0  

The three types of join are inner join, left join and right join. The inner join option takes the matching values from both the tables by the ON option. The left join selects all the variables from the first table and joins second table to it. The right join selects all the variables of table b first and join the table a to it

flag   
   add comment

 
answered By vishnoiprem   0  

You can use ANSI join MERG ans SET

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert