SAS Index

omkar — Thu, 05 Oct 2017 21:04:17 GMT

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.

Re: SAS Index

Reeza — Thu, 05 Oct 2017 21:20:20 GMT

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

topic SAS Index in SAS Programming

SAS Index

Re: SAS Index