topic Updating Existing Index in SAS Programming

Updating Existing Index

A_SAS_Man — Tue, 23 Apr 2019 13:03:57 GMT

We have a large data set that we are maintaining on a monthly basis. In order to make it more efficient for people on our team to use we are attempting to index it on a few different variables, which initially took quite a long time. I'm wondering if there is a way to update an existing index rather than re-indexing the entire data set every time we append to the data? My thinking is that if we are able to just take the new values in the set and add those to the index we could save significantly on time, but I'm not sure if the syntax exists to do that. I am creating my index with the below code.

data test2 (index=(c1
c2
c3
c4
c5
c6));
set test;
run;

Re: Updating Existing Index

PeterClemmensen — Tue, 23 Apr 2019 13:18:35 GMT

No need to create the entire index again. Use PROC DATASETS like this

proc datasets lib=mylib;
   modify test2;
      index centiles c1/ refresh;
run;quit;

Re: Updating Existing Index

PeterClemmensen — Tue, 23 Apr 2019 13:20:34 GMT

To be clear, to update all six indexes of interest, do this.

proc datasets lib=mylib;
   modify test2;
      index centiles c1/ refresh;
      index centiles c2/ refresh;
      index centiles c3/ refresh;
      index centiles c4/ refresh;
      index centiles c5/ refresh;
      index centiles c6/ refresh;
run;quit;