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.
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?
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?
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;
Thanks for all your kind help.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.