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.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to ..

Answer / ksuresh179

I think we can use VB script to draw pivot tables in Excel
by using SAS. but I do not have any kind of examples.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More SAS Interview Questions

In PROC PRINT, can you print only variables that begin with the letter “A”?

8 Answers  


How would you generate 1000 observations from a normal distribution with a mean of 50 and standard deviation of 20. How would you use PROC CHART to look at the distribution? Describe the shape of the distribution.

1 Answers  


what is prime numbers? how we can get plc write sas code?

5 Answers   Icon,


What is the difference between reading data from an external file and reading data from an existing data set?

0 Answers  


What is the purpose of the trailing and How would you use them?

8 Answers  






What is factor analysis?

0 Answers  


What is _n_?

23 Answers   Accenture,


HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?

3 Answers   Accenture, Novartis,


How will you generate test data with no input data?

0 Answers  


I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 Answers  


hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process

2 Answers   HSBC,


Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?

1 Answers   Icon,


Categories