Answer Posted / ritesh

Can anybody mail me advanced sas dumps at Riteshkumargoyal@gmail.com

thanks in advance..

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.

2164

---

what is sas metadata repository? : Sas-bi

1055

---

What are the table names in oracle database...?

2690

---

What are the functions which are used for character handling functions?

1081

---

Can you execute macro within another macro? : sas-macro

938

---

Tell me more about the parameters in macro? : sas-macro

1011

---

What is the difference between where and if statement?

1062

---

Have you ever used the SAS Debugger?

1695

---

Explain proc sort?

1030

---

Explain translate function?

1133

---

What is interleaving in SAS?

1065

---

how do you want missing values handled? : Sas programming

900

---

how does sas handle missing values in assignment statements? : Sas programming

971

---

what is information maps?

2156

---

List down the reasons for choosing sas over other data analytics tools.

1214

---