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
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Describe the ways in which you can create macro variables? : sas-macro
This entry was posted in General. Bookmark the permalink. Post a comment or leave
Mention few capabilities of sas framework.
What is SAS informats?
How to create a permanent sas data set?
what are input dataset and output dataset options? : Sas programming
State the difference between INFORMAT and FORMAT ?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
What are the different servers in sas? : sas-grid-administration
What is the work of tranwrd function?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
Describe crosslist option in tables statement?
What is a pdv and what are its functions?
