Where condition in datastep

[nxmogil]

I am running a code like this 

data test test1;

set sample;

if id in ("10") and code in ("26", "260", "8") then do;

check = yes;

output test;

run;

This is fetching records for (10, 260) but not for (10, 26) and (10,  8 )

please suggest

[Kurt_Bremser]

If the values are right-aligned in the character variable, use the LEFT or STRIP functions to get rid of the leading blanks. Or include the leading blanks in your values in the IN list.

[JosvanderVelden · Accepted solution]

Please look at the following example:

data have;
   input id $ code $;
datalines;
10 26
10 260
10 8
1 2
;
run;

data want want_all;
set have;
if id in ("10") and code in ("26", "260", "8") then do;
	check = 'yes';
	output want;
end;
output want_all;
run;

[nxmogil]

Thank you