DATA Step, Macro, Functions and more

If then else syntax

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

If then else syntax

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

 


Accepted Solutions
Solution
Wednesday
Super User
Super User
Posts: 7,060

Re: If then else syntax

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.

 

View solution in original post


All Replies
Solution
Wednesday
Super User
Super User
Posts: 7,060

Re: If then else syntax

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.

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 77 views
  • 0 likes
  • 2 in conversation