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
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What are the 3 components in sas programming?
what is treatment emergent events and treatment emregent adverse event
What are the difference between the sas data step and sas procs?
What are the prime responsibilities of data integration administrator? : Sas-di
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
Name some categories in sas 9? : sas-grid-administration
Explain what is the use of proc gplot?
Give some examples where proc report’s defaults are same as proc print’s defaults?
what does the run statement do? : Sas programming
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
why is a stop statement needed for the point=option on a set statement? : Sas programming
Can you execute macro within another macro? : sas-macro
what is sas business intelligence? : Sas-bi
explain what is factor analysis? : Sas-administrator
