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.

What does PROC print, and PROC contents do?

1236

---

name several ways to achieve efficiency in your program? : Sas programming

1070

---

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1050

---

for what purpose would you use the retain statement? : Sas programming

1096

---

If a variable contains only numbers, can it be a character data type?

1085

---

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1162

---

what is treatment emergent events and treatment emregent adverse event

2407

---

What is the function of output statement in a SAS Program?

1074

---

what is the effect of the options statement errors=1? : Sas programming

1060

---

What is the difference between class statement and by statement in proc means?

1299

---

What are the ways in which macro variables can be created in sas programming?

1103

---

Difference between sum function and using “+” operator?

1151

---

Differentiate between sas functions and sas procedures.

1242

---

What is the difference between INPUT and INFILE ?

1321

---

for whom is sas data integration studio designed? : Sas-di

1004

---