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  

---

Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.

4 Answers  

---

Mention sas system options to debug sas macros.

0 Answers  

---

what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, Wipro,

---

How we can call macros with in data step? : sas-macro

0 Answers  

---

What is SAS?

0 Answers  

---

How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.

2 Answers  

---

What is the sas data set? : sas-grid-administration

0 Answers  

---

What are types of transport files?

2 Answers   PRA Health Sciences, Quintiles,

---

Can you execute macro within another macro? : sas-macro

0 Answers  

---

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

0 Answers  

---

Do you think professionally?

1 Answers   Oracle,

---