topic Re: append all column names of a dataset in SAS Programming

prefix all column names of a dataset

csetzkorn — Tue, 21 Feb 2017 21:19:52 GMT

Let us say I have a dataset with 2 columns: Col1 and Col2. Is it possibly to change all column names so that they start with X (Col1 => XCol1, Col2 => XCol2) without having to do this manually?

Re: append all column names of a dataset

gauthamk28 — Tue, 21 Feb 2017 21:22:01 GMT

I hope this will help u

http://support.sas.com/kb/48/674.html

Re: append all column names of a dataset

Reeza — Tue, 21 Feb 2017 21:20:01 GMT

Are your original variables sequentially named as in your example?

If yes, then you can use a rename

RENAME Col1-Col2 = Xcol1 - Xcol2;

Otherwise, use the SASHELP.VCOLUMN table to generate the rename statement dynamically.

Here's an example from a few days ago:

https://communities.sas.com/t5/Base-SAS-Programming/rename-variables/m-p/333964