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
How long can a macro variable be? A token? : sas-macro
What versions of SAS have you used (on which platforms)?
what is SAS OPTIMIZATION?
How to read an input file in sas?
What are all the problems you faced while validating tables and reports?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
what are the categories that sas informats are used to the place the data? : Sas-administrator
Describe 5 ways to do a “table lookup” in SAS?
what is sas data set?
How can you create a macro variable with in data step? : sas-macro
Explain the special input delimiters used in sas programming.
How necessary is it to be creative in your work?
What is connection profile? : sas-grid-administration
What is the function of Stop statement in a SAS Program?
what is the effect of the options statement errors=1? : Sas programming