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 to intersect the tables by using PROC MIXED?
how to perform paired t-test using Base/SAS & SAS/Stat?
What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.
2 Answers ABC, ASD Lab, CitiGroup,
What is LOGICAL VARIABLES in SAS.And how it can be used..Can anyone support..???
What is run-group processing?
How do you write a test plan?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.
what is picture format? give any one example?
How would you determine how far down on a page you have printed in order to print out footnotes?
how can you sort the dataset having millions of OBS(instead of sort procedure?