topic Re: data step in SAS Programming

data step and where logic

HeatherNewton — Tue, 08 Mar 2022 10:21:06 GMT

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

Re: data step

PeterClemmensen — Tue, 08 Mar 2022 09:00:53 GMT

~= means Not Equal To .

Re: data step

HeatherNewton — Tue, 08 Mar 2022 09:29:43 GMT

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?

Re: data step

LinusH — Tue, 08 Mar 2022 10:07:05 GMT

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.

Re: data step

LinusH — Tue, 08 Mar 2022 10:07:19 GMT

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.

Re: data step

andreas_lds — Tue, 08 Mar 2022 10:10:18 GMT

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.