What are the joins,types of joins and thier functions?
Answer Posted / kush
Joins are used to join the datasets horizontally.
There are 2 types of joins: inner and outer joins.Outer joins includes left,right and full join.
Inner Join gives the matching records which are present in both the datasets.
Left join gives all the records that are present in left
dataset and matching records in right dataset.
Right join gives all the records in the right dataset and matching records in left datasets
full join gives all matching and non matching records found in both the datasets.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you explain the process of calendar?
explain what is factor analysis? : Sas-administrator
How many ways to overcome a missing values???
Are you involved in writing the inferential analysis plan? Tables specifications?
What is the use of %include statement?
What is SAS?
what is SAS OPTIMIZATION?
Mention what is PROC in SAS?
What is substr function?
What are the differences between sum function and using “+” operator?
what is data access? : Sas-di
how many display types available in sas bi dashboard? : Sas-bi
What do you understand by the term Normal Distribution?
Give e an example of..
Explain what is data step?