SAS Index

[omkar]

1. I have a simple index defined on var1 in sas data set : one

2. when appending the data to the sas dataset in step1 with the new data set for ex: two the index that is already defined for the dataset one is lost.

please see the below code.

data class(index=(name/unique));    /* index created on name in the work.class*/
set sashelp.class;
run;

proc contents data=class;
quit;

data class1;  /* index is not there  in the work.class1*/
set class (where= (name = 'Alfred'));
run;

proc contents data=class1;
run;

data class;
set class class1 ;
run;

proc contents data=class; /* index is lost in work.class*/
quit;

kindly let me if I am doing some thing wrong.

[Reeza]

Yes, since you’re creating a new data set. It happens to have the same name but that’s coincidental - and bad practice IMO. 

Try PROC APPEND or DATASETS