Hello,
Today I found a tiny mistake in SAS SQL 1: Essentials Course Notes PDF on page 319, the answer for practice question s106s02 (see picture below). The macro variable name in the title should be ®ionvalue, not ®ion.
This has been fixed. Thanks for bringing it to our attention.
This has been fixed. Thanks for bringing it to our attention.
Hi, it is a happy surprise that I got this reply, I am a big fun of PG1 and PG2 courses, I like both the codes and the way the program and materials has been presented, and they helped a lot in my test preparation. Today I found another tiny mistake in the answer for practice s102s03, on page 107 in SQL1: essentials course note PDF (screenshot is as below). The merchant name of December's first transaction is Sceneit Cinemas, LLC, not Big Burgers, Inc. I run both my code and code provided by the course note and had the same results (see below).
Also, I can see from the first five rows that the above result table (see below, the lower one) is the same as the partial result table provided with the original question on course note PDF, page 65 (see below, the upper one).
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
Ready to level-up your skills? Choose your own adventure.