https://communities.sas.com/t5/SAS-Programming/SAS-advanced-Guide-Chapter-1-quiz-Q7/m-p/611531#M178239 <P>yes, you are right it should be C</P> <P>&nbsp;</P> <P>The below code confirms the same</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/34750i0ED752ECE3CDCAC4/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Fri, 13 Dec 2019 08:11:24 GMT Jagadishkatam 2019-12-13T08:11:24Z https://communities.sas.com/t5/SAS-Programming/SAS-advanced-Guide-Chapter-1-quiz-Q7/m-p/611525#M178236 <P>Based on the answer explanation, it seems the correct answer is C not A, isn't it?</P><P>&nbsp;</P><DIV class="xis-paragraphFirst">7.What happens if you use a GROUP BY clause in a PROC SQL step without a summary function?</DIV><DIV class="xis-paragraphFirst">a. The step does not execute.</DIV><DIV class="xis-paragraphFirst">b. The first numeric column is summed by default.</DIV><DIV class="xis-paragraphFirst">c. The GROUP BY clause is changed to an ORDER BY clause.</DIV><DIV class="xis-paragraphFirst">d. The step executes but does not group or sort data.</DIV><DIV class="xis-paragraphFirst">&nbsp;</DIV><DIV class="xis-paragraphFirst"><DIV class="xis-paragraphFirst">Correct answer: a</DIV><DIV class="xis-paragraph">The GROUP BY clause is used in queries that include one or more summary functions. If you specify a GROUP BY clause in a query that does not contain a summary function, your clause is changed to an ORDER BY clause.</DIV></DIV> Fri, 13 Dec 2019 07:25:22 GMT https://communities.sas.com/t5/SAS-Programming/SAS-advanced-Guide-Chapter-1-quiz-Q7/m-p/611525#M178236 Teeleaf 2019-12-13T07:25:22Z https://communities.sas.com/t5/SAS-Programming/SAS-advanced-Guide-Chapter-1-quiz-Q7/m-p/611531#M178239 <P>yes, you are right it should be C</P> <P>&nbsp;</P> <P>The below code confirms the same</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/34750i0ED752ECE3CDCAC4/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span></P> Fri, 13 Dec 2019 08:11:24 GMT https://communities.sas.com/t5/SAS-Programming/SAS-advanced-Guide-Chapter-1-quiz-Q7/m-p/611531#M178239 Jagadishkatam 2019-12-13T08:11:24Z