Interested to Buy Any Domain ? << Click Here >> for more details...
how can you improve the performance of a query, If it is
excuting very slowly?
- 2 Answers
- 7191 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / dvsr
If you are execution query on large SAS data sets before
executing the query COMPRESS the data sets by using
sas “compress” option and create the indexes on the most
frequently using variables in the data set
Feel free To add more ….:)
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / himanshu
by creating the Cubes, We can improve the performance of
the query.
| Is This Answer Correct ? | 0 Yes | 1 No |
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.
explain the proc in sas? : Sas-administrator
How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
what is SAS/Access and SAS/Connect?what are the uses?
how does sas handle missing values in formats? : Sas programming
why is a stop statement needed for the point=option on a set statement? : Sas programming
what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?
Are you familiar with special input delimiters? How are they used?
How would you identify a macro variable?
name several ways to achieve efficiency in your program? : Sas programming
what is sas? is a package or tool? give me introduction about sas?
Name and describe three SAS functions that you have used, if any?
Teradata 
