topic Re: SAS 9.4 scenario case 2 in SAS Programming

SAS 9.4 scenario case 2

Teeleaf — Mon, 05 Aug 2019 21:04:43 GMT

In SAS 9.4 scenario 2, one of the condition is to "remove observations with RestHR values that are greater than or equal to 70."

This condition should be written like:

where RestHR < 70;

or, the answer is correct and it should be like:

where RestHR <= 70;

I just want to check if I understand the question correctly or if i misunderstood the operation sigh.

Thanks!

Re: SAS 9.4 scenario case 2

ChrisNZ — Mon, 05 Aug 2019 22:02:57 GMT

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

is the same as

Keep observations with RestHR values that are smaller than 70

isn't it?

So: where RestHR < 70;

Unless the where clause is used in a delete statement for example, in which case

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

is written

where RestHR >= 70;

Re: SAS 9.4 scenario case 2

monicaco — Wed, 26 Feb 2020 21:13:39 GMT

In this case in SAS Book 9.4 preparation, Is the code solution for scenario 2 wrong (page 395)?+
-------
One Direction is:

• Remove observations with RestHR values that are greater than or equal to 70.

data work.stress1;
set cert.stress;
where RestHR <=70;
* this line should be "WHERE RESTHR < 70"*;
TotalTime=(timemin*60)+timesec;
if TotalTime<600 then delete;
run;

proc print data=work.stress1;
run;

Answer for each question
Question 1: 4 observation
Question 2: NA because there are only 4 observation

I appreciate any comment