how can you improve the performance of a query, If it is
excuting very slowly?
- 2 Answers
- 6102 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 |
What does a PROC TRANSPOSE do?
What is the use of divide function?
What are the default statistics that proc means produce?
what type of graphs we will create(for 2+years candidates)?
What do the put and input function do?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
How would you include common or reuse to be processed along with your statements?
"What is the difference between proc sort nodup and proc sort nodupkey?"
what is the difference between proc report and proc format?
Have you ever used the SAS Debugger?
What are the data types does SAS contain?
What was the last computer book you purchased? Why?
Teradata 
