create Index for Table2 by using ROLL Number in the Data step ? Is it possible ?

[sambasiva_ravuri_tcs_com]

Dear All,

I would like to create Index for Table2 by using Rollnumber in the Data step ? Is it possible ?

Table2:

Rollnumber	Dob	Salary	experience
1	11/12/87	2500	2
5	12/04/56	3400	3
3	03/06/79	1200	4
2	04/05/94	44560	4
4	03/07/99	12908	3
6	03/07/99	12908	7

Thanks a lot in advance for help.

Regards,

S Ravuri.

[LinusH]

Yes, there is a data step option that will create indexes upon table creation.

If the table already exist (and you don't want recreate it), use either Proc Datasets, or SQL.