topic Re: Subsetting by if in SAS Programming

Subsetting by if

mona4u — Wed, 06 Jun 2018 16:51:54 GMT

Hi,

I'm trying to subset the observations that match the criteria

by if statement but my code below doesn't work

I know I can do it by where statement but I also want to do it by if

data new; 
set have; 
if subject_id ne "%999%";
run;

sample of the data

Kurt_Bremser — Wed, 06 Jun 2018 16:52:44 GMT

Use

if index(subject_id,"999") = 0;

Reeza — Wed, 06 Jun 2018 16:53:46 GMT

% is a wildcard in the WHERE statement with the LIKE operator, not an IF statement.

WHERE statements allow SQL functions, IF statements do not.

where subject_id like '%999%';

The equiavelnt IF statement would be to use FIND() or INDEX() to search for that string.

if find('999', employee_id) > 0 ;