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 is the difference between one to one merge and match merge? Give an example.

1059

---

How many ways to overcome a missing values???

2805

---

AE datasets names? how many types?

2493

---

what is sas metadata repository? : Sas-bi

1111

---

Describe 5 ways to do a “table lookup” in SAS?

1146

---

I need level 2 to 5 sas using companies in india

2377

---

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1614

---

what are informats in sas? : Sas-administrator

1084

---

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1358

---

how can you create zero observation dataset? : Sas programming

1139

---

Name some categories in sas 9? : sas-grid-administration

967

---

Explain how you can debug and test your SAS program?

1005

---

What are the functions which are used for character handling functions?

1136

---

What do you understand by the term Normal Distribution?

979

---

how does sas handle missing values in sort order? : Sas programming

911

---