Answer / 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

Answer / siddu

Before doing the merge process we have to do sorting depended the key variable, but in proc sql joins no need to do sorting.

Answer / nrtya vardhanapu

merge is a statement which is used in the data step Whereas
join is a procedure which is used in the proc step. But the
outputs produced are the same !!!!

how does sas handle missing values in functions? : Sas programming

0 Answers  

---

Mention what is PROC in SAS?

0 Answers  

---

what is the main difference between rename and label? (don't say that they both perform the same function).

11 Answers   Parexel,

---

what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?

1 Answers  

---

is QUALCOMM using SAS ?

1 Answers  

---

What is SAS? is it a software just for use or we can creat something over there?

5 Answers   Cognizant,

---

How would you delete observations with duplicate keys?

13 Answers   Accenture,

---

List out some key concept of SAS

0 Answers  

---

What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.

2 Answers   ABC, ASD Lab, CitiGroup,

---

What is the difference between order and group variable in proc report?

0 Answers  

---

Write a SAS macro to calculate number of numbers in an email address

2 Answers  

---

I have a dataset with variables empid and doj how to calculate retirement age?

1 Answers  

---