topic Re: A tiny mistake in SAS SQL 1: Essentials Course Notes in SAS Certification

A tiny mistake in SAS SQL 1: Essentials Course Notes

dxiao2017 — Mon, 27 Jan 2025 11:29:26 GMT

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 &regionvalue, not &region.

Re: A tiny mistake in SAS SQL 1: Essentials Course Notes

StaceySyphus — Wed, 29 Jan 2025 22:05:39 GMT

This has been fixed. Thanks for bringing it to our attention.

Re: A tiny mistake in SAS SQL 1: Essentials Course Notes

dxiao2017 — Thu, 13 Feb 2025 17:43:47 GMT

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).