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

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

Thanks Kurt.   You are correct, this solved the mystery. The data provided is not matching as I mentioned in the prep guide errata thread and it is causing all these confusion.  Who is the editor/proof reader at SAS for these prep guides man? I swear I can do a better job.     ... View more

Hi Cynthia:     I do know from getting student questions in the past that some of the examples in the book are for illustration purposes only  Why not illustrate with data that can be replicated by the reader? There are so many files he can use from data set provided or from sashelp, why use a data what's no available to the reader?   I believe the Prep Guide data contains most of the bigger files that you need to practice but that not all SAS data or CSV or XLSX files are contained in the data for practicing. yeah, why is that?   In our Programming 1 class, which is free, we provide many XLSX and CSV and TAB delimited files that you can practice with. The material in the Prep Guide is intended to complement the material in Programming 1 and Programming 2 -- not completely be the only material to study.   I don't think so. No where in the prep guide does it ever say it is complimentary to the programming 1 and programming 2. Programming 1 and 2 wasn't even mentioned in the Specialist prep guide. Programming 1 and 2 uses different data sets for illustration, programming 1 and 2 uses mainly storm and national park data sets, prep guide does not use the same data set. Readers should be able to access the data files used in the book without having to enrol into programming 1 and 2.   Just in case what you said is true, I just checked, I don't see stock.xlsx in either programming 1 or 2 data sets.               ... View more

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

so let me get this straight.   The intention of that subsetting statement without anything code if the IF statement is simply to control the execution (ie, writing to output) only if the subsetting IF is TRUE? ... View more

oh okay, thanks. ... View more

thanks, this is my personal log for my own certification journey. Happy to help other members out in their own thread, when I get into more advanced exams, right now I am just focus on passing the BASE exam, already booked on the 20th Nov. ... View more

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

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