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 |
List out some key concept of SAS
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
What is the basic structure of a sas program?
How do i read multiple spaces in datasets?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
How to read the file names of a text files from a shared drive using SAS?
what is hash files in sas and why we are using this one in sas?
Please write codes to merge two datasets and keep every record in the first dataset.
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
how to rearrange the data as our wish by using dataset block?
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.