topic Rename an array of var names after a "Wide to Long" transpose in SAS Procedures

Rename an array of var names after a "Wide to Long" transpose

Nikos — Thu, 15 Mar 2012 15:46:29 GMT

Hi,

I am trying to transpose a data set from "Wide to Long".

The numeric variables (to be transposed based on a BY variable group) in the initial WIDE dataset have names F2,F3,F4,.....F20

After the transposition, in the new _NAME_ variable I would like to have the above names RENAMED as follows

...

228

(i.e. starting F2=12 F3=24 ...F20= 228 - incrementing by 12)

Any suggestions would be more than welcomed.

Thank you

Nikos

Rename an array of var names after a "Wide to Long" transpose

Haikuo — Thu, 15 Mar 2012 15:57:15 GMT

Not sure if I understand what you asked for:

data have;

array ff f2-f20;

do _n_=1 by 1 to dim(ff);

ff(_n_)=12*_n_;

end;

run;

proc transpose data=have out=want (drop=_name_ rename=col1=_name_);

var f2-f20;

run;

proc print;run;

Regards,

Haikuo

Rename an array of var names after a "Wide to Long" transpose

PGStats — Thu, 15 Mar 2012 16:01:02 GMT

data want(drop=_NAME_);

set have;

newVar = 12*(input(substr(_NAME_,2),2.)-1);

run;

Re: Rename an array of var names after a "Wide to Long" transpose

Linlin — Thu, 15 Mar 2012 16:41:23 GMT

another way:

data have;

input f2-f20;

cards;

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

;

proc transpose out=temp;

var f:;

run;

data want (rename =v=_name_);

set temp;

v=(input(compress(_name_,'f','U'),2.)-1)*12;

drop _:;

proc print;run;

Obs COL1 _name_

1 2 12

2 3 24

3 4 36

4 5 48

5 6 60

6 7 72

7 8 84

8 9 96

9 10 108

10 11 120

11 12 132

12 13 144

13 14 156

14 15 168

15 16 180

16 17 192

17 18 204

18 19 216

19 20 228

Rename an array of var names after a "Wide to Long" transpose

Nikos — Wed, 21 Mar 2012 15:29:09 GMT

Hi,

I would like to thank you

Nikos