Answer / mili

options nolabel;

What other SAS features do you use for error trapping and data validation?

2 Answers  

---

Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 Answers  

---

how to rearrange the data as our wish by using dataset block?

4 Answers   Cognizant,

---

1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 Answers  

---

How do you control the number of observations and/or variables read or written?

0 Answers  

---

. Which date advances a date, time or date/time value by a given interval?

8 Answers  

---

What is the Program Data Vector (PDV)? What are its functions?

5 Answers   Accenture,

---

What is the difference between SAS functions and procedures?

0 Answers  

---

what is OLAP?

4 Answers   CitiGroup, TCS,

---

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  

---

Name any two sas spawners? : sas-grid-administration

0 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  

---