Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13670 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 to read the variables in sas? : Sas-administrator
which date functions advances a date time or date/time value by a given interval? : Sas programming
what is the difference between floor and ceil functions in sas? : Sas-administrator
what versions of sas have you used (on which platforms)? : Sas programming
What is SAS?
What is the difference between reading data from an external file and reading data from an existing data set?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Describe the ways in which you can create a macro variable?
what has been your most common programming mistake? : Sas programming
how does sas handle missing values in sort order? : Sas programming
what is the use of proc contents and proc print in sas? : Sas-administrator
How sas treats the dsd delimiters?
Tell me more about the parameters in macro? : sas-macro
What is the work of tranwrd function?
What are the uses of sas?
