Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13870 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 enterprise guide? What is the use of it? : Sas programming
What are the differences between proc means and proc summary?
how does sas handle missing values in sort order? : Sas programming
What will calendar procedure do?
what has been your most common programming mistake? : Sas programming
what is the effect of the options statement errors=1? : Sas programming
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
Give some ways by which you can define the variables to produce the summary report (using proc report)?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
what is SAS OPTIMIZATION?
What is factor analysis?
how many display types available in sas bi dashboard? : Sas-bi
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
Differentiate between sas functions and sas procedures.
