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.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between nodup and nodupkey options?

820


What would be the value of month at the end of data step execution and how many observations would be there?

821


what is the use of proc sql? : Sas programming

815


what is the purpose of _error_? : Sas programming

878


How will you generate test data with no input data?

845


describe the interaction table in sas di? : Sas-di

808


what is the difference between unique key and primary key? : Sas-di

851


What are the default statistics that proc means produce?

818


how could you generate test data with no input data? : Sas programming

909


What are types of transport files?

7426


What are the table names in oracle database...?

2519


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1549


What is the difference between input and infile statement?

906


How to convert a numeric variable to a character variable?

894


What is run-group processing?

884