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.

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1071

---

for report generation which one you used proc report or data_null_?

7806

---

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1280

---

How many data types are there in SAS?

1085

---

What are SAS/ACCESS and SAS/CONNECT?

1152

---

what is the difference between unique key and primary key? : Sas-di

1139

---

What are the data types in sas?

1069

---

for whom is sas data integration studio designed? : Sas-di

1012

---

To what type of programms have you used scratch macros?

2575

---

For what purposes have you used sas macros? : sas-macro

1003

---

Have you used macros? For what purpose you have used? : sas-macro

1043

---

What is the role of administrative users? : sas-grid-administration

1084

---

What is the basic structure of the SAS base program?

1337

---

Describe the function and utility of the most difficult SAS macro that you have written?

2572

---

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1501

---