how can you improve the performance of a query, If it is
excuting very slowly?
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 |
how we can create optional or required parameters in SAS macro...
What do the mod and int function do? : Sas programming
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
Can you execute a macro within a macro? Describe. : sas-macro
What is the order of evaluation of the comparison && logical && relational operators:?
how do u validate sas program
Explain the special input delimiters used in sas programming.
How many data types are there in SAS?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What are the features of base sas system?
What is the pound sign used for in the data_null_ ?