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

What does the trace option do?

0 Answers  


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

0 Answers  


Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 Answers  


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

0 Answers  


What is the size of PDV?

2 Answers   L&T,






Under what circumstances would you code a SELECT construct instead of IF statements?

7 Answers   Accenture,


What is the use of function Proc summary?

0 Answers  


data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.

2 Answers  


How would you delete duplicate observations?

10 Answers   Accenture,


if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually

4 Answers   Accenture,


How do you add a number to a macro variable? : sas-macro

0 Answers  


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  


Categories