what kind of variables are collected in AE dataset?

3 Answers   Accenture, Quintiles, SAS,

---

WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION?

3 Answers   IBM, Zensar,

---

How do you control the number of observations and/or variables read or written?

0 Answers  

---

What is the difference between proportion and average?

0 Answers   KPMG,

---

define table lookup and how may ways it can be done...explian

3 Answers  

---

---

What has been your most common programming mistake?

4 Answers   Wipro,

---

is QUALCOMM using SAS ?

1 Answers  

---

What is SAS informats?

0 Answers  

---

How to get the repeated values by using sql in sas ?

2 Answers  

---

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

0 Answers  

---

What are the 3 components in sas programming?

0 Answers  

---

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  

---