What are the joins,types of joins and thier functions?
Answer Posted / sree
There are two types of joins
1.Inner joins
2.Outer joins
The outer join is of 3 kinds
- Right join
- Left join
- Full join
Inner join have following characteristics
-return only matching rows
allow max of 32 tables to be joined at the same time
Outer joins--can retrive nonmatching as well as matching
rows.
--outer joins are limited to two tables at a time.
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How would you identify a macro variable?
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
What is the maximum length of the macro variable? : sas-macro
what are the considerations when picking a SAS/STAT procedure?
How do you test for missing values?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What commands are used in the case of including or excluding any specific variables in the data set?
List out some key concept of SAS
what is the basic structure sas administrator? : Sas-administrator
what is factor analysis? : Sas-administrator
what is the function of catx syntax? : Sas-administrator
how do you test for missing values? : Sas programming
what is snowflake schema? : Sas-di
what is the Population you used in your project, is it ITT or PP?
Difference between informat and format?