At compile time when a SAS data set is read, what items are created?

14 Answers   Accenture,

---

What is difference between Global n Local Macro Variables..?

6 Answers   TCS,

---

what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, Wipro,

---

What is maximum storage capability of SAS?

0 Answers  

---

How to save the log information in a file for future use

2 Answers   HCL,

---

---

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  

---

tell me about intnx, intcx functions?

4 Answers   CitiGroup,

---

what is the function of catx syntax? : Sas-administrator

0 Answers  

---

how do you derive descriptive statistics?

1 Answers   Accenture, Quintiles,

---

How experienced are you with customized reporting and use of Data _Null_ features?

4 Answers   Oracle,

---

What are the data types that sas contain?

0 Answers  

---

Have you been involved in editing the data or writing data queries?

1 Answers   BioServe, Oracle, Sasken,

---