Answer Posted / 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;

What is the maximum length of the macro variable? : sas-macro

1066

---

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1029

---

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

2212

---

What is SAS?

1010

---

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

1056

---

How to convert a numeric variable to a character variable?

1157

---

Explain data_null_?

1015

---

What is the use of divide function?

1028

---

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1643

---

what are _numeric_ and _character_ and what do they do? : Sas programming

1126

---

what are the best practices to process the large data sets in sas programming? : Sas-administrator

982

---

What are types of transport files?

7922

---

What do the mod and int function do? : Sas programming

1159

---

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1205

---

what is data integration? : Sas-di

1080

---