topic Re: IF Statement in SAS Programming

IF Statement

anonymous_user — Thu, 22 Jan 2015 11:53:26 GMT

Hi,

I need a statement to show

if balance is a minus number then 0.

How is this written please?

Re: IF Statement

RW9 — Thu, 22 Jan 2015 11:59:36 GMT

Hi,

data want;

set have;

if value < 0 then result=0;

else result=1;

run;

result is 0 for minus numbers, 1 otherwise.

Re: IF Statement

anonymous_user — Thu, 22 Jan 2015 12:01:51 GMT

Hi RW9,

Sorry, can i have this in proc sql please?

Re: IF Statement

Loko — Thu, 22 Jan 2015 12:13:16 GMT

Hello,

PROC SQL;

select *,

case when age-13 lt 0 then 0

else age-13

end as age_diff from sashelp.class;

quit;

Re: IF Statement

RW9 — Thu, 22 Jan 2015 13:17:26 GMT

Replace if /then with case/when

case when <condition> then <result> else <default option> end as variable

Can also be

case <variable> when <condition> then <result> else <default option> end

E.g.

case when variable < 0 then 0 else 1 as result

Re: IF Statement

ballardw — Thu, 22 Jan 2015 16:46:23 GMT

Another approach is to not change the value just how it displays with a custom format:

proc format;

value myneg

low - 0 = 0

other = [best8.]

;

And in any display use that format by adding

Format var myneg. ;

Re: IF Statement

MikeZdeb — Fri, 23 Jan 2015 02:43:47 GMT

Hi ... another way in SQL ...

data old;

input balance @@;

datalines;

-1 20 56 -99 . 80 100 -0.123

;

proc sql;

select *, balance - (balance lt 0) * balance as new from old;

quit;

balance new

---------------------------------

-1 0

20 20

56 56

-99 0

. .

80 80

100 100

-0.123 0

though if it's just display that's important, the suggestion about using a FORMAT is probably better