BookmarkSubscribeRSS Feed
mpoletika1
Calcite | Level 5

Hello,

 

I am trying to run the following code, but return missing values for all records for the new variable "denom_code32." For some reason, the "and" operator doesn't turn blue. Any ideas of what's going on?

 

Thanks,

 

Mike

 

data new;
set input;
if leave_code = '32' and verified_transfer = "yes" then denom_code32 = 1;
else denom_code32 = 0;
run;

2 REPLIES 2
Reeza
Super User
The IDE is bad. It doesn't always colour code things correctly.If it runs correctly, you're fine.
Astounding
PROC Star

You're right ... this code should never return a missing value.  You will need to post the log if you want anybody to be able to help you.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 618 views
  • 0 likes
  • 3 in conversation