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

Hi, If anyone has base SAS certification dumps, please share.

1810

---

Compare sas with other data analytics tools.

983

---

What is the use of PROC gplot?

1070

---

What are the difference between the sas data step and sas procs?

1103

---

What are the data types in sas?

1004

---

How can I remove header from output data set?

2576

---

what is sas database server? : Sas-di

1053

---

What is the function of Stop statement in a SAS Program?

1093

---

How do you delete duplicate observations in sas?

1011

---

what is data governance? : Sas-di

971

---

what are validation tools that are used in sas? : Sas-administrator

1004

---

what is intially documentation in sas?

4959

---

What is the difference between %put and symbolgen? : sas-macro

1161

---

How would you define the end of a macro? : sas-macro

1040

---

What is the purpose of trailing @ and @@? How do you use them?

984

---