What are the joins,types of joins and thier functions?
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 are the categories that sas informats are used to the place the data? : Sas-administrator
what is data governance? : Sas-di
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
How sas treats the dsd delimiters?
explain the difference between proc means and proc summary?
how the sas basic syntax style described? : Sas-administrator
How are numeric and character missing values represented internally?
How many data types are there in SAS?
Enlist the syntax rules followed in sas statements.
What are the different servers in sas? : sas-grid-administration
how does sas handle missing values in functions? : Sas programming
Differentiate between ceil and floor functions.
What makes sas stand out to be the best over other data analytics tools?
What are the prime responsibilities of data integration administrator? : Sas-di
What can be the size of largest dataset in SAS?