DATA Step, Macro, Functions and more

Help need in data step code

Reply
Super Contributor
Posts: 312

Help need in data step code

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;
PROC Star
Posts: 1,584

Re: Help need in data step code

[ Edited ]
Posted in reply to knveraraju91

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;
Super User
Posts: 23,296

Re: Help need in data step code

Posted in reply to knveraraju91
set one(where=(upcase(one)^='Completed'));

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

Ask a Question
Discussion stats
  • 2 replies
  • 89 views
  • 2 likes
  • 3 in conversation