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 / 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 |
how do we get duplicate observations in a separate dataset?
What is interleaving in SAS?
what is hierarchy flattening? : Sas-di
What is the use of %include statement?
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
What is program data vector (pdv)?
How do you add a number to a macro variable? : sas-macro
how many types prompting framework can be broken down to? : Sas-bi
Difference between nodup and nodupkey options?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
what is prime numbers? how we can get plc write sas code?