topic Re: SAS certified specialist Scenerio in SAS Certification

SAS certified specialist Scenerio

sprdsani — Sun, 03 May 2020 20:21:42 GMT

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.

Re: SAS certified specialist Scenerio

Reeza — Sun, 03 May 2020 20:35:56 GMT

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.

Re: SAS certified specialist Scenerio

sprdsani — Sun, 03 May 2020 20:38:40 GMT

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

Re: SAS certified specialist Scenerio

Reeza — Sun, 03 May 2020 20:54:00 GMT

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.

Re: SAS certified specialist Scenerio

ed_sas_member — Mon, 04 May 2020 06:40:06 GMT

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,

Re: SAS certified specialist Scenerio

sprdsani — Mon, 04 May 2020 15:49:28 GMT

Thank you for clarifying.

Re: SAS certified specialist Scenerio

ed_sas_member — Mon, 04 May 2020 16:03:58 GMT

You're welcome @sprdsani !