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 does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
Do you need to rearrange the order of the data for the report?
what the use of proc glm
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
Are you involved in writing the inferential analysis plan? Tables specifications?
Define run-group processing?
What is SAS Information Map Studio and its purpose ?
what is change analysis in sas di ? : Sas-di
i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?
What is Linear Regression?
How to do user inputs and command line arguments in SAS? D&B