Interested to Buy Any Domain ? << Click Here >> for more details...
what is the need of INDEX in datasets?
- 6 Answers
- 13809 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / abhilash
by using index we search a particular string or sub string
it returns the position where the sub string is located
for ex:
data index;
name="india is greatest country";
idx-index(name,"great");
run;
it returns the great sub string position(10)
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / guest
Generally SAS reads The obseravtions in sequentiall manner.
it takes a lot of time .to aviod this we are using index.
ithis index concept usefull when we dealing with large
datsets.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / hari
This is mainly useful for the fast retrival of data (For ex
we have 559 in 1 lac obs then by index we can get the data
with out reading all the observations
Index are 2 type:
1.simple
2.Composite
ex-for simple
proc datasets lib=college;
modify time;
index create class;
run;
ex-for composite:
proc datasets library=college;
modify time;
index create names(=(name school);
run;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sushil kumar
Index Function is used to search a Character in a String and returns position of the String
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dvsr
Without index if we executed the query it will go to the
full table scan. If any data set or table has the index
first query checks that particular If condition or where
condition in that column then it will go to the remaining
columns.
| Is This Answer Correct ? | 1 Yes | 1 No |
Mention the difference between ceil and floor functions in sas?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
Which function is used to count the number of intervals between two sas dates?
how to intersect the tables by using PROC MIXED?
Describe crosslist option in tables statement?
what is p-value
3 Answers Accenture, Quintiles, Sristek,
what is conditional processing?
what are different analysis datasets you created and what are the new variables created
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record
how to import XTP files into SAS datasets?
1 Answers Barclays, Institute For Plasma Research,
What are the data types in sas?
Teradata 
