How to add a variable to a table in proc SQL

[GN0001]

Hello team,

I code as follows:

if member_ID in ('k') then tempbucket = 'Health plan v';

Proc sql;

create table mydata as

select distinct a.member_ID

from tablec a;

quit;

Now I want to add this tempbucket to my table.

Can you please let know how?

I have searched a lot!

Regards,

Blue Blue

How can I do that?

[SASKiwi]

In SQL the CASE statement can do similar logic:

Proc sql;
create table mydata as
select distinct a.member_ID
      ,case
        when a.member_ID in ('k') then 'Health plan v'
       else ''
      end as tempbucket
from tablec a;
quit;

[GN0001 · Accepted solution]

Thanks for the response. 

Let me try it tomorrow and I will get back to you:

Does this add a new variable? Or test different cases? Anyway, case statement can solve my situation.

If it is not "k only" it is "k" or "n", then what happens? I mean to use "or" with "in".

Can we bring our new variable after the word "case"?

Proc sql;
create table mydata as
select distinct a.member_ID
      ,case
        when a.member_ID in ('k') then 'Health plan v'
       else ''
      end as tempbucket
from tablec a;
quit;

Regards,

Blue, Blue

[SASKiwi]

Please read the documentation and try running the code. If it is still not clear then ask further questions.

[GN0001]

This response saved me. Thanks 🙏
Blue blue