topic If then else syntax in SAS Programming

If then else syntax

leahcho — Wed, 15 Nov 2017 03:14:05 GMT

Hi ,

I wrote the following code;

data want;

set have;

if apple=1 and peach=0 then fruit=1;

else if apple=1 and peach=1 then fruit=2;

run;

Then when I ran proc freq, all my observations were fruit=1

And I know there are apple=1 and peach=1 in the dataset. Is the syntax wrong in my code?

Thanks

Re: If then else syntax

Tom — Wed, 15 Nov 2017 03:23:45 GMT

Post the LOG of the step.

Perhaps your data step failed for some other reason.

Perhaps you analyzed some other dataset.

Make sure the values of the variables are actually integers. Perhaps you have a values like 0.99999999999 that will print as 1 in most cases, but will not test as being equal to 1.