topic Re: case statement with the values from another variables in the dataset after then in a proc sql in SAS Programming

case statement with the values from another variables in the dataset after then in a proc sql

GN0001 — Thu, 01 Jul 2021 03:46:27 GMT

Hello team,

How to point to another variable in a case statement in a proc sql?

I need to have some calculation after then instead of literal. Instead of something, I need to multiply the value of a variable in the table * by the value of another variable in the table. After then, it is a calculation of two values from two variables from same dataset.

Proc sql;
   create table junk as
   select *,
      case 
         when sex= 'F' then 'something'
         when sex= 'M' then 'something else'
         else 'Error'
      end as newvar label='This is a Sex based value'
   from sashelp.class
   ;
run;

Respectfully,

Blue blue

Re: case statement with the values from another variables in the dataset after then in a proc sql

Sajid01 — Thu, 01 Jul 2021 14:38:17 GMT

Can you elaborate please. Your question is not comprehensible.
Do refer to SAS documentation on Proc SQL some of your questions may be answered there.

Re: case statement with the values from another variables in the dataset after then in a proc sql

Tom — Thu, 01 Jul 2021 14:53:12 GMT

If you provide a more detailed example of what you are trying to do then you can get a better answer.

It sounds like you want something like this:

proc sql;
create table junk as
  select *
       , case 
           when sex= 'F' then weight*height
           when sex= 'M' then age
           else .
         end as newvar label='This is a Sex based value'
  from sashelp.class
;
quit;