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 information maps?

0 Answers   CitiGroup,

---

What are the features of base sas system?

0 Answers  

---

WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.

4 Answers   Genzyme,

---

data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks

3 Answers  

---

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

1 Answers   Pfizer,

---

Name validation tools used in SAS

0 Answers  

---

how do you read binary data in sas?

3 Answers   Satyam,

---

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

0 Answers   Quintiles,

---

name some data transformation used in sas di? : Sas-di

0 Answers  

---

what are the considerations when picking a SAS/STAT procedure?

0 Answers   Accenture, Quintiles,

---

How to create a permanent sas data set?

0 Answers  

---