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

how does sas handle missing values in procs? : Sas programming

1151

---

What are the parameters of scan function?

1100

---

What do the mod and int function do? : Sas programming

1125

---

where to use sas business intelligence? : Sas-bi

999

---

Explain append procedure?

1017

---

Explain the purpose of retain statement.

1001

---

What are SAS/ACCESS and SAS/CONNECT?

1084

---

For what purpose would you use the RETAIN statement?

1460

---

what do the pad and dim functions do? : Sas programming

958

---

Mention the category in which sas informats are placed?

974

---

how to change the execute of macro

2216

---

Mention common programming errors committed in sas ?

1056

---

Tell me more about the parameters in macro? : sas-macro

1005

---

How many data types are there in SAS?

999

---

What are the new features included in the new version of SAS Programming Language?

1149

---