BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
wlf211
Calcite | Level 5

Hi,

I am trying to get a complicated %IF condition statement to work within my macro loop. I have been able to do this in the past with floating point comparisons using %SYSEVALF, but no matter what I do it keeps evaluating as FALSE even though the variables should make it TRUE.

Here is my LOG output for the condtion in question:

SYMBOLGEN:  Macro variable CURSTG resolves to 3
SYMBOLGEN:  Macro variable DISCELIGSTRAD resolves to 121.26

SYMBOLGEN:  Macro variable EDGECOND resolves to 121.26

SYMBOLGEN:  Macro variable DISCELIGFULL resolves to 184.7

SYMBOLGEN:  Macro variable DSCTROPORTION resolves to 0.975

SYMBOLGEN:  Macro variable EDGECOND resolves to 121.26

MLOGIC(STAGE):  %IF condition &curstg eq 3 and %sysevalf(&disceligstrad = &edgecond) and %sysevalf(&disceligfull <=

((1/&dsctroportion)*&edgecond)) is FALSE

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

%sysevalf((1/&dsctroportion)*&edgecond)) resolves to 124.36923076923 when I calculate it. So the last condition is false.

View solution in original post

2 REPLIES 2
ballardw
Super User

%sysevalf((1/&dsctroportion)*&edgecond)) resolves to 124.36923076923 when I calculate it. So the last condition is false.

wlf211
Calcite | Level 5

Thanks,

It should be >= not <=, I must have switched the signs as I was rewriting it (I originally had "ge", then switched it to "<="). It works now.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1426 views
  • 0 likes
  • 2 in conversation