topic How to multiply the result of a case statement which is labeled as literal by a number in SAS Programming

How to multiply the result of a case statement which is labeled as literal by a number

GN0001 — Thu, 01 Jul 2021 16:03:02 GMT

Proc sql;
create table mytable as
select distinct b.this
, case 
when b.rate < 0.35 then '35th'
when b.rate < 0.45 then '55th'
end as 'current rate'n
, case
when b.rate < 0.35 then '45th'
when b.rate < 0.45 then '65th'
end as 'next rate'n
, case
when b.rate <.35 then (b.rate * 'next rate'n)
when b.rate <0.45 then (b.rate * 'next rate'n)
end as 'final'
from tableb b Left Join tablea a

regards,

blue blue

Re: How to multiply the result of a case statement which is labeled as literal by a number

Tom — Thu, 01 Jul 2021 16:10:17 GMT

Is there a question in there somewhere?

Are you looking for the CALCULATED keyword?

select amount
        , sum(amount) as total
         , amount / calculated total as percent
from have
;

Re: How to multiply the result of a case statement which is labeled as literal by a number

GN0001 — Thu, 01 Jul 2021 17:35:38 GMT

Hello Tom,

I put a case statement in the code to calculate something. I found the answer while I was typing the question.

That was to multiply the label that is create for a case statement with a number. Since the label is a literal, I didn't know how to multiply by a text. I found the solution by mysel.

Thanks for the response.

Blue blue