Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13682 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 can I remove header from output data set?
What is factor analysis?
Describe the ways in which you can create macro variables?
how will you location sas platform applications available from web browser? : Sas-bi
what is the use of proc sql? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?
Explain input and put function?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
what are validation tools that are used in sas? : Sas-administrator
Differentiate between proc means and proc summary.
it will become easy if uuu provide website linkssss and list of consultanciessssss
What is the difference between where and if statement?
What is the length assigned to the target variable by the scan function?
In proc transpose and data step with arrays which one you pick?
