what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

0 Answers  

---

what is the difference between the SAS v8 and SAS v9?

7 Answers   TCS,

---

How to Rename Library?

3 Answers  

---

What is the maximum length of the macro variable? : sas-macro

0 Answers  

---

We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B

3 Answers  

---

How would you keep from overlaying the a SAS set with its sorted version?

4 Answers  

---

In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;

1 Answers  

---

Give some examples where proc report’s defaults are same as proc print’s defaults?

0 Answers  

---

how does sas handle missing values in a merge? : Sas programming

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.

0 Answers  

---

calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15

6 Answers  

---

what is Global Symbol table and Local symbol table?

4 Answers   CitiGroup,

---