how can u create zero observation dataset?

11 Answers   CitiGroup,

---

How to get the repeated values by using sql in sas ?

2 Answers  

---

is there any differnce between proc means and proc summary?

5 Answers  

---

Can anyone help to find a statement to get all the predefined formats?

3 Answers   Verinon Technology Solutions,

---

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.

0 Answers  

---

Difference between informat and format?

0 Answers  

---

1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question

8 Answers   CitiGroup,

---

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

5 Answers   TCS,

---

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

0 Answers  

---

How to select the observations randomly from a SAS dataset

7 Answers   NTT Data,

---

What will calendar procedure do?

0 Answers  

---

What is SAS? What are the functions does it performs?

0 Answers  

---