Interested to Buy Any Domain ? << Click Here >> for more details...
What are the joins,types of joins and thier functions?
- 7 Answers
- 13683 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 can you learn from the sas log when debugging? : Sas programming
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
List out some key concept of SAS
What is the maximum and minimum length of macro variable
What is the basic structure of the SAS base program?
Are you sensitive to code walk-throughs peer review or QC review?
How would you identify a macro variable? : sas-macro
How to create list output for cross-tabulations in proc freq?
explain about various caches available in data integrator? : Sas-di
Are you involved in writing the inferential analysis plan? Tables specfications?
what are the types of interactive display types? : Sas-bi
Do you need to rearrange the order of the data for the report?
what is intially documentation in sas?
How is character variable converted into numeric variable and vice versa?
