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-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register 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
  • 846 views
  • 0 likes
  • 3 in conversation