How to rename a serial column names?

[ybz12003]

Good morning,

I have 32 column (variables) names from 'bd_dx_1' to 'bd_dx_32'.   I would like to rename them from 'nad_dx_1' to 'nad_dx_32', individually. Please help.  Thanks.

[RW9 · Accepted solution]

Well, arrays is one option:

data want (drop=bd_dx_:);
  set have;
  array bd_dx_{32};
  array nad_dx_{32} $100;   /* assume character as you have not said */
  do i=1 to 32;
    nad_dx_{i}=bd_dx_{i};
  end;
run;

I suppose the big question is, is there any benefit, if they were meant to be called that originally, why not change there?

[Haikuo]

Rename statement or Rename data set option supports batch renaming of your kind:

data want;
set have;
rename bd_dx_1-bd_dx_32=nad_dx_1-nad_dx_32;
run;

[ybz12003]

Thanks for all your kind help.