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


Please Help Members By Posting Answers For Below Questions

How long can a macro variable be? A token? : sas-macro

971


What versions of SAS have you used (on which platforms)?

1275


what is SAS OPTIMIZATION?

2056


How to read an input file in sas?

930


What are all the problems you faced while validating tables and reports?

3254


what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

953


what are the categories that sas informats are used to the place the data? : Sas-administrator

821


Describe 5 ways to do a “table lookup” in SAS?

896


what is sas data set?

881


How can you create a macro variable with in data step? : sas-macro

797


Explain the special input delimiters used in sas programming.

804


How necessary is it to be creative in your work?

2239


What is connection profile? : sas-grid-administration

926


What is the function of Stop statement in a SAS Program?

912


what is the effect of the options statement errors=1? : Sas programming

836