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?

0 Answers   Oracle,

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

1 Answers  

---

what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,

---

What is proc sql pass through facility?

4 Answers   L&T,

---

What is interleaving in SAS?

0 Answers  

---

Explain how merging helps to combine data sets.

0 Answers  

---

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

2 Answers   Accenture,

---

what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.

1 Answers   TCS,

---

What do you know about symput and symget?

0 Answers  

---

What are Dashboard reports?And significance of these in analysis?

1 Answers  

---

what is lifetest

1 Answers   Cognizant,

---

diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,

---