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

Describe the ways in which you can create a macro variable?

832


How many ways to overcome a missing values???

2557


What is the difference between one to one merge and match merge? Give an example.

817


What do the PUT and INPUT functions do?

1011


What sas features do you use to check errors and data validation?

961


what is program data vector? : Sas-administrator

836


what does the run statement do? : Sas programming

788


What is the basic syntax of a sas program?

879


what are all the reports you generated in your recent project?

1949


How to sort in descending order?

1006


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

868


What is the difference between nodupkey and nodup options?

792


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

749


how does sas handle missing values in a merge? : Sas programming

776


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1378