What are the joins,types of joins and thier functions?
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
State the difference between INFORMAT and FORMAT ?
What are the implications?
What is maximum storage capability of SAS?
How do you define proc in sas? : sas-grid-administration
Compare sas with other data analytics tools.
I have a dataset concat having variable a b & c. How to rename a b to e & f?
what is null hypothesis? why do you consider that?
What are common programming errors committed in sas
What do the mod and int function do? : Sas programming
What is the maximum length of the macro variable?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
What is the difference between nodupkey and nodup options?
what is the use of proc contents and proc print in sas? : Sas-administrator
what is program data vector? : Sas-administrator