topic Re: Errata for SAS Certified Specialist Prep Guide (2019) in SAS Certification

Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Sat, 05 Nov 2022 10:44:14 GMT

In addition for the official errata, post any errata not included in the official errata that you may have found.

On page 85, I am pretty sure that should be

data=cert.heart

Since we only ever created cert library in the entire book (except two others for excel demo only), never created or used a clinic library (other than using clinic.admit (pg 44) as an example to explain data statement. Heart.sas is inside cert library.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Sat, 05 Nov 2022 23:31:27 GMT

page 79. should be work.admit, since it is just a follow up from the example on page 77. work.admit

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Sat, 05 Nov 2022 23:33:37 GMT

page 86, possibly used the wrong options, see this thread.

https://communities.sas.com/t5/SAS-Programming/firstobs-obs-not-giving-intended-result/m-p/842653#M333197

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Tue, 08 Nov 2022 11:01:38 GMT

page 161.

cert.cltrials data set in the book printout has 9 observations, but in the data supplied, only have 7 observation.

Now this is after SAS institute told us about the errata from pg 161 to 164 that the correct data is cert.cltrials instead of cert.trials in their official update pdf.

Because of the data is different, the transposed result on page 164 is different from the SAS output.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Wed, 09 Nov 2022 12:16:18 GMT

another issue caused by the difference in data set above is concatenated id on page 162 as mentioned in this thread.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Fri, 11 Nov 2022 21:12:16 GMT

page 181.

the data set provided in cert.measure is slightly different from the book in that row 6 and 7 in the book are the last two rows in the data set.

so you will get different result from figure 10.3 on page 182 if you run the code on page 181.

you just sort cert.measure by ID first to get the same result.

proc sort data=cert.measure out=measure_sorted;
by ID;
run;


data one2one;
set cert.patients;
if age<60;
set measure_sorted;
run;

proc print data=one2one;run;

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Sat, 12 Nov 2022 10:26:53 GMT

page 217, both error and missing data.

firstly, it should be cert.CDRates as data sets are not stored in the temp work library. Secondly, the CDRates do not exist at all.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Mon, 14 Nov 2022 08:30:47 GMT

not mentioning fmtsearch= option in chapter 12 on proc format would definitely be counted as a major oversight, I wasted over 3 hours yesterday on this.

https://communities.sas.com/t5/SAS-Programming/Format-was-not-found-or-could-not-be-loaded/m-p/843977#M333658

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Mon, 14 Nov 2022 09:40:25 GMT

Page 263, pretty sure that TODAYDATE is not a function and author missed a line break to break up TODAY and DATE function.

Searched google, can't find TODAYDATE function.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Tue, 15 Nov 2022 09:49:22 GMT

so the TODAYDATE() function also exist in the SAS BASE exam reference guide.

https://communities.sas.com/t5/SAS-Programming/is-TODAYDATE-a-real-function-or-typo/m-p/844275#M333779

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Sat, 19 Nov 2022 23:26:27 GMT

page 244, should be format, not informat?

see

https://communities.sas.com/t5/SAS-Programming/date-informat-in-PROC-IMPORT-confusing-prep-guide-example/m-p/845283#M334155

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Anne_A — Mon, 21 Nov 2022 13:35:02 GMT

Hello @Nietzsche ,

In this specific case as the data is read I believe informat is the correct phrasing (format would be for how to show a value - informat is to specify how to read one).

Cheers.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Tom — Mon, 21 Nov 2022 14:14:23 GMT

@Anne_A wrote:

Hello @Nietzsche ,

In this specific case as the data is read I believe informat is the correct phrasing (format would be for how to show a value - informat is to specify how to read one).

Cheers.

An INFORMAT is the SAS feature that supports controlling how text strings are converted into values.

This example is showing that PROC IMPORT is able to read files that have dates stored as string in Month/Day/Year order. PROC IMPORT will decide to use USE the mmddyy informat to do that. It will also decide to attach the mmddyy format to the variable so that when it is printed it will be display in the same Month/Day/Year order.

It is NOT an example of how a user could use either an informat or a format directly. Calling this either informat or format is just confusing especially to learners that might not fully understand what an informat and a format actually are.

Something like this would be more accurate (and less confusing).

The follow example illustrates reading a CSV that has dates stored in mm/dd/yyyy style.

If they wanted to use it to introduce informat and format as concepts they might add:

Notice how PROC IMPORT generated SAS code that used the MMDDYY10. informat to read the file and attached the MMDDYY10. format to the variable so that it would print in the same mm/dd/yyyy style.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Anne_A — Mon, 21 Nov 2022 15:36:57 GMT

Hello @Tom ,

Agreed, of course - I was essentially trying to answer @Nietzsche's assumption that "informat" in the given context should be replaced with format, implying there was a mistake in the Prep Guide (which I happen to own too,as well as the mentioned source file).

"Reading" and "writing" are admittedly shortcuts (here also intended as useful mnemonics), i.e. simplifications that have the advantage of presenting things simply (you might say / think in a simplistic way 🙂), a strategy often used in teaching (and quite clearly used in the Prep Guide), admittedly with the risk of creating misconceptions (which you very thoroughly corrected).

The page @Nietzsche was referring to is part of a paragraph titled "Reading Dates and Times with Informats" and I was basically using the same vocabulary to answer his question. I was certainly not trying to teach him the difference between format and informat - he has a whole chapter in the Prep Guide for that.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Mon, 21 Nov 2022 21:05:00 GMT

page 399 and 400 should be swapped around.

You can see the results starts with title "Laguardia Flights" and the first group is Dest=CPH PDF printout on page 401.

But the SAS result start on page 400 and continue on 399. out of order.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Tue, 22 Nov 2022 21:06:25 GMT

page 372

the second dot point should be

Create a macro variable named Location...

since the "&" is part of the macro variable code, not part of the actual variable name. "&" is an illegal character for a variable name.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Tom — Tue, 22 Nov 2022 21:13:05 GMT

Are you sure? Is there any mention of a macro variable named LOCATION before? If LOCATION has a value that is a valid macro variable name then you could definitely create a macro variable named &LOCATION.

252  %let location=myname;
253  %let &location=102;
254  %put &&&location;
102

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Tue, 22 Nov 2022 21:47:10 GMT

yes I am sure, what you see in the attached is the entire question from beginning to end for "scenario 9", and I am sure it is an error/typo because

if you look at the solution to scenario 9, statement 1, it says

But in the Directions section of scenario 9, it says

I mean one of them is wrong or both are correct but inconsistent usage which is confusing.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Thu, 01 Dec 2022 11:31:42 GMT

on page 50.

figure 4.3, the tab should be "ActivityLevels" or "activitylevels" and not "adv".

Because both the exercise.xlsx provided and on page 51 name/refers that sheet as "activitylevels" and "ActivityLevels" respectively.

Three different inconsistent naming across figure, code and data set provided.

Re: Errata for SAS Certified Specialist Prep Guide (2019)

Nietzsche — Tue, 06 Dec 2022 11:28:17 GMT

this one is a doozy, page 212...

Who the F charges 75% annual interest rate? Mexican cartels don't even charge that much.

Did the author really just write the book and think hmmm $1069 interest earned on a $1000 principal after only 12 months seems reasonable?

Interest rate went back to a more reasonable 7.5% on page 213.