Answer Posted / uma

first sort these datasets by common variable DEPT_ID,Then
use the following:
data left_join;
merge emp (in=a) dept (in=b);
by dept_id;
if a then output;
run;

Explain the difference between using drop = data set option in set and data statement?

1150

---

how does sas handle missing values in assignment statements? : Sas programming

1015

---

how do you test for missing values? : Sas programming

1045

---

What is the good sas programming practices for processing large data sets?

1104

---

Mention the validation tools used in SAS?

1159

---

Which date function advances a date, time or datetime value by a given interval?

1138

---

I need level 2 to 5 sas using companies in india

2377

---

What can be the size of largest dataset in SAS?

1222

---

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

1082

---

How does the internal authentication work in sas? : sas-grid-administration

1113

---

How do you define proc in sas? : sas-grid-administration

1073

---

what can you learn from the sas log when debugging? : Sas programming

1081

---

Difference between informat and format?

1084

---

Which are the statements whose placement in the data step is critical?

1252

---

What Proc glm does?

1076

---