topic Re: Where condition in datastep in SAS Programming

Where condition in datastep

nxmogil — Mon, 15 May 2023 08:23:16 GMT

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

Re: Where condition in datastep

Kurt_Bremser — Mon, 15 May 2023 08:49:26 GMT

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.

Re: Where condition in datastep

JosvanderVelden — Mon, 15 May 2023 09:17:17 GMT

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;

Re: Where condition in datastep

nxmogil — Mon, 15 May 2023 14:01:02 GMT

Thank you