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 |
What is LOGICAL VARIABLES in SAS.And how it can be used..Can anyone support..???
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
Have you used macros? For what purpose you have used? : sas-macro
what is factor analysis? : Sas-administrator
What is interleaving in SAS?
is data integration and etl programming is same? : Sas-di
What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
What commands are used in the case of including or excluding any specific variables in the data set?
How to save the log information in a file for future use
What is the Program Data Vector (PDV) and What are its functions?