Answer Posted / rajitha macherla

The resultant dataset depends on the input datasets.
In case of one to one and one to many both work
similarly,i.e. the resultant dataset is same.
But differs in case of many to many and non matching
datasets:
many to many:
ex: (merge on x) (proc sql)
X Y X Z X Y Z X Y Z
----- ------ ------- -------
1 A 1 F 1 A F 1 A F
1 C 1 R ---> 1 C R 1 A R
2 B 2 G 2 B G 1 C F
1 C R
2 B G


NON MATCHING DATA:

ex: (merge on x) (proc sql)
X Y X Z X Y Z X Y Z
----- ------ ------- -------
1 A 1 F 1 A F 1 A F
2 B 3 T ---> 2 B . 3 C T
3 C 4 G 3 C T
4 . G

What are the prime responsibilities of data integration administrator? : Sas-di

1061

---

What are the limitations for memory allocation for SAS variables

1482

---

Difference between nodup and nodupkey options?

1184

---

How do you use the do loop if you don’t know how many times you should execute the do loop?

1256

---

What do you understand by the term Normal Distribution?

982

---

What are the features of SAS?

1030

---

What is connection profile? : sas-grid-administration

1160

---

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1136

---

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

1267

---

What are the special input delimiters used in SAS?

1174

---

What is the difference between proportion and average?

3329

---

What does PROC print, and PROC contents do?

1226

---

What is the difference between class statement and by statement in proc means?

1283

---

What is program data vector (pdv)?

1279

---

What are the functions used for character handling?

1248

---