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

For the SaS Practice Exam for the  A00-231 exam, one of the questions involves only taking values of a group equal to A or B. When I use WHERE group in ('A','B');, it gives me 4897 rows. The correct answer, which uses IF group in ('A','B'), gives 4992 rows. I'm not sure why there is a discrepancy here, I figures they should do the same thing.

 

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

Where would apply  to the values as read from data on the SET statement.

 

IF any of the values of the variable are changed, such as changing a lower case 'a' to 'A' the Where would have been applied before the change. An IF statement appearing after a change to the variable would use the new value of the variable for selection.

View solution in original post

1 REPLY 1
ballardw
Super User

Where would apply  to the values as read from data on the SET statement.

 

IF any of the values of the variable are changed, such as changing a lower case 'a' to 'A' the Where would have been applied before the change. An IF statement appearing after a change to the variable would use the new value of the variable for selection.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1 reply
  • 886 views
  • 0 likes
  • 2 in conversation