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.
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,
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.
I couldn't see any error page in the book.
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.
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,
This is a knowledge-sharing community for SAS Certified Professionals and anyone who wants to learn more about becoming SAS Certified. Ask questions and get answers fast. Share with others who are interested in certification and who are studying for certifications.To get the most from your community experience, use these getting-started resources:
Community Do's and Don'ts
How to add SAS syntax to your post
How to get fast, helpful answers
Select SAS Training centers are offering in-person courses. View upcoming courses for: