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  

---

Describe the ways in which you can create a macro variable?

0 Answers  

---

is there any difference between proc summary and proc means?

3 Answers  

---

describe the interaction table in sas di? : Sas-di

0 Answers  

---

What is _n_?

22 Answers  

---

How do you add a number to a macro variable?

2 Answers  

---

Give an example where SAS fails to convert character value to numeric value automatically?

0 Answers  

---

What is substr function?

0 Answers  

---

I need level 2 to 5 sas using companies in india

0 Answers  

---

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  

---

What do the mod and int function do? : Sas programming

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,

---