topic Re: Help need in data step code in SAS Programming

Help need in data step code

knveraraju91 — Fri, 01 Jun 2018 20:36:30 GMT

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;

Re: Help need in data step code

novinosrin — Fri, 01 Jun 2018 20:40:31 GMT

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;

Re: Help need in data step code

Reeza — Fri, 01 Jun 2018 20:42:02 GMT

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

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