How substr function works in sas?

0 Answers  

---

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

0 Answers  

---

What are the difference between the sas data step and sas procs?

0 Answers  

---

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 the primary data source for the wrs? : Sas-bi

0 Answers  

---

Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 Answers  

---

Name some categories in sas 9? : sas-grid-administration

0 Answers  

---

"What is the difference between proc sort nodup and proc sort nodupkey?"

2 Answers  

---

Tell e how how dealt with..

0 Answers  

---

How to convert HTML file into SAS dataset?

0 Answers  

---

Explain the message 'Merge has one or more datasets with repeats of by variables'.

5 Answers  

---

How to read the file names of a text files from a shared drive using SAS?

1 Answers   HSBC, WNS,

---