Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13886 Views
- SAS, I also Faced
- E-Mail Answers
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 long can a macro variable be? A token? : sas-macro
how would you create multiple observations from a single observation? : Sas programming
explain what is data set in sas? : Sas-administrator
Difference between nodup and nodupkey options?
Give e an example of..
Tell e how how dealt with..
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
how does sas handle missing values in functions? : Sas programming
what is sas business intelligence? : Sas-bi
What are the features of base sas system?
how do you pull data from equifax?tell me the process?
Mention common programming errors committed in sas ?
: and & modifiers.
what is the basic structure sas administrator? : Sas-administrator
How do you convert basic cube to transaction cube and transaction cube to basic cube?
