Using WHERE or IF

souji — Mon, 06 Jan 2020 04:08:33 GMT

Hi,

In which instance , can use WHERE or IF, below two code give me different results?

Scenario is -Remove observations with RestHR values that are greater than or equal to 70

data work.stress1;

set cert.stress;

if RestHR ge 70 then delete;

TotalTime= (TimeMin*60 )+ TimeSec;

if TotalTime<600 then delete;

run;

data work.stress1;

set cert.stress;

where RestHR <= 70;

TotalTime= (TimeMin*60 )+ TimeSec;

if TotalTime<600 then delete;

run;

Re: Using WHERE or IF

mkeintz — Mon, 06 Jan 2020 04:56:53 GMT

You have

if RestHR ge 70 then delete;

and

where RestHR <= 70;

I don't think your issue is IF vs WHERE. It's how you treat the edge condition (i.e. RestHR=70). You are deleting 70's in the first usage, but keeping 70's in the second.

The WHERE analog to your IF … THEN DELETE statement should be

  where RestHR <70

topic Re: Using WHERE or IF in SAS Programming

Using WHERE or IF

Re: Using WHERE or IF