topic rename error in SAS Programming

rename error

debabrata — Tue, 25 Apr 2017 17:45:15 GMT

i am trying to rename two variables with different names as same new name

for ex:

rename A as x and rename B as X in same data set.

i m performing concatenationof 2 data set using "set" and trying to rename the variables A, B as X(original name in one data set);

i am writing code as:

Set red red2 (rename=(A = x));....working

Set red red2 (rename=(A=x B=x));......not working.

any suggestion.

gauthamk28 — Tue, 25 Apr 2017 18:03:54 GMT

Is the variable A from red and B from red 2 dataset???

thomp7050 — Tue, 25 Apr 2017 18:07:03 GMT

proc sql;
create table mytable as
select var1 as myvar1, var2 as myvar2, var3 as myvar3
from red
union all
select var1, var2, var3 from red2;
quit;

Astounding — Tue, 25 Apr 2017 18:14:00 GMT

Each data set named can have its own data set options. So this might be what you are looking for:

set red (rename=(b=X)) red2 (rename=(a=X));

If this is the right idea, it would be a requirement that A and B are the same type (either both numeric, or both character).

Tom — Tue, 25 Apr 2017 18:46:58 GMT

Sounds like you want to tranpose the data to convert two columns into two rows.

But for this simple example just set the original dataset twice.

data want ;
  set have (keep=A rename=(A=X)) have (keep=B rename=(B=X)) ;
run;

So if you had:

You would get

thomp7050 — Tue, 25 Apr 2017 19:06:37 GMT

Lots of good responses here. Nice to see some interesting ideas for the same problem!

debabrata — Wed, 26 Apr 2017 07:24:29 GMT

A an B are in same data set red2.

X is dataset red

debabrata — Wed, 26 Apr 2017 07:27:56 GMT

both A and B belong to same dataset red2....where as X belong to red.

red red2

X A B

red

debabrata — Wed, 26 Apr 2017 07:46:02 GMT

thanxs.. i got it using your way.

but i lost other variables in have.

how can i retain other variables???