Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / aravind9882
index is separate file attached to dataset.
create index on variable that is used in 'by processing'
or 'where processing'.
it will enhance the performance and fast retrieving the
observations when you use indexed variable in where
statement.
you need not to sort the variable if it is indexed when u
use it in "by statement".
create an index on variable when:
-u have to retrieve observations not more than 15% of d
dataset.
-create index on variable where 'by-variable' will have
more than 8 disctint values.
index is of two types:
simple index-created on single variable.
composite index-created on 2 or more variables.
index can b created using proc datasets, proc sql and
datastep.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How can you create a macro variable with in data step? : sas-macro
Explain what is data step?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
Explain how you can debug and test your SAS program?
What does the RUN statement do?
what has been your most common programming mistake? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?
what is snowflake schema? : Sas-di
What are the five ways to do a table lookup in sas? : sas-grid-administration
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
Explain proc sort?
What are the default statistics that proc means produce?
What are the 3 components in sas programming?
Explain the purpose of substr functions in sas programming.
What is maximum number of rows and cols can be handled in SAS?
