replace the old variable with new variable in proc sql

[deleted_user]

I would like to replace variable X with the new value that came from case select statement.

SAS give me the WARNING (below) and it keep the old variable instead of giving me the new variable , can anyone please let me know how can I replace the new value to the same variable "X" ?

--------------------------------------------------------------------------------------------------
WARNING: Variable is_react already exists on file T2
--------------------------------------------------------------------------------------------------
proc sql;

create table T2 as select

case when x = 'no' then 'newVar1'
else 'newVar2' end as x

from T1; quit;

---------------------------------------------------------------------------------------------------
Thank you,
Jeannie

[SASPhile]

it worked ok for me:


data t1;
input x $1-5;
datalines;
no
yes
no
yes
;
run;

proc sql;

create table T2 as select

case when x = 'no' then 'newVar1'
else 'newVar2' end as x

from T1; quit;

[deleted_user]

I finally figured it out, I was actually had

select * prior the case when statement , so when I was trying to replace the old variable it gave me the warning, so what I did was putting the case when before the * ..

and it worked just fine.

Thanks a lot!!