Congratulations! 😃 ... View more

@beccagre wrote: he JMP exams will be undergoing a review in 2023.   Thank you Becky! As pointed out above it is more meant as a way to get new employees getting familiar with statistics.  I am looking forward to see the revised cert in '23 ...  --fja ... View more

@beccagre wrote:  [...]   https://www.sas.com/en_us/certification/credentials/jmp/jmp-statistical-thinking.html  [...] If you are interested in the exam make sure you download the exam content guide.  We also provide a pdf of sample questions.  There is a note on the page that the certification exam is being retired on December 31st 2022 [...] Hello Becky!   Thank you for your reply. I know that page - of course - but I did not see the retirement remark. Thanks for bringing this to my attention. The retirement might be the reason why there is no prep exam available.   Question about the Exam: Will there be a replacement for the certificate?    Cheers fja   ... View more

  @Anne_A wrote: We'll see what happens 😥! I am sure it will work with a decent preparation. I do not want to scare you off, it is just that I would like you not to underestimate the exam. Tell us if that you have succeeded afterwards. 🙂  Best FJa ... View more

Hello @Anne_A! Unfortunately yes, given the prep exams 2 yrs ago. But I heared that they have changed and improved. Nevertheless I conclude that one should make sure to have covered all topics thoroughly that are mentioned in the exam guide. --fja ... View more

Glad that it works for you now. May I suggest sparing a like for those having lent a helping hand? ... Just a thought to keep people motivated. 🙂 --fja ... View more

Good evening! The "select distinct" refers to uniqueness in all columns given as an argument, in your case id, year, area ... Now as I see four different (distinct) combinations in the sample provided by you, why do you expect 2 rows? --fja ... View more

Please post a ready to paste example including a data step creating a mock table for _final_ that demonstrates the error. --fja ... View more

Hello Becky! Thank you very much for your kind reply. I will reach out to one of our subject matter experts who teaches the Platform Administration Fast Track course and inquire about books.  That would be most helpful! I really appreciate your efforts. Thank you very much in advance. --fja ... View more

Thanks for confirming. ... View more

Oh hummm ... so Pandora's box has been opened ... 🙂 Thanks for sharing this! ... View more

Being familiar with relational databases and sql and given that I am experienced in many programming languages it did not take me too long. 4w for the advanced programmer, about the same time for the base programmer. I did not log the actual time spent, though. But it is worth mentioning that the timeframe for taking the exam is quite tight. So I passed, but I found it to be a bit of a challenge. So do not underestimate the actual exam, would be my advice. --fja edit: I have not responded to the resources I used:  (a) The Little SAS Book (I keep on recommending this) (b) The online documentation (which is really brilliant, chapeau!) (c) some introductory material from various sources out in the internet. ... View more

"Moved onto third party books, about 1/3 through Ron Cody's A Gentle Introduction to Statistics Using SAS Studio [...]" Let me draw your attention to the curren 55% off campaign. I found the exams being significantly more difficult than the preperation material. Why not give it a go before December 15th, just for knowing what level to prepare for ... or passing the first time. 🙂 ... View more