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 the difference between %local and %global? : sas-macro
What is run-group processing?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
Explain the purpose of substr functions in sas programming.
In sas admin differentiate between roles and capabilities? : sas-grid-administration
what is the difference between infile and input? : Sas-administrator
How can you create a macro variable with in data step? : sas-macro
In SAS explain which statement does not perform automatic conversions in comparisons?
Differentiate between proc means and proc summary.
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
What system options would you use to help debug a macro? : sas-macro
how do you debug and test your sas programs? : Sas programming
What does the trace option do?
How can I remove header from output data set?
how does sas handle missing values in formats? : Sas programming