topic Re: How to add a variable to a table in proc SQL in SAS Programming

How to add a variable to a table in proc SQL

GN0001 — Tue, 22 Jun 2021 03:52:09 GMT

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?

Re: How to add a variable to a table in proc SQL

SASKiwi — Tue, 22 Jun 2021 04:42:03 GMT

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;

Re: How to add a variable to a table in proc SQL

GN0001 — Tue, 22 Jun 2021 04:53:36 GMT

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

Re: How to add a variable to a table in proc SQL

SASKiwi — Tue, 22 Jun 2021 05:08:15 GMT

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

Re: How to add a variable to a table in proc SQL

GN0001 — Wed, 23 Jun 2021 01:33:10 GMT

This response saved me. Thanks 🙏
Blue blue