SQL: Is it possible to replace values in an existing variable and rename it to the same name in the same SELECT statement?

Question

I am wondering if it is possible to replace values in an existing variable in the same SELECT statement in SQL.

create table temp as
     select ID
            , DOB 
            , AGE
            , DISEASE_INDICATOR
            , case when DISEASE_INDICATOR = 'Y' then 1 else 0
            end as DISEASE_INDICATOR
     from my_table;
quit;

The error message I get is: "WARNING: Variable DISEASE_INDICATOR already exists on file WORK.TEMP"

Thanks in advance!

score 0 · Accepted Answer · answered Apr 23 '21 at 19:17

Just remove the previous column:

create table temp as
     select ID, DOB, AGE,
            (case when DISEASE_INDICATOR = 'Y' then 1 else 0 end) as DISEASE_INDICATOR
     from my_table;
quit;

Or give the columns different names:

create table temp as
     select ID, DOB, AGE,
            DISEASE_INDICATOR as DISEASE_INDICATOR_YN,
            (case when DISEASE_INDICATOR = 'Y' then 1 else 0 end) as DISEASE_INDICATOR_01
     from my_table;
quit;

SQL: Is it possible to replace values in an existing variable and rename it to the same name in the same SELECT statement?

1 Answers1