I put all the errata I have found in this thread.  SAS prep guides does not list the name of the author, so hopefully some SAS employee will refer to the SAS department that is responsible for the books to this thread and fix their errors and omissions in the next edition.   https://communities.sas.com/t5/SAS-Certification/Errata-for-SAS-Certified-Specialist-Prep-Guide-2019/m-p/842646#M1365 ... View more

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.     ... View more

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 ... View more

IT WAS NOT MENTIONED AT ALL. Ridiculous that the author would left this out!   here is the entire chapter 12 if you wish to search for that option. ... View more

thanks, I spent 3 hours on this yesterday ... View more

Do I need to? The prep guide never said anything about FMTSEARCH option.   In fact it says SAS will search both work and permanent library anyway until the format is found.   ... View more

I deleted the entire catelog and retry again, now, nothing works, I mean it is right there in the when I check fmtlib proc format lib=formtlib fmtlib; run; you can see the three formats, but when I run data work.carsurvey; set cert.cars; format Sex gender. Age agegroup. Color $col. Income Dollar8.; run; proc print data=work.carsurvey; run; I get    log 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 data work.carsurvey; 72 set cert.cars; 73 format Sex gender. Age agegroup. Color $col. Income Dollar8.; _______ 484 NOTE 484-185: Format GENDER was not found or could not be loaded. 73 ! format Sex gender. Age agegroup. Color $col. Income Dollar8.; _________ 484 NOTE 484-185: Format AGEGROUP was not found or could not be loaded. 73 ! format Sex gender. Age agegroup. Color $col. Income Dollar8.; _____ 484 NOTE 484-185: Format $COL was not found or could not be loaded. 74 run; NOTE: There were 8 observations read from the data set CERT.CARS. NOTE: The data set WORK.CARSURVEY has 8 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 953.90k OS Memory 29872.00k Timestamp 13/11/2022 03:50:54 AM Step Count 132 Switch Count 2 Page Faults 0 Page Reclaims 174 Page Swaps 0 Voluntary Context Switches 17 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 75 proc print data=work.carsurvey; 76 run; NOTE: There were 8 observations read from the data set WORK.CARSURVEY. NOTE: PROCEDURE PRINT used (Total process time): real time 0.02 seconds user cpu time 0.03 seconds system cpu time 0.00 seconds memory 2400.84k OS Memory 30380.00k Timestamp 13/11/2022 03:50:54 AM Step Count 133 Switch Count 0 Page Faults 0 Page Reclaims 297 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89           ... View more

Happy week 46. Week 45 update, total SAS study time this week is 12.4 hours.  Up to chapter 12 of the specialist prep guide.     ... View more

CDRates file is missing on page 217 is missing. ... View more

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.     ... View more