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.

0 Answers  

---

what is sas? is a package or tool? give me introduction about sas?

11 Answers   Accenture,

---

what is intially documentation in sas?

1 Answers   Accenture,

---

what is slowly changing dimension? : Sas-di

0 Answers  

---

How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.

2 Answers  

---

what is picture format? give any one example?

3 Answers   Parexel,

---

What makes sas stand out to be the best over other data analytics tools?

0 Answers  

---

Which of the following is not created during compilation phase?

2 Answers   SAS,

---

how can you create zero observation dataset? : Sas programming

0 Answers  

---

how to generate the test data in sas without input data? : Sas-administrator

0 Answers  

---

Explain append procedure?

0 Answers  

---

What's the difference between VAR A1 - A4 and VAR A1 - A4?

1 Answers   Quintiles,

---