Help need in data step code

[knveraraju91]

Dear,

 I come across a data step with where statement in set statement. The output in dataset two should have only one obs. But it has two obs. Why where statement is not working as "IF" statement . Thank you

data one;
length ONE $10;
input ONE $ TWO;
datalines;
Completed  1
un 2
;
data two;
set one(where=(upcase(one)^='Completed'));
run;

[novinosrin]

Correction:

data one;
length ONE $10;
input ONE $ TWO;
datalines;
Completed  1
un 2
;
data two;
set one(where=(upcase(one)^='COMPLETED'));
run;

/*or*/

data one;
length ONE $10;
input ONE $ TWO;
datalines;
Completed 1
un 2
;
data two;
set one(where=((one)^='Completed'));
run;

[Reeza]

set one(where=(upcase(one)^='Completed'));

You upcased the variable but didn't upcase the word 'completed'.