Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13662 Views
- SAS, I also Faced
- E-Mail Answers
Answer Posted / shwetha
1.simple join:-to report matching data from various tables
2.inner join:- to report data.Conditional clause implemented
by on clause.For inner & outer join.
3.outer join:- left join:-to report data from the left side
table & matching data from right side table,right
join:-report overall data from right side& matching data
from the left side table,full join:- report overall data
from both tables & matching.
union join:- adding & combining.
self join:-the table join with same table
natural join:- report matching data from the variable tables
without using conditions.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the maximum length of the macro variable?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
how sas deals with business intelligence? : Sas-bi
How do you specify the number of iterations and specific condition within a single do loop?
How necessary is it to be creative in your work?
describe about physical data integration? : Sas-di
What do the put and input function do?
what other sas products have you used and consider yourself proficient in using? : Sas programming
name some data transformation used in sas di? : Sas-di
How you can read the variables that you need?
how to generate the test data in sas without input data? : Sas-administrator
how does sas handle missing values in sort order? : Sas programming
what are the component of range? : Sas-bi
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
