Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13393 Views
- SAS, I also Faced
- E-Mail Answers
Answer Posted / rus
There are three types of joins:
1. Cartesian Join
2. Inner Join
3. Outer Join
Cartesian Join gives the records for all the combinations
of both the datasets
Inner Join gives only the matching records from both the
datasets
outer join is of three types:
Left Join
Right Join
Self Join
Left Join gives both matched and unmatched records from the
left table/dataset
Right join gives both matched and unmatched records from
the right table/dataset
self join gives matching or unmatched records from the same
table based on the condition
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to create list output for cross-tabulations in proc freq?
Describe the ways in which you can create a macro variable?
Explain what is the use of proc gplot?
What’s the difference between var b1 – b3 and var b1 — b3?
What do the put and input function do?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What is SAS? What are the functions does it performs?
How would you identify a macro variable? : sas-macro
What do the mod and int function do? : Sas programming
What is the SAS data set?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
what r the job openings SAS for fresher graduates !
what is the Population you used in your project, is it ITT or PP?
What is the good sas programming practices for processing large data sets?
In proc transpose and data step with arrays which one you pick?
