BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
fengyuwuzu
Pyrite | Level 9

In my data, some character variables were defined as numeric by mistake. 

In this case, if I want to search "Yes" or "No", it does not work. 

 

25 GOPTIONS ACCESSIBLE;
26 data test;
27 set db.ct_reading;
28 where qc_accepted = 'Yes';
ERROR: WHERE clause operator requires compatible variables.
29 run;

 

Capture.PNG

 

How to work around this situation? 

I also see some cases where character variable missing is "." and numeric variable missing is " ". 

How to condition on these mis-typed missing values?

1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26

These numeric variables are formatted to show "yes" or "no"

 

You have to search for the numeric values, such as (this is often the case, but not always) 1 for yes and 0 for no. 

 

Or you could remove the format, and then you can see in the view which values they have.

--
Paige Miller

View solution in original post

2 REPLIES 2
PaigeMiller
Diamond | Level 26

These numeric variables are formatted to show "yes" or "no"

 

You have to search for the numeric values, such as (this is often the case, but not always) 1 for yes and 0 for no. 

 

Or you could remove the format, and then you can see in the view which values they have.

--
Paige Miller
fengyuwuzu
Pyrite | Level 9

yes, I used 1 for yes and it works. 

 

I will also try removing format. 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 2 replies
  • 1348 views
  • 0 likes
  • 2 in conversation