topic replace the old variable with new variable in proc sql in SAS Programming

replace the old variable with new variable in proc sql

deleted_user — Tue, 02 Nov 2010 18:05:22 GMT

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

Re: replace the old variable with new variable in proc sql

SASPhile — Tue, 02 Nov 2010 18:48:52 GMT

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;

Re: replace the old variable with new variable in proc sql

deleted_user — Tue, 02 Nov 2010 20:20:06 GMT

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!!