data step and where logic

[HeatherNewton]

data apple;
set lemon (in=1);
if a then country='MAC";
where samp ~=' ' and account ~= ' ' and index(applepie,'apple');
length score $20.;
score_type=40;
run;

hi can you explain the statement 'where samp....'

we are not too sure how the index statement is working here either.. thanks

[PeterClemmensen]

~= means Not Equal To .

[HeatherNewton]

yes we are aware of that, what we dont get is output of the index function, is it gonna be true or false?
also if the three conditions of where statement are all true, the line below where statement will run?
if where conditions not met, the line below where statement wont run?

[LinusH]

Yes, it will be evaluated for True or False. In SAS, anything else than 0 is considered True.

Where statement doesn't affect logic in your data step, it will filter data to be executed by the data step as a whole.

To control logic use the IF statement.

[LinusH]

Yes, it will be evaluated for True or False. In SAS, anything else than 0 is considered True.

Where statement doesn't affect logic in your data step, it will filter data to be executed by the data step as a whole.

To control logic use the IF statement.

[andreas_lds]

if where conditions not met, the line below where statement wont run?

Exactly and it doesn't matter where you have the where statement in the data step. So you should put the where statement directly after the set statement to avoid confusion.