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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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