Answer / 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.

Answer / mehul.v.thakkar@gmail.com

There are basically three types of joins in SAS,
1. Inner Join
2. Left Join
3. Right Join

Inner Join gives the records which are present in both the
datasets.

Left join gives all the records that are present in left
dataset irrespective of whether they have a matching record
in the right dataset.

Right join gives all the records in the right dataset
irrespective of whether they have a matching record in the
left dataset.

Answer / kush

Joins are used to join the datasets horizontally.

There are 2 types of joins: inner and outer joins.Outer joins includes left,right and full join.

Inner Join gives the matching records which are present in both the datasets.

Left join gives all the records that are present in left
dataset and matching records in right dataset.

Right join gives all the records in the right dataset and matching records in left datasets

full join gives all matching and non matching records found in both the datasets.

Answer / 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.

Answer / saifudheen

inner join...outer join...its used in open sql statements
to retrieve data from database..

Answer / mehul thakkar

There are basically three types of joins,
1. Inner Join
2. Left Join
3. Right Join

Inner Join gives the records which are present in both the
datasets.

Left join gives all the records that are present in left
dataset irrespective of whether they have a matching record
in the right dataset.

Right join gives all the records in the right dataset
irrespective of whether they have a matching record in the
left dataset.

Answer / rus

There are three types of joins:
1. Cartesian Join
2. Inner Join
3. Outer Join

Cartesian Join gives the records for all the combinations
of both the datasets

Inner Join gives only the matching records from both the
datasets

outer join is of three types:
Left Join
Right Join
Self Join

Left Join gives both matched and unmatched records from the
left table/dataset

Right join gives both matched and unmatched records from
the right table/dataset

self join gives matching or unmatched records from the same
table based on the condition

What is the difference between SAS Data step and SAS PROC SQL, and which is better?

1 Answers   TCS,

What is the difference between %local and %global?

1 Answers  

what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?

2 Answers   Wockhardt,

What is interleaving in SAS?

0 Answers  

What does the RUN statement do?

0 Answers   Quintiles,

What are symbol tables?Differemce between Local N Global Symbol tables.....

2 Answers   TCS,

what type of graphs we will create(for 2+years candidates)?

0 Answers   Accenture, Icon,

proc means? proc sort? proc append? proc freq? proc print? proc content?

4 Answers   Oracle,

What is the use of divide function?

0 Answers  

what is hash files in sas and why we are using this one in sas?

0 Answers   L&T, SAS,

tell me about use of arrays in sas

1 Answers   CoreEL,

for what purpose would you use the retain statement? : Sas programming

0 Answers