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
what is transformation in sas data integration? : Sas-di
What are the data types that sas contain?
What can you learn from the SAS log when debugging?
What are the data types does SAS contain?
What is program data vector (pdv)?
For clinical entire study how many tables will create approx?
What is the difference between %local and %global? : sas-macro
Difference between SAS STATA & SPSS?
What is the use of the %include statement?
Mention what is the difference between nodupkey and nodup options?
what are several options for creating reports in web report studio? : Sas-bi
Where do you use proc means over proc freq?
Explain data_null_?
what are informats in sas? : Sas-administrator
how to generate the test data in sas without input data? : Sas-administrator
