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  

---

In the flow of DATA step processing, what is the first action in a typical DATA Step?

6 Answers   Accenture,

---

diff between nodup rec and ondup key???

3 Answers   AON, Sciformix,

---

i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?

1 Answers   L&T,

---

data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.

1 Answers  

---

Code the MEANS to produce output to be used later.

2 Answers  

---

If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

8 Answers   Accenture,

---

what is the effect of the options statement errors=1? : Sas programming

0 Answers  

---

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

0 Answers  

---

Explain translate function?

0 Answers  

---

One way of creating a new variable in Macros is by % Let....What is the other way..?

5 Answers   TCS,

---

Difference between SAS STATA & SPSS?

0 Answers  

---