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 is the Population you used in your project, is it ITT or PP?

2747

---

what is star schema? : Sas-di

1131

---

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2463

---

What are the data types in sas?

1063

---

What does P-value signify about the statistical data?

1367

---

Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1881

---

Mention the category in which sas informats are placed?

1020

---

What can be the size of largest dataset in SAS?

1234

---

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1080

---

Difference between SAS STATA & SPSS?

1126

---

what is transformation in sas data integration? : Sas-di

1036

---

Mention what is PROC in SAS?

1060

---

Explain translate function?

1213

---

What is the difference between where and if statement?

1117

---

What are the different operating system platforms in which we can use sas? : sas-grid-administration

1075

---