SAS certified specialist Scenerio

[sprdsani]

Scenario 2 from SAS certified specialist textbook:

This scenario uses Cert. Stress data set. Write a SAS program to do the following:
-Create a new temporary SAS data set that uses Cert.Stress and store the results in Work.Stress1.
-Remove observations with RestHR values that are greater than or equal to 70.
-Create a new variable called TotalTime. The value of TotalTime is the value of TimeMin multiplied by 60, plus the value of TimeSec.

Solution code:

data work.stress1; /*#1*/
set cert.stress; /*#2*/
where RestHR <=70; /*#3*/
TotalTime=(timemin*60)+timesec; /*#4*/
if TotalTime<600 then delete; /*#5*/
run;
proc print data=work.stress1; /*#6*
run;

Solution Output:

In the solution, RestHR has values equal to 70, whereas in the question it mentions to remove RestHR values equal to greater to 70. 

Am I mistaken? Any feedback/suggestion is appreciated.

[Reeza]

Did you check if there's an errata/error page for the book and if that question is listed in there?

---

@sprdsani wrote:

Scenario 2 from SAS certified specialist textbook:

This scenario uses Cert. Stress data set. Write a SAS program to do the following:
-Create a new temporary SAS data set that uses Cert.Stress and store the results in Work.Stress1.
-Remove observations with RestHR values that are greater than or equal to 70.
-Create a new variable called TotalTime. The value of TotalTime is the value of TimeMin multiplied by 60, plus the value of TimeSec.

Solution code:

data work.stress1; /*#1*/
set cert.stress; /*#2*/
where RestHR <=70; /*#3*/
TotalTime=(timemin*60)+timesec; /*#4*/
if TotalTime<600 then delete; /*#5*/
run;
proc print data=work.stress1; /*#6*
run;

Solution Output:

In the solution, RestHR has values equal to 70, whereas in the question it mentions to remove RestHR values equal to greater to 70. 

Am I mistaken? Any feedback/suggestion is appreciated.

---

[sprdsani]

I couldn't see any error page in the book.

[Reeza]

Error pages are not in the book...they're created afterwards to include errors in the book, sort of a leftover from paper publishing from when you couldn't update materials as easily. It can still break references such as page numbers or PDF references so errors are still kept separately. Tutorials can also refer to Page 8 for example and if you update contents the pages can shift. 

Usually you find the book page online and look for updates or errata pages. I don't know where it is off the top of my head, otherwise I'd send you the link. 

---

@sprdsani wrote:

I couldn't see any error page in the book.

---

[ed_sas_member · Accepted solution]

Hi @sprdsani 

You're right, there is a mistake in the certification guide.

You can check for updates here: https://support.sas.com/content/dam/SAS/support/en/books/errata-base-certified.pdf

Extract:

I also experienced the following inconsistencies with the book:

-> The dataset 'Aprbills' can be accessed with the libname 'Cert' and not 'Clinic'

-> The dataset 'Heart' for scenario 6 can be accessed with the libname 'Sashelp' (no Excel file supplied)

Best,

[sprdsani]

Thank you for clarifying.

[ed_sas_member]

You're welcome @sprdsani !