DATA Step, Macro, Functions and more

replace the old variable with new variable in proc sql

Reply
N/A
Posts: 0

replace the old variable with new variable in proc sql

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
Super Contributor
Posts: 673

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

Posted in reply to deleted_user
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;
N/A
Posts: 0

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

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!!
Ask a Question
Discussion stats
  • 2 replies
  • 971 views
  • 0 likes
  • 2 in conversation