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.

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
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
  • 1091 views
  • 0 likes
  • 3 in conversation