topic Re: if then else clause problem in SAS Programming

if then else clause problem

ResoluteCarbon — Thu, 18 Feb 2021 12:06:51 GMT

Hi all,

I am new to SAS, I have a question about if then else clause.

I have a variable name s26. I want to set up if s26 is higher than 0 and s26 ne. then fcf=1

If s26 is lower than 0 and s26 ne. then fcf=0.

Could you please suggest to me how to code it?

Re: if then else clause problem

PaigeMiller — Thu, 18 Feb 2021 12:30:02 GMT

@ResoluteCarbon wrote:

Hi all,

I am new to SAS, I have a question about if then else clause.

I have a variable name s26. I want to set up if s26 is higher than 0 and s26 ne. then fcf=1

If s26 is lower than 0 and s26 ne. then fcf=0.

Could you please suggest to me how to code it?

The code is essentially what you wrote, except you use > or < symbols

if s26 > 0 and s26 ne . then fcf=1;
else if s26 < 0 and s26 ne . then fcf=0;

A simplification because if s26 > 0 then it has to be not equal to missing

if s26 > 0 then fcf=1;
else if s26 < 0 and s26 ne . then fcf=0;

Re: if then else clause problem

Amir — Thu, 18 Feb 2021 12:30:53 GMT

Hi @ResoluteCarbon ,

Further to what @PaigeMiller has said, I recommend you also consider what the logic should do if s26 = 0, for example, flag an error condition or include this possibility in one of the branches of the if statement.

Kind regards,

Amir.

Re: if then else clause problem

Phil_NZ — Thu, 18 Feb 2021 19:40:05 GMT

Hi @PaigeMiller

It looks like that we do not need the condition s26=. at the code

if s26 > 0 and s26 ne . then fcf=1;

because . is the smallest obs in the dataset, isn't it ?