Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13708 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
Where do you use proc means over proc freq?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
What is PROC in SAS?
Explain translate function?
Differentiate between format and informat? : sas-grid-administration
why is sas data integration studio important? : Sas-di
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
what are 5 ways to perform a table lookup in sas? : Sas-administrator
What do the SAS log messages "numeric values have been converted to character" mean?
How do you delete duplicate observations in sas?
how do you test for missing values? : Sas programming
how does sas handle missing values in assignment statements? : Sas programming
How we can create SAS USER DEFINED CODE?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
