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.