topic Re: How to rename a serial column names? in SAS Programming

How to rename a serial column names?

ybz12003 — Thu, 08 Jun 2017 13:56:34 GMT

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.

Re: How to rename a serial column names?

RW9 — Thu, 08 Jun 2017 13:57:07 GMT

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?

Re: How to rename a serial column names?

Haikuo — Thu, 08 Jun 2017 14:03:31 GMT

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;

Re: How to rename a serial column names?

ybz12003 — Thu, 08 Jun 2017 15:22:53 GMT

Thanks for all your kind help.