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.

How are numeric and character missing values represented internally?

1605

---

What is the order of application for output data set options, input data set options and SAS statements?

1503

---

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

7623

---

describe the interaction table in sas di? : Sas-di

965

---

what is the difference between infile and input? : Sas-administrator

1062

---

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

946

---

How to create an external dataset with sas code?

1068

---

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2855

---

What is the use of function Proc summary?

1210

---

how many types of prompts are there? : Sas-bi

1033

---

What are the functions which are used for character handling functions?

1078

---

Mention how to limit decimal places for the variable using proc means?

1057

---

Which function is used to count the number of intervals between two sas dates?

1066

---

explain the difference between proc means and proc summary?

1071

---

how to debug and test the sas program? : Sas-administrator

973

---