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
Describe the ways in which you can create a macro variable?
How many ways to overcome a missing values???
What is the difference between one to one merge and match merge? Give an example.
What do the PUT and INPUT functions do?
What sas features do you use to check errors and data validation?
what is program data vector? : Sas-administrator
what does the run statement do? : Sas programming
What is the basic syntax of a sas program?
what are all the reports you generated in your recent project?
How to sort in descending order?
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?
What is the difference between nodupkey and nodup options?
How do you add a number to a macro variable? : sas-macro
how does sas handle missing values in a merge? : Sas programming
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