how can you improve the performance of a query, If it is
excuting very slowly?
Answer Posted / 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 |
Post New Answer View All Answers
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
what is proc Index? and what is proc document?
how many types prompting framework can be broken down to? : Sas-bi
What Proc glm does?
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?
Tell e how how dealt with..
What is the function of output statement in a SAS Program?
I need level 2 to 5 sas using companies in india
Give e an example of..
Explain the purpose of retain statement.
What are the ways to do a “table lookup” in sas?
explain about various caches available in data integrator? : Sas-di
What is the difference between one to one merge and match merge? Give an example.
Name few SAS functions?
What do the PUT and INPUT functions do?