topic Re: If condition in SAS Programming

If condition

yael — Sun, 21 May 2017 07:22:11 GMT

Hello

It looks easy and i still do not know what is my mistake.

I want to create a new variable named FFOM. This variable will get value if founder (dummy variable 1/0) or secthird (dummy variable 1/0) is 1 and FOWNFF (countinous variable) >0.

This is my code:

data Y210517; set sasuser.y2;
ffom = if founder eq 1 or secthird eq 1 and fownff gt 0 then fownff;
run;

The log I got is:

Thanks for any clue...

Re: If condition

Reeza — Sun, 21 May 2017 08:00:10 GMT

Are you mixing up CASE and IF statements?

If youre assigning variables using THEN put the assignment at the end rather than at the beginning.

If <condition> then ffom = downfall;

Else ffom = other variable;

Re: If condition

MikeZdeb — Mon, 22 May 2017 21:11:00 GMT

Hi, another idea ...

data y2;
input founder secthird fownff @@;
datalines;
0 0 0 1 0 0 1 1 0 0 0 9 1 0 9 1 1 9
;

data y210517;

set y2;
ffom = (founder | secthird) * fownff;
run;

DATA SET: y210517

founder secthird fownff ffom

0 0 0 0
1 0 0 0
1 1 0 0
0 0 9 0
1 0 9 9
1 1 9 9

Re: If condition

fy1 — Wed, 05 Jul 2017 21:30:53 GMT

Mike's idea is logically clear.

or similar one like following in SAS. your statement is actually ambiguous.

_ffom = (founder eq 1 or secthird eq 1 and fownff gt 0 );

ffom=_ffom*fownff;

simple is best.

cheers.