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
Can you execute macro within another macro? : sas-macro
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
Explain why double trailing @@ is used in input statement?
What do the mod and int function do? : Sas programming
For what purposes have you used sas macros? : sas-macro
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
what is business intelligence? : Sas-bi
How would you identify a macro variable? : sas-macro
explain the difference between proc means and proc summary?
describe about physical data integration? : Sas-di
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
Explain the main difference between the sas procedures and functions? : Sas-administrator
What would you change about your job?
What are the difference between sas functions and procedures?
State the difference between INFORMAT and FORMAT ?