{"id":45869,"date":"2022-09-27T03:01:19","date_gmt":"2022-09-27T03:01:19","guid":{"rendered":"https:\/\/www.dumpsbase.com\/freedumps\/?p=45869"},"modified":"2022-09-27T03:01:25","modified_gmt":"2022-09-27T03:01:25","slug":"sas-certified-specialist-base-programming-using-sas-9-4-a00-231-dumps-questions-and-answers","status":"publish","type":"post","link":"https:\/\/www.dumpsbase.com\/freedumps\/sas-certified-specialist-base-programming-using-sas-9-4-a00-231-dumps-questions-and-answers.html","title":{"rendered":"SAS Certified Specialist: Base Programming Using SAS 9.4 A00-231 Dumps Questions and Answers"},"content":{"rendered":"\n<p>To prepare for the SAS Certified Specialist: Base Programming Using SAS 9.4 A00-231 exam, you can have the SAS A00-231 dumps questions and answers as the preparation materials. You&#8217;ll be able to trust this trustable SAS Institute A00-231 dumps and candidates get a lot of opportunities from right here and pass the A00-231 SAS 9.4 Base Programming &#8212; Performance-based exam at the most important endeavor. The really authenticated A00-231 dumps together with the advanced techniques will assure a very good outcome in the A00-231 test.<\/p>\n<h2>Check SAS Certified Specialist: Base Programming Using SAS 9.4 <em><span style=\"color: #339966;\">A00-231 Free Dum<\/span><span style=\"color: #339966;\">p<\/span><span style=\"color: #339966;\">s<\/span><\/em><\/h2>\n<script>\n\t  window.fbAsyncInit = function() {\n\t    FB.init({\n\t      appId            : '622169541470367',\n\t      autoLogAppEvents : true,\n\t      xfbml            : true,\n\t      version          : 'v3.1'\n\t    });\n\t  };\n\t\n\t  (function(d, s, id){\n\t     var js, fjs = d.getElementsByTagName(s)[0];\n\t     if (d.getElementById(id)) {return;}\n\t     js = d.createElement(s); js.id = id;\n\t     js.src = \"https:\/\/connect.facebook.net\/en_US\/sdk.js\";\n\t     fjs.parentNode.insertBefore(js, fjs);\n\t   }(document, 'script', 'facebook-jssdk'));\n\t<\/script><script type=\"text\/javascript\" >\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \nif(!window.jQuery) alert(\"The important jQuery library is not properly loaded in your site. Your WordPress theme is probably missing the essential wp_head() call. You can switch to another theme and you will see that the plugin works fine and this notice disappears. If you are still not sure what to do you can contact us for help.\");\n});\n<\/script>  \n  \n<div  id=\"watupro_quiz\" class=\"quiz-area single-page-quiz\">\n<p id=\"submittingExam6612\" style=\"display:none;text-align:center;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\"><\/p>\n\n<div class=\"watupro-exam-description\" id=\"description-quiz-6612\"><\/div>\n\n<form action=\"\" method=\"post\" class=\"quiz-form\" id=\"quiz-6612\"  enctype=\"multipart\/form-data\" >\n<div class='watu-question ' id='question-1' style=';'><div id='questionWrap-1'  class='   watupro-question-id-234185'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>1. <\/span>The following SAS program is submittad: <br \/>\r<br>data work.sales; <br \/>\r<br>do year = 1 to 5; <br \/>\r<br>do month=1 to 12; <br \/>\r<br>x+1; <br \/>\r<br>output <br \/>\r<br>end; <br \/>\r<br>end; <br \/>\r<br>run; <br \/>\r<br>How many observations are written the WORK SALES data set?<\/div><input type='hidden' name='question_id[]' id='qID_1' value='234185' \/><input type='hidden' id='answerType234185' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234185[]' id='answer-id-929791' class='answer   answerof-234185 ' value='929791'   \/><label for='answer-id-929791' id='answer-label-929791' class=' answer'><span>0<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234185[]' id='answer-id-929792' class='answer   answerof-234185 ' value='929792'   \/><label for='answer-id-929792' id='answer-label-929792' class=' answer'><span>1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234185[]' id='answer-id-929793' class='answer   answerof-234185 ' value='929793'   \/><label for='answer-id-929793' id='answer-label-929793' class=' answer'><span>5<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234185[]' id='answer-id-929794' class='answer   answerof-234185 ' value='929794'   \/><label for='answer-id-929794' id='answer-label-929794' class=' answer'><span>60<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-2' style=';'><div id='questionWrap-2'  class='   watupro-question-id-234186'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>2. <\/span>The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of \u201cAsking Price\u201d. <br \/>\r<br>Which SAS program temporarily replaces the label \u201cAsking Price\u201d with the label \u201cSale Price\u201d in the output?<\/div><input type='hidden' name='question_id[]' id='qID_2' value='234186' \/><input type='hidden' id='answerType234186' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234186[]' id='answer-id-929795' class='answer   answerof-234186 ' value='929795'   \/><label for='answer-id-929795' id='answer-label-929795' class=' answer'><span>proc print data = sasuser.houses; label \r\nprice = \u201cSale Price\u201d; \r\nrun;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234186[]' id='answer-id-929796' class='answer   answerof-234186 ' value='929796'   \/><label for='answer-id-929796' id='answer-label-929796' class=' answer'><span>proc print data = sasuser.houses label; label \r\nprice \u201cSale Price\u201d; \r\nrun;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234186[]' id='answer-id-929797' class='answer   answerof-234186 ' value='929797'   \/><label for='answer-id-929797' id='answer-label-929797' class=' answer'><span>proc print data = sasuser.houses label; label \r\nprice = \u201cSale Price\u201d; \r\nrun;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234186[]' id='answer-id-929798' class='answer   answerof-234186 ' value='929798'   \/><label for='answer-id-929798' id='answer-label-929798' class=' answer'><span>proc print data = sasuser.houses; \r\nprice = \u201cSale Price\u201d; \r\nrun;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-3' style=';'><div id='questionWrap-3'  class='   watupro-question-id-234187'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>3. <\/span>The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below: <br \/>\r<br>WORK.EMPLOYEE WORK.SALARY <br \/>\r<br>fname age name salary <br \/>\r<br>Bruce 30 Bruce 25000 <br \/>\r<br>Dan 40 Bruce 35000 <br \/>\r<br>Dan 25000 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data work.empdata; <br \/>\r<br>by fname; <br \/>\r<br>totsal + salary; <br \/>\r<br>run; <br \/>\r<br>Which one of the following statements completes the merge of the two data sets by the FNAME variable?<\/div><input type='hidden' name='question_id[]' id='qID_3' value='234187' \/><input type='hidden' id='answerType234187' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234187[]' id='answer-id-929799' class='answer   answerof-234187 ' value='929799'   \/><label for='answer-id-929799' id='answer-label-929799' class=' answer'><span>merge work.employeework.salary (fname = name);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234187[]' id='answer-id-929800' class='answer   answerof-234187 ' value='929800'   \/><label for='answer-id-929800' id='answer-label-929800' class=' answer'><span>merge work.employeework.salary (name = fname);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234187[]' id='answer-id-929801' class='answer   answerof-234187 ' value='929801'   \/><label for='answer-id-929801' id='answer-label-929801' class=' answer'><span>merge work.employeework.salary (rename = (fname = name));<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234187[]' id='answer-id-929802' class='answer   answerof-234187 ' value='929802'   \/><label for='answer-id-929802' id='answer-label-929802' class=' answer'><span>merge work.employeework.salary (rename = (name = fname));<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-4' style=';'><div id='questionWrap-4'  class='   watupro-question-id-234188'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>4. <\/span>The following SAS program is submitted: <br \/>\r<br>data test; <br \/>\r<br>set chemists; <br \/>\r<br>jobcode = \u2018Chem2\u2019 <br \/>\r<br>then description = \u2018Senior Chemist\u2019; <br \/>\r<br>else description = \u2018Unknown\u2019; <br \/>\r<br>run; <br \/>\r<br>The value for the variable JOBCODE is: <br \/>\r<br>JOBCODE <br \/>\r<br>------------- <br \/>\r<br>chem2 <br \/>\r<br>What is the value of the variable DESCRIPTION?<\/div><input type='hidden' name='question_id[]' id='qID_4' value='234188' \/><input type='hidden' id='answerType234188' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234188[]' id='answer-id-929803' class='answer   answerof-234188 ' value='929803'   \/><label for='answer-id-929803' id='answer-label-929803' class=' answer'><span>chem2<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234188[]' id='answer-id-929804' class='answer   answerof-234188 ' value='929804'   \/><label for='answer-id-929804' id='answer-label-929804' class=' answer'><span>Unknown<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234188[]' id='answer-id-929805' class='answer   answerof-234188 ' value='929805'   \/><label for='answer-id-929805' id='answer-label-929805' class=' answer'><span>Senior Chemist<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234188[]' id='answer-id-929806' class='answer   answerof-234188 ' value='929806'   \/><label for='answer-id-929806' id='answer-label-929806' class=' answer'><span>\u2018 \u2018 (missing character value)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-5' style=';'><div id='questionWrap-5'  class='   watupro-question-id-234189'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>5. <\/span>The following SAS program is submitted: <br \/>\r<br>data work. new; <br \/>\r<br>length word $7; <br \/>\r<br>amount = 4; <br \/>\r<br>it amount = 4 then word = \u2018FOUR\u2019; <br \/>\r<br>else if amount = 7 <br \/>\r<br>then word = \u2018SEVEN\u2019; <br \/>\r<br>else word = \u2018NONE!!!\u2019; <br \/>\r<br>amount = 7; <br \/>\r<br>run; <br \/>\r<br>What are the values of the AMOUNT and WORD variables in SAS dataset work.new?<\/div><input type='hidden' name='question_id[]' id='qID_5' value='234189' \/><input type='hidden' id='answerType234189' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234189[]' id='answer-id-929807' class='answer   answerof-234189 ' value='929807'   \/><label for='answer-id-929807' id='answer-label-929807' class=' answer'><span>amount word \r\n4 FOUR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234189[]' id='answer-id-929808' class='answer   answerof-234189 ' value='929808'   \/><label for='answer-id-929808' id='answer-label-929808' class=' answer'><span>amount word \r\n4 NONE!!!<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234189[]' id='answer-id-929809' class='answer   answerof-234189 ' value='929809'   \/><label for='answer-id-929809' id='answer-label-929809' class=' answer'><span>amount word \r\n7 FOUR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234189[]' id='answer-id-929810' class='answer   answerof-234189 ' value='929810'   \/><label for='answer-id-929810' id='answer-label-929810' class=' answer'><span>amount word \r\n7 SEVEN<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-6' style=';'><div id='questionWrap-6'  class='   watupro-question-id-234190'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>6. <\/span>The following SAS program is submitted: <br \/>\r<br>data combine; <br \/>\r<br>prefix=\u2019505\u2019; <br \/>\r<br>middle=\u20196465 \u2018; <br \/>\r<br>end=\u201909090\u2019; <br \/>\r<br>&lt;insert statement here&gt;; <br \/>\r<br>run; <br \/>\r<br>Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?<\/div><input type='hidden' name='question_id[]' id='qID_6' value='234190' \/><input type='hidden' id='answerType234190' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234190[]' id='answer-id-929811' class='answer   answerof-234190 ' value='929811'   \/><label for='answer-id-929811' id='answer-label-929811' class=' answer'><span>total = cat(\u2019-\u2019, prefix, middle, end);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234190[]' id='answer-id-929812' class='answer   answerof-234190 ' value='929812'   \/><label for='answer-id-929812' id='answer-label-929812' class=' answer'><span>total = catx(\u2019-\u2019, prefix, middle, end);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234190[]' id='answer-id-929813' class='answer   answerof-234190 ' value='929813'   \/><label for='answer-id-929813' id='answer-label-929813' class=' answer'><span>total = prefix !!\u2019-\u2019!! middle \u2018\u2018!!\u2019-\u2019!! end;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234190[]' id='answer-id-929814' class='answer   answerof-234190 ' value='929814'   \/><label for='answer-id-929814' id='answer-label-929814' class=' answer'><span>total = prefix!!\u2019-\u2019!! left(middle)!!\u2019-\u2019!! end;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-7' style=';'><div id='questionWrap-7'  class='   watupro-question-id-234191'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>7. <\/span>Given the following code: <br \/>\r<br>proc print data=SASHELP.CLASS(firstobs=5 obs=15); <br \/>\r<br>where Sex='M'; <br \/>\r<br>run; <br \/>\r<br>How many observations will be displayed?<\/div><input type='hidden' name='question_id[]' id='qID_7' value='234191' \/><input type='hidden' id='answerType234191' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234191[]' id='answer-id-929815' class='answer   answerof-234191 ' value='929815'   \/><label for='answer-id-929815' id='answer-label-929815' class=' answer'><span>11<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234191[]' id='answer-id-929816' class='answer   answerof-234191 ' value='929816'   \/><label for='answer-id-929816' id='answer-label-929816' class=' answer'><span>15<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234191[]' id='answer-id-929817' class='answer   answerof-234191 ' value='929817'   \/><label for='answer-id-929817' id='answer-label-929817' class=' answer'><span>10 or fewer<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234191[]' id='answer-id-929818' class='answer   answerof-234191 ' value='929818'   \/><label for='answer-id-929818' id='answer-label-929818' class=' answer'><span>11 or fewer<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-8' style=';'><div id='questionWrap-8'  class='   watupro-question-id-234192'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>8. <\/span>Which ODS statement option terminates output being written to an HTML rile?<\/div><input type='hidden' name='question_id[]' id='qID_8' value='234192' \/><input type='hidden' id='answerType234192' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234192[]' id='answer-id-929819' class='answer   answerof-234192 ' value='929819'   \/><label for='answer-id-929819' id='answer-label-929819' class=' answer'><span>END<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234192[]' id='answer-id-929820' class='answer   answerof-234192 ' value='929820'   \/><label for='answer-id-929820' id='answer-label-929820' class=' answer'><span>QUIT<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234192[]' id='answer-id-929821' class='answer   answerof-234192 ' value='929821'   \/><label for='answer-id-929821' id='answer-label-929821' class=' answer'><span>STOP<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234192[]' id='answer-id-929822' class='answer   answerof-234192 ' value='929822'   \/><label for='answer-id-929822' id='answer-label-929822' class=' answer'><span>CLOSE<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-9' style=';'><div id='questionWrap-9'  class='   watupro-question-id-234193'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>9. <\/span>The Excel workbook QTR1.XLS contains the following three worksheets: <br \/>\r<br>JAN <br \/>\r<br>FEB <br \/>\r<br>MAR <br \/>\r<br>Which statement correctly assigns a library reference to the Excel workbook?<\/div><input type='hidden' name='question_id[]' id='qID_9' value='234193' \/><input type='hidden' id='answerType234193' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234193[]' id='answer-id-929823' class='answer   answerof-234193 ' value='929823'   \/><label for='answer-id-929823' id='answer-label-929823' class=' answer'><span>libname qtrdata 'qtr1.xls';<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234193[]' id='answer-id-929824' class='answer   answerof-234193 ' value='929824'   \/><label for='answer-id-929824' id='answer-label-929824' class=' answer'><span>libname 'qtr1.xls' sheets=3;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234193[]' id='answer-id-929825' class='answer   answerof-234193 ' value='929825'   \/><label for='answer-id-929825' id='answer-label-929825' class=' answer'><span>libname jan feb mar 'qtr1.xls';<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234193[]' id='answer-id-929826' class='answer   answerof-234193 ' value='929826'   \/><label for='answer-id-929826' id='answer-label-929826' class=' answer'><span>libname mydata 'qtr1.xls' WOR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234193[]' id='answer-id-929827' class='answer   answerof-234193 ' value='929827'   \/><label for='answer-id-929827' id='answer-label-929827' class=' answer'><span>heets=(jan,feb,mar);<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-10' style=';'><div id='questionWrap-10'  class='   watupro-question-id-234194'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>10. <\/span>The following SAS program is submitted: <br \/>\r<br><br><img decoding=\"async\" width=159 height=78 id=\"\u56fe\u7247 130\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image001-58.jpg\"><br><br \/>\r<br>How many observations are written to the WORK.SALES data set?<\/div><input type='hidden' name='question_id[]' id='qID_10' value='234194' \/><input type='hidden' id='answerType234194' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234194[]' id='answer-id-929828' class='answer   answerof-234194 ' value='929828'   \/><label for='answer-id-929828' id='answer-label-929828' class=' answer'><span>0<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234194[]' id='answer-id-929829' class='answer   answerof-234194 ' value='929829'   \/><label for='answer-id-929829' id='answer-label-929829' class=' answer'><span>1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234194[]' id='answer-id-929830' class='answer   answerof-234194 ' value='929830'   \/><label for='answer-id-929830' id='answer-label-929830' class=' answer'><span>5<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234194[]' id='answer-id-929831' class='answer   answerof-234194 ' value='929831'   \/><label for='answer-id-929831' id='answer-label-929831' class=' answer'><span>60<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-11' style=';'><div id='questionWrap-11'  class='   watupro-question-id-234195'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>11. <\/span>Given the following raw data record: <br \/>\r<br>----I----10---I----20---I----30 <br \/>\r<br>son Travis, <br \/>\r<br>The following output is desired: <br \/>\r<br>Obs relation firstname <br \/>\r<br>1 son Travis <br \/>\r<br>Which SAS program correctly reads in the raw data?<\/div><input type='hidden' name='question_id[]' id='qID_11' value='234195' \/><input type='hidden' id='answerType234195' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234195[]' id='answer-id-929832' class='answer   answerof-234195 ' value='929832'   \/><label for='answer-id-929832' id='answer-label-929832' class=' answer'><span>data family ( dIm = \u2018,\u2019); infile \u2018tile specification\u2019; input relation $ firstname $; run;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234195[]' id='answer-id-929833' class='answer   answerof-234195 ' value='929833'   \/><label for='answer-id-929833' id='answer-label-929833' class=' answer'><span>options dIm = \u2018,\u2019; data family; infile \u2018file specification\u2019; input relation $ firstname $; run;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234195[]' id='answer-id-929834' class='answer   answerof-234195 ' value='929834'   \/><label for='answer-id-929834' id='answer-label-929834' class=' answer'><span>data family; infile \u2018file specification\u2019 dIm = \u2018,\u2019; input relation $ firstname $; run;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234195[]' id='answer-id-929835' class='answer   answerof-234195 ' value='929835'   \/><label for='answer-id-929835' id='answer-label-929835' class=' answer'><span>data family; infile \u2018file specification\u2019; input relation $ firstname $ \/ dim = \u2018,\u2019; run;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-12' style=';'><div id='questionWrap-12'  class='   watupro-question-id-234196'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>12. <\/span>Given the SAS data set ONE: <br \/>\r<br>Given the SAS data set WORK.ONE: <br \/>\r<br><br><img decoding=\"async\" width=57 height=112 id=\"\u56fe\u7247 141\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image002-54.jpg\"><br><br \/>\r<br>The following SAS program is submitted: <br \/>\r<br><br><img decoding=\"async\" width=217 height=78 id=\"\u56fe\u7247 143\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image003-51.jpg\"><br><br \/>\r<br>Which report is produced? <br \/>\r<br><br><img decoding=\"async\" width=324 height=480 id=\"\u56fe\u7247 145\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image004-46.jpg\"><br><\/div><input type='hidden' name='question_id[]' id='qID_12' value='234196' \/><input type='hidden' id='answerType234196' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234196[]' id='answer-id-929836' class='answer   answerof-234196 ' value='929836'   \/><label for='answer-id-929836' id='answer-label-929836' class=' answer'><span>Option A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234196[]' id='answer-id-929837' class='answer   answerof-234196 ' value='929837'   \/><label for='answer-id-929837' id='answer-label-929837' class=' answer'><span>Option B<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234196[]' id='answer-id-929838' class='answer   answerof-234196 ' value='929838'   \/><label for='answer-id-929838' id='answer-label-929838' class=' answer'><span>Option C<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234196[]' id='answer-id-929839' class='answer   answerof-234196 ' value='929839'   \/><label for='answer-id-929839' id='answer-label-929839' class=' answer'><span>Option D<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-13' style=';'><div id='questionWrap-13'  class='   watupro-question-id-234197'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>13. <\/span>The following SAS program is submitted: <br \/>\r<br>data test; <br \/>\r<br>set sasuser.employees; <br \/>\r<br>if 2 le years_service le 10 then <br \/>\r<br>amount = 1000; <br \/>\r<br>else amount = 0; <br \/>\r<br>amount_per_year = years_service \/ amount <br \/>\r<br>run; <br \/>\r<br>What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?<\/div><input type='hidden' name='question_id[]' id='qID_13' value='234197' \/><input type='hidden' id='answerType234197' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234197[]' id='answer-id-929840' class='answer   answerof-234197 ' value='929840'   \/><label for='answer-id-929840' id='answer-label-929840' class=' answer'><span>0<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234197[]' id='answer-id-929841' class='answer   answerof-234197 ' value='929841'   \/><label for='answer-id-929841' id='answer-label-929841' class=' answer'><span>0.001<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234197[]' id='answer-id-929842' class='answer   answerof-234197 ' value='929842'   \/><label for='answer-id-929842' id='answer-label-929842' class=' answer'><span>1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234197[]' id='answer-id-929843' class='answer   answerof-234197 ' value='929843'   \/><label for='answer-id-929843' id='answer-label-929843' class=' answer'><span>. (missing numeric value)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-14' style=';'><div id='questionWrap-14'  class='   watupro-question-id-234198'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>14. <\/span>The following output is created by the FREQUENCY procedure: <br \/>\r<br><br><img decoding=\"async\" width=552 height=466 id=\"\u56fe\u7247 147\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image005-45.jpg\"><br><br \/>\r<br>Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?<\/div><input type='hidden' name='question_id[]' id='qID_14' value='234198' \/><input type='hidden' id='answerType234198' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234198[]' id='answer-id-929844' class='answer   answerof-234198 ' value='929844'   \/><label for='answer-id-929844' id='answer-label-929844' class=' answer'><span>norowcount nocolcount<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234198[]' id='answer-id-929845' class='answer   answerof-234198 ' value='929845'   \/><label for='answer-id-929845' id='answer-label-929845' class=' answer'><span>freq percent<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234198[]' id='answer-id-929846' class='answer   answerof-234198 ' value='929846'   \/><label for='answer-id-929846' id='answer-label-929846' class=' answer'><span>norow nocol<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234198[]' id='answer-id-929847' class='answer   answerof-234198 ' value='929847'   \/><label for='answer-id-929847' id='answer-label-929847' class=' answer'><span>nocounts<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-15' style=';'><div id='questionWrap-15'  class='   watupro-question-id-234199'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>15. <\/span>The following program is submitted: <br \/>\r<br>proc sort data=SASUSER.PROJECTS out=PSORT; <br \/>\r<br>by Code descending Date Cost; <br \/>\r<br>run; <br \/>\r<br>Which of the following is true concerning the submitted program?<\/div><input type='hidden' name='question_id[]' id='qID_15' value='234199' \/><input type='hidden' id='answerType234199' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234199[]' id='answer-id-929848' class='answer   answerof-234199 ' value='929848'   \/><label for='answer-id-929848' id='answer-label-929848' class=' answer'><span>The descending option applies to the variable Code.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234199[]' id='answer-id-929849' class='answer   answerof-234199 ' value='929849'   \/><label for='answer-id-929849' id='answer-label-929849' class=' answer'><span>The variable Code is sorted by ascending order.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234199[]' id='answer-id-929850' class='answer   answerof-234199 ' value='929850'   \/><label for='answer-id-929850' id='answer-label-929850' class=' answer'><span>The PSORT data set is stored in the SASUSER library.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234199[]' id='answer-id-929851' class='answer   answerof-234199 ' value='929851'   \/><label for='answer-id-929851' id='answer-label-929851' class=' answer'><span>The descending option applies to the Date and Cost variables.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-16' style=';'><div id='questionWrap-16'  class='   watupro-question-id-234200'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>16. <\/span>Which statement describes a characteristic of the SAS automatic variable _ERROR_?<\/div><input type='hidden' name='question_id[]' id='qID_16' value='234200' \/><input type='hidden' id='answerType234200' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234200[]' id='answer-id-929852' class='answer   answerof-234200 ' value='929852'   \/><label for='answer-id-929852' id='answer-label-929852' class=' answer'><span>The _ERROR_ variable maintains a count of the number of data errors in a DATA step.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234200[]' id='answer-id-929853' class='answer   answerof-234200 ' value='929853'   \/><label for='answer-id-929853' id='answer-label-929853' class=' answer'><span>The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234200[]' id='answer-id-929854' class='answer   answerof-234200 ' value='929854'   \/><label for='answer-id-929854' id='answer-label-929854' class=' answer'><span>The _ERROR_ variable can be used in expressions in the DATA step.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234200[]' id='answer-id-929855' class='answer   answerof-234200 ' value='929855'   \/><label for='answer-id-929855' id='answer-label-929855' class=' answer'><span>The _ERROR_ variable contains the number of the observation that caused the data error.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-17' style=';'><div id='questionWrap-17'  class='   watupro-question-id-234201'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>17. <\/span>Given the raw data file EMPLOYEE: <br \/>\r<br>----I----1 0---I----20---I----30 <br \/>\r<br>Ruth 39 11 <br \/>\r<br>Jose 32 22 <br \/>\r<br>Sue 30 33 <br \/>\r<br>John 40 44 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data test; <br \/>\r<br>infile \u2018employee\u2019; <br \/>\r<br>input employee_name $ 1-4; <br \/>\r<br>if employee_name = \u2018Ruth\u2019 then input idnum 10-11; <br \/>\r<br>else input age 7-8; <br \/>\r<br>run; <br \/>\r<br>What value does the variable IDNUM contain when the name of the employee is \u201cRuth\u201d?<\/div><input type='hidden' name='question_id[]' id='qID_17' value='234201' \/><input type='hidden' id='answerType234201' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234201[]' id='answer-id-929856' class='answer   answerof-234201 ' value='929856'   \/><label for='answer-id-929856' id='answer-label-929856' class=' answer'><span>11<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234201[]' id='answer-id-929857' class='answer   answerof-234201 ' value='929857'   \/><label for='answer-id-929857' id='answer-label-929857' class=' answer'><span>22<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234201[]' id='answer-id-929858' class='answer   answerof-234201 ' value='929858'   \/><label for='answer-id-929858' id='answer-label-929858' class=' answer'><span>33<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234201[]' id='answer-id-929859' class='answer   answerof-234201 ' value='929859'   \/><label for='answer-id-929859' id='answer-label-929859' class=' answer'><span>(missing numeric value)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-18' style=';'><div id='questionWrap-18'  class='   watupro-question-id-234202'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>18. <\/span>Given the SAS data set WORK.TEMPS: <br \/>\r<br><br><img decoding=\"async\" width=113 height=91 id=\"\u56fe\u7247 149\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image006-44.jpg\"><br><br \/>\r<br>The following program is submitted: <br \/>\r<br><br><img decoding=\"async\" width=187 height=68 id=\"\u56fe\u7247 151\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image007-37.jpg\"><br><br \/>\r<br>Which output is correct? <br \/>\r<br><br><img decoding=\"async\" width=199 height=566 id=\"\u56fe\u7247 153\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image008-36.jpg\"><br><\/div><input type='hidden' name='question_id[]' id='qID_18' value='234202' \/><input type='hidden' id='answerType234202' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234202[]' id='answer-id-929860' class='answer   answerof-234202 ' value='929860'   \/><label for='answer-id-929860' id='answer-label-929860' class=' answer'><span>Option A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234202[]' id='answer-id-929861' class='answer   answerof-234202 ' value='929861'   \/><label for='answer-id-929861' id='answer-label-929861' class=' answer'><span>Option B<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234202[]' id='answer-id-929862' class='answer   answerof-234202 ' value='929862'   \/><label for='answer-id-929862' id='answer-label-929862' class=' answer'><span>Option C<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234202[]' id='answer-id-929863' class='answer   answerof-234202 ' value='929863'   \/><label for='answer-id-929863' id='answer-label-929863' class=' answer'><span>Option D<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-19' style=';'><div id='questionWrap-19'  class='   watupro-question-id-234203'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>19. <\/span>The following SAS program is submitted: <br \/>\r<br>data work.retail; <br \/>\r<br>cost = \u201820000\u2019; <br \/>\r<br>total= .10* cost <br \/>\r<br>run; <br \/>\r<br>What is the result?<\/div><input type='hidden' name='question_id[]' id='qID_19' value='234203' \/><input type='hidden' id='answerType234203' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234203[]' id='answer-id-929864' class='answer   answerof-234203 ' value='929864'   \/><label for='answer-id-929864' id='answer-label-929864' class=' answer'><span>The value of the variable TOTAL in the output data set is 2000. \r\nNo messages are written to the SAS log.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234203[]' id='answer-id-929865' class='answer   answerof-234203 ' value='929865'   \/><label for='answer-id-929865' id='answer-label-929865' class=' answer'><span>The value of the variable TOTAL in the output data set is 2000. \r\nA note that conversion has taken place is written to the SAS log.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234203[]' id='answer-id-929866' class='answer   answerof-234203 ' value='929866'   \/><label for='answer-id-929866' id='answer-label-929866' class=' answer'><span>The value of the variable TOTAL in the output data set is missing. \r\nAn error message is written to the SAS log.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234203[]' id='answer-id-929867' class='answer   answerof-234203 ' value='929867'   \/><label for='answer-id-929867' id='answer-label-929867' class=' answer'><span>The variable TOTAL in the output data set has no value. \r\nThe program fails to execute due to a syntax error.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-20' style=';'><div id='questionWrap-20'  class='   watupro-question-id-234204'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>20. <\/span>A user-defined format has been created using the FORMAT procedure. Where is it stored?<\/div><input type='hidden' name='question_id[]' id='qID_20' value='234204' \/><input type='hidden' id='answerType234204' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234204[]' id='answer-id-929868' class='answer   answerof-234204 ' value='929868'   \/><label for='answer-id-929868' id='answer-label-929868' class=' answer'><span>in a SAS catalog<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234204[]' id='answer-id-929869' class='answer   answerof-234204 ' value='929869'   \/><label for='answer-id-929869' id='answer-label-929869' class=' answer'><span>in an external binary file<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234204[]' id='answer-id-929870' class='answer   answerof-234204 ' value='929870'   \/><label for='answer-id-929870' id='answer-label-929870' class=' answer'><span>in a SAS dataset in the WORK library<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234204[]' id='answer-id-929871' class='answer   answerof-234204 ' value='929871'   \/><label for='answer-id-929871' id='answer-label-929871' class=' answer'><span>in a SAS dataset in a permanent SAS data library<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-21' style=';'><div id='questionWrap-21'  class='   watupro-question-id-234205'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>21. <\/span>The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char: <br \/>\r<br>WORK.ONE <br \/>\r<br>Num Char <br \/>\r<br>------ ------ <br \/>\r<br>1 23 <br \/>\r<br>3 23 <br \/>\r<br>1 77 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>proc print data=WORK.ONE; <br \/>\r<br>where Num='1'; <br \/>\r<br>run; <br \/>\r<br>What is output?<\/div><input type='hidden' name='question_id[]' id='qID_21' value='234205' \/><input type='hidden' id='answerType234205' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234205[]' id='answer-id-929872' class='answer   answerof-234205 ' value='929872'   \/><label for='answer-id-929872' id='answer-label-929872' class=' answer'><span>Num Char--- ---- 1 23<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234205[]' id='answer-id-929873' class='answer   answerof-234205 ' value='929873'   \/><label for='answer-id-929873' id='answer-label-929873' class=' answer'><span>Num Char--- ---- 1 231 77<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234205[]' id='answer-id-929874' class='answer   answerof-234205 ' value='929874'   \/><label for='answer-id-929874' id='answer-label-929874' class=' answer'><span>Num Char--- ---- 1 233 231 77<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234205[]' id='answer-id-929875' class='answer   answerof-234205 ' value='929875'   \/><label for='answer-id-929875' id='answer-label-929875' class=' answer'><span>No output is generated.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-22' style=';'><div id='questionWrap-22'  class='   watupro-question-id-234206'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>22. <\/span>The following SAS program is submitted: <br \/>\r<br>data temp.x; <br \/>\r<br>set sasuser.y; <br \/>\r<br>run; <br \/>\r<br>What must be submitted prior to this SAS program for the program to execute successfully?<\/div><input type='hidden' name='question_id[]' id='qID_22' value='234206' \/><input type='hidden' id='answerType234206' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234206[]' id='answer-id-929876' class='answer   answerof-234206 ' value='929876'   \/><label for='answer-id-929876' id='answer-label-929876' class=' answer'><span>A LIBNAME statement for the libref TEMP only must be submitted.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234206[]' id='answer-id-929877' class='answer   answerof-234206 ' value='929877'   \/><label for='answer-id-929877' id='answer-label-929877' class=' answer'><span>A LIBNAME statement for the libref SASUSER only must be submitted.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234206[]' id='answer-id-929878' class='answer   answerof-234206 ' value='929878'   \/><label for='answer-id-929878' id='answer-label-929878' class=' answer'><span>LIBNAME statements for the librefs TEMP and SASUSER must be submitted.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234206[]' id='answer-id-929879' class='answer   answerof-234206 ' value='929879'   \/><label for='answer-id-929879' id='answer-label-929879' class=' answer'><span>No LIBNAME statement needs to be submitted.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-23' style=';'><div id='questionWrap-23'  class='   watupro-question-id-234207'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>23. <\/span>The value 110700 is stored in a numeric variable named SALARY. <br \/>\r<br>Which FORMAT statement displays the value as $110,700.00 in a report?<\/div><input type='hidden' name='question_id[]' id='qID_23' value='234207' \/><input type='hidden' id='answerType234207' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234207[]' id='answer-id-929880' class='answer   answerof-234207 ' value='929880'   \/><label for='answer-id-929880' id='answer-label-929880' class=' answer'><span>format salary comma11.2;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234207[]' id='answer-id-929881' class='answer   answerof-234207 ' value='929881'   \/><label for='answer-id-929881' id='answer-label-929881' class=' answer'><span>format salary dollar8.2;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234207[]' id='answer-id-929882' class='answer   answerof-234207 ' value='929882'   \/><label for='answer-id-929882' id='answer-label-929882' class=' answer'><span>format salary dollar11.2;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234207[]' id='answer-id-929883' class='answer   answerof-234207 ' value='929883'   \/><label for='answer-id-929883' id='answer-label-929883' class=' answer'><span>format salary comma8.2 dollar8.2;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-24' style=';'><div id='questionWrap-24'  class='   watupro-question-id-234208'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>24. <\/span>The following SAS program is submitted: <br \/>\r<br>proc format <br \/>\r<br>value score 1 - 50 = \u2018Fail\u2019 <br \/>\r<br>51 - 100 = \u2018Pass\u2019; <br \/>\r<br>run; <br \/>\r<br>proc report data = work.courses nowd; <br \/>\r<br>column exam; <br \/>\r<br>define exam \/ display format = score.; <br \/>\r<br>run; <br \/>\r<br>The variable EXAM has a value of 50.5. <br \/>\r<br>How will the EXAM variable value be displayed in the REPORT procedure output?<\/div><input type='hidden' name='question_id[]' id='qID_24' value='234208' \/><input type='hidden' id='answerType234208' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234208[]' id='answer-id-929884' class='answer   answerof-234208 ' value='929884'   \/><label for='answer-id-929884' id='answer-label-929884' class=' answer'><span>Fail<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234208[]' id='answer-id-929885' class='answer   answerof-234208 ' value='929885'   \/><label for='answer-id-929885' id='answer-label-929885' class=' answer'><span>Pass<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234208[]' id='answer-id-929886' class='answer   answerof-234208 ' value='929886'   \/><label for='answer-id-929886' id='answer-label-929886' class=' answer'><span>50.5<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234208[]' id='answer-id-929887' class='answer   answerof-234208 ' value='929887'   \/><label for='answer-id-929887' id='answer-label-929887' class=' answer'><span>. (missing numeric value)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-25' style=';'><div id='questionWrap-25'  class='   watupro-question-id-234209'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>25. <\/span>The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted: <br \/>\r<br><br><img decoding=\"async\" width=362 height=80 id=\"\u56fe\u7247 155\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image009-33.jpg\"><br><br \/>\r<br>Which statement is true?<\/div><input type='hidden' name='question_id[]' id='qID_25' value='234209' \/><input type='hidden' id='answerType234209' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234209[]' id='answer-id-929888' class='answer   answerof-234209 ' value='929888'   \/><label for='answer-id-929888' id='answer-label-929888' class=' answer'><span>The by statement in the DATA step causes a syntax error.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234209[]' id='answer-id-929889' class='answer   answerof-234209 ' value='929889'   \/><label for='answer-id-929889' id='answer-label-929889' class=' answer'><span>The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234209[]' id='answer-id-929890' class='answer   answerof-234209 ' value='929890'   \/><label for='answer-id-929890' id='answer-label-929890' class=' answer'><span>The values of the variable Payroll represent the monthly total for each department in the WOR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234209[]' id='answer-id-929891' class='answer   answerof-234209 ' value='929891'   \/><label for='answer-id-929891' id='answer-label-929891' class=' answer'><span>SALARY data set.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234209[]' id='answer-id-929892' class='answer   answerof-234209 ' value='929892'   \/><label for='answer-id-929892' id='answer-label-929892' class=' answer'><span>The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WOR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234209[]' id='answer-id-929893' class='answer   answerof-234209 ' value='929893'   \/><label for='answer-id-929893' id='answer-label-929893' class=' answer'><span>SALARY data set.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-26' style=';'><div id='questionWrap-26'  class='   watupro-question-id-234210'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>26. <\/span>Given the following raw data record: <br \/>\r<br>07Jan2005 <br \/>\r<br>Which INFORMAT reads this raw data and stores it as a SAS date value?<\/div><input type='hidden' name='question_id[]' id='qID_26' value='234210' \/><input type='hidden' id='answerType234210' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234210[]' id='answer-id-929894' class='answer   answerof-234210 ' value='929894'   \/><label for='answer-id-929894' id='answer-label-929894' class=' answer'><span>dmy9.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234210[]' id='answer-id-929895' class='answer   answerof-234210 ' value='929895'   \/><label for='answer-id-929895' id='answer-label-929895' class=' answer'><span>date9.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234210[]' id='answer-id-929896' class='answer   answerof-234210 ' value='929896'   \/><label for='answer-id-929896' id='answer-label-929896' class=' answer'><span>ddMMMyy9.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234210[]' id='answer-id-929897' class='answer   answerof-234210 ' value='929897'   \/><label for='answer-id-929897' id='answer-label-929897' class=' answer'><span>ddmmmyyyy9.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-27' style=';'><div id='questionWrap-27'  class='   watupro-question-id-234211'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>27. <\/span>The following SAS program is submitted: <br \/>\r<br>data work.passengers; <br \/>\r<br>if OrigPassengers = . then' <br \/>\r<br>OrigPassengers = 100; <br \/>\r<br>TransPassengers = 100; <br \/>\r<br>OrigPassengers = .; <br \/>\r<br>TotalPassengers = sum (OrigPassengers, TransPassengers) +0; <br \/>\r<br>run; <br \/>\r<br>What is the value of the TOTALPASSENGERS variable in the output data set?<\/div><input type='hidden' name='question_id[]' id='qID_27' value='234211' \/><input type='hidden' id='answerType234211' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234211[]' id='answer-id-929898' class='answer   answerof-234211 ' value='929898'   \/><label for='answer-id-929898' id='answer-label-929898' class=' answer'><span>0<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234211[]' id='answer-id-929899' class='answer   answerof-234211 ' value='929899'   \/><label for='answer-id-929899' id='answer-label-929899' class=' answer'><span>100<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234211[]' id='answer-id-929900' class='answer   answerof-234211 ' value='929900'   \/><label for='answer-id-929900' id='answer-label-929900' class=' answer'><span>200<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234211[]' id='answer-id-929901' class='answer   answerof-234211 ' value='929901'   \/><label for='answer-id-929901' id='answer-label-929901' class=' answer'><span>(missing numeric value)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-28' style=';'><div id='questionWrap-28'  class='   watupro-question-id-234212'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>28. <\/span>The following SAS program is submitted; <br \/>\r<br>data combine; <br \/>\r<br>country = \u2018Italy, Russia, ireland\u2019; <br \/>\r<br>found = find(country, \u2018i\u2019); <br \/>\r<br>run; <br \/>\r<br>What is the value of the variable FOUND in the output data set?<\/div><input type='hidden' name='question_id[]' id='qID_28' value='234212' \/><input type='hidden' id='answerType234212' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234212[]' id='answer-id-929902' class='answer   answerof-234212 ' value='929902'   \/><label for='answer-id-929902' id='answer-label-929902' class=' answer'><span>1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234212[]' id='answer-id-929903' class='answer   answerof-234212 ' value='929903'   \/><label for='answer-id-929903' id='answer-label-929903' class=' answer'><span>12<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234212[]' id='answer-id-929904' class='answer   answerof-234212 ' value='929904'   \/><label for='answer-id-929904' id='answer-label-929904' class=' answer'><span>Italy<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234212[]' id='answer-id-929905' class='answer   answerof-234212 ' value='929905'   \/><label for='answer-id-929905' id='answer-label-929905' class=' answer'><span>Russia<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-29' style=';'><div id='questionWrap-29'  class='   watupro-question-id-234213'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>29. <\/span>Given the SAS data set SASDATA TWO: <br \/>\r<br>SASDATA TWO <br \/>\r<br>XY <br \/>\r<br>52 <br \/>\r<br>31 <br \/>\r<br>56 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data sasuser.one two sasdata.three; <br \/>\r<br>set sasdata two; <br \/>\r<br>if x = 5 then output sasuser.one; <br \/>\r<br>else output sasdata two; <br \/>\r<br>run; <br \/>\r<br>What is the result?<\/div><input type='hidden' name='question_id[]' id='qID_29' value='234213' \/><input type='hidden' id='answerType234213' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929906' class='answer   answerof-234213 ' value='929906'   \/><label for='answer-id-929906' id='answer-label-929906' class=' answer'><span>data set SASUSE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929907' class='answer   answerof-234213 ' value='929907'   \/><label for='answer-id-929907' id='answer-label-929907' class=' answer'><span>ONE has 5 observationsdata set SASUSE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929908' class='answer   answerof-234213 ' value='929908'   \/><label for='answer-id-929908' id='answer-label-929908' class=' answer'><span>TWO has 5 observationsdata set WOR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929909' class='answer   answerof-234213 ' value='929909'   \/><label for='answer-id-929909' id='answer-label-929909' class=' answer'><span>OTHER has 3 observations<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929910' class='answer   answerof-234213 ' value='929910'   \/><label for='answer-id-929910' id='answer-label-929910' class=' answer'><span>data set SASUSE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929911' class='answer   answerof-234213 ' value='929911'   \/><label for='answer-id-929911' id='answer-label-929911' class=' answer'><span>ONE has 2 observationsdata set SASUSE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929912' class='answer   answerof-234213 ' value='929912'   \/><label for='answer-id-929912' id='answer-label-929912' class=' answer'><span>TWO has 2 observationsdata set WOR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929913' class='answer   answerof-234213 ' value='929913'   \/><label for='answer-id-929913' id='answer-label-929913' class=' answer'><span>OTHER has 1 observations<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929914' class='answer   answerof-234213 ' value='929914'   \/><label for='answer-id-929914' id='answer-label-929914' class=' answer'><span>data set SASUSE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929915' class='answer   answerof-234213 ' value='929915'   \/><label for='answer-id-929915' id='answer-label-929915' class=' answer'><span>ONE has 2 observationsdata set SASUSE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929916' class='answer   answerof-234213 ' value='929916'   \/><label for='answer-id-929916' id='answer-label-929916' class=' answer'><span>TWO has 2 observationsdata set WOR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929917' class='answer   answerof-234213 ' value='929917'   \/><label for='answer-id-929917' id='answer-label-929917' class=' answer'><span>OTHER has 5 observations<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234213[]' id='answer-id-929918' class='answer   answerof-234213 ' value='929918'   \/><label for='answer-id-929918' id='answer-label-929918' class=' answer'><span>No data sets are output.The DATA step fails execution due to syntax errors.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-30' style=';'><div id='questionWrap-30'  class='   watupro-question-id-234214'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>30. <\/span>The following SAS program is submitted: <br \/>\r<br>proc sort data = work.employee; <br \/>\r<br>by descending fname; <br \/>\r<br>proc sort data = work.salary; <br \/>\r<br>by descending fname; <br \/>\r<br>data work.empdata; <br \/>\r<br>merge work.employee <br \/>\r<br>work.salary; <br \/>\r<br>by fname; <br \/>\r<br>run; <br \/>\r<br>Why does the program rail to execute?<\/div><input type='hidden' name='question_id[]' id='qID_30' value='234214' \/><input type='hidden' id='answerType234214' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234214[]' id='answer-id-929919' class='answer   answerof-234214 ' value='929919'   \/><label for='answer-id-929919' id='answer-label-929919' class=' answer'><span>The SORT procedures contain invalid syntax.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234214[]' id='answer-id-929920' class='answer   answerof-234214 ' value='929920'   \/><label for='answer-id-929920' id='answer-label-929920' class=' answer'><span>The merged data sets are not permanent SAS data sets.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234214[]' id='answer-id-929921' class='answer   answerof-234214 ' value='929921'   \/><label for='answer-id-929921' id='answer-label-929921' class=' answer'><span>The RUN statement was omitted alter each or the SORT procedures.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234214[]' id='answer-id-929922' class='answer   answerof-234214 ' value='929922'   \/><label for='answer-id-929922' id='answer-label-929922' class=' answer'><span>The data sets were not merged in the order by which they were sorted.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-31' style=';'><div id='questionWrap-31'  class='   watupro-question-id-234215'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>31. <\/span>Given the raw data record in the file phone.txt: <br \/>\r<br><br><img decoding=\"async\" width=390 height=125 id=\"\u56fe\u7247 157\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image010-33.jpg\"><br><br \/>\r<br>Which SAS statement completes the program and results in a value of &quot;James Stevens&quot; for the variableFullName?<\/div><input type='hidden' name='question_id[]' id='qID_31' value='234215' \/><input type='hidden' id='answerType234215' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234215[]' id='answer-id-929923' class='answer   answerof-234215 ' value='929923'   \/><label for='answer-id-929923' id='answer-label-929923' class=' answer'><span>FullName=CATX('',EmpFName,EmpLName);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234215[]' id='answer-id-929924' class='answer   answerof-234215 ' value='929924'   \/><label for='answer-id-929924' id='answer-label-929924' class=' answer'><span>FullName=CAT('',EmpFName,EmpLName);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234215[]' id='answer-id-929925' class='answer   answerof-234215 ' value='929925'   \/><label for='answer-id-929925' id='answer-label-929925' class=' answer'><span>FullName=EmpFName!!EmpLName;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234215[]' id='answer-id-929926' class='answer   answerof-234215 ' value='929926'   \/><label for='answer-id-929926' id='answer-label-929926' class=' answer'><span>FullName=EmpFName + EmpLName;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-32' style=';'><div id='questionWrap-32'  class='   watupro-question-id-234216'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>32. <\/span>Given the SAS data set EMPLOYEES: <br \/>\r<br>EMPLOYEES <br \/>\r<br>NAME SALARY <br \/>\r<br>-------- ------------ <br \/>\r<br>Innis60000 <br \/>\r<br>Jolli50000 <br \/>\r<br>Ellis55000 <br \/>\r<br>Liu45000 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>proc print data = employees; where name like \u2018_i%\u2019; <br \/>\r<br>run; <br \/>\r<br>What is contained in the output?<\/div><input type='hidden' name='question_id[]' id='qID_32' value='234216' \/><input type='hidden' id='answerType234216' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234216[]' id='answer-id-929927' class='answer   answerof-234216 ' value='929927'   \/><label for='answer-id-929927' id='answer-label-929927' class=' answer'><span>Liu only<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234216[]' id='answer-id-929928' class='answer   answerof-234216 ' value='929928'   \/><label for='answer-id-929928' id='answer-label-929928' class=' answer'><span>Innis and Ellis only<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234216[]' id='answer-id-929929' class='answer   answerof-234216 ' value='929929'   \/><label for='answer-id-929929' id='answer-label-929929' class=' answer'><span>Innis, Ellis, and Liu only<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234216[]' id='answer-id-929930' class='answer   answerof-234216 ' value='929930'   \/><label for='answer-id-929930' id='answer-label-929930' class=' answer'><span>Innis, Jolli, Ellis, and Liu<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-33' style=';'><div id='questionWrap-33'  class='   watupro-question-id-234217'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>33. <\/span>The following SAS program is submitted: <br \/>\r<br>data one; <br \/>\r<br>addressl = \u2018214 London Way\u2019; <br \/>\r<br>run; <br \/>\r<br>data one; <br \/>\r<br>set one; <br \/>\r<br>address = tranwrd(address1, \u2018Way\u2019, \u2018Drive\u2019); run; <br \/>\r<br>What are the length and value of the variable ADDRESS?<\/div><input type='hidden' name='question_id[]' id='qID_33' value='234217' \/><input type='hidden' id='answerType234217' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234217[]' id='answer-id-929931' class='answer   answerof-234217 ' value='929931'   \/><label for='answer-id-929931' id='answer-label-929931' class=' answer'><span>Length is 14; value is \u2018214 London Dri\u2019.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234217[]' id='answer-id-929932' class='answer   answerof-234217 ' value='929932'   \/><label for='answer-id-929932' id='answer-label-929932' class=' answer'><span>Length is 14; value is \u2018214 London Way\u2019.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234217[]' id='answer-id-929933' class='answer   answerof-234217 ' value='929933'   \/><label for='answer-id-929933' id='answer-label-929933' class=' answer'><span>Length is 16; value is \u2018214 London Drive\u2019.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234217[]' id='answer-id-929934' class='answer   answerof-234217 ' value='929934'   \/><label for='answer-id-929934' id='answer-label-929934' class=' answer'><span>Length is 200; value is \u2018214 London Drive\u2019.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-34' style=';'><div id='questionWrap-34'  class='   watupro-question-id-234218'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>34. <\/span>The following program is submitted: <br \/>\r<br>proc contents data=_all_; <br \/>\r<br>run; <br \/>\r<br>Which statement best describes the output from the submitted program?<\/div><input type='hidden' name='question_id[]' id='qID_34' value='234218' \/><input type='hidden' id='answerType234218' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234218[]' id='answer-id-929935' class='answer   answerof-234218 ' value='929935'   \/><label for='answer-id-929935' id='answer-label-929935' class=' answer'><span>The output contains only a list of the SAS data sets that are contained in the WORK library.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234218[]' id='answer-id-929936' class='answer   answerof-234218 ' value='929936'   \/><label for='answer-id-929936' id='answer-label-929936' class=' answer'><span>The output displays only the contents of the SAS data sets that are contained in the WORK library.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234218[]' id='answer-id-929937' class='answer   answerof-234218 ' value='929937'   \/><label for='answer-id-929937' id='answer-label-929937' class=' answer'><span>The output displays only the variables in the SAS data sets that are contained in the WORK library.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234218[]' id='answer-id-929938' class='answer   answerof-234218 ' value='929938'   \/><label for='answer-id-929938' id='answer-label-929938' class=' answer'><span>The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-35' style=';'><div id='questionWrap-35'  class='   watupro-question-id-234219'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>35. <\/span>Which program displays a listing of all data sets in the SASUSER library?<\/div><input type='hidden' name='question_id[]' id='qID_35' value='234219' \/><input type='hidden' id='answerType234219' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234219[]' id='answer-id-929939' class='answer   answerof-234219 ' value='929939'   \/><label for='answer-id-929939' id='answer-label-929939' class=' answer'><span>proc contents lib = sasuser.all; run;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234219[]' id='answer-id-929940' class='answer   answerof-234219 ' value='929940'   \/><label for='answer-id-929940' id='answer-label-929940' class=' answer'><span>proc contents data = sasuser.all; run;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234219[]' id='answer-id-929941' class='answer   answerof-234219 ' value='929941'   \/><label for='answer-id-929941' id='answer-label-929941' class=' answer'><span>proc contents lib = sasuser._alI_; run;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234219[]' id='answer-id-929942' class='answer   answerof-234219 ' value='929942'   \/><label for='answer-id-929942' id='answer-label-929942' class=' answer'><span>proc contents data = sasuser._all_; run;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-36' style=';'><div id='questionWrap-36'  class='   watupro-question-id-234220'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>36. <\/span>Given the SAS data set WORK.EMP_NAME: <br \/>\r<br><br><img decoding=\"async\" width=80 height=67 id=\"\u56fe\u7247 159\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image011-30.jpg\"><br><br \/>\r<br>Given the SAS data set WORK.EMP_DEPT: <br \/>\r<br><br><img decoding=\"async\" width=120 height=68 id=\"\u56fe\u7247 161\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image012-31.jpg\"><br><br \/>\r<br>The following program is submitted: <br \/>\r<br><br><img decoding=\"async\" width=370 height=67 id=\"\u56fe\u7247 163\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image013-30.jpg\"><br><br \/>\r<br>How many observations are in data set WORK.ALL after submitting the program?<\/div><input type='hidden' name='question_id[]' id='qID_36' value='234220' \/><input type='hidden' id='answerType234220' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234220[]' id='answer-id-929943' class='answer   answerof-234220 ' value='929943'   \/><label for='answer-id-929943' id='answer-label-929943' class=' answer'><span>1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234220[]' id='answer-id-929944' class='answer   answerof-234220 ' value='929944'   \/><label for='answer-id-929944' id='answer-label-929944' class=' answer'><span>2<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234220[]' id='answer-id-929945' class='answer   answerof-234220 ' value='929945'   \/><label for='answer-id-929945' id='answer-label-929945' class=' answer'><span>3<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234220[]' id='answer-id-929946' class='answer   answerof-234220 ' value='929946'   \/><label for='answer-id-929946' id='answer-label-929946' class=' answer'><span>5<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-37' style=';'><div id='questionWrap-37'  class='   watupro-question-id-234221'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>37. <\/span>The following SAS program is submitted: <br \/>\r<br>data test; <br \/>\r<br>infile \u2018file specification\u2019; <br \/>\r<br>input name $ amount@@; <br \/>\r<br>run; <br \/>\r<br>Which of the following is true?<\/div><input type='hidden' name='question_id[]' id='qID_37' value='234221' \/><input type='hidden' id='answerType234221' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234221[]' id='answer-id-929947' class='answer   answerof-234221 ' value='929947'   \/><label for='answer-id-929947' id='answer-label-929947' class=' answer'><span>Two @@ together are the same as one c.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234221[]' id='answer-id-929948' class='answer   answerof-234221 ' value='929948'   \/><label for='answer-id-929948' id='answer-label-929948' class=' answer'><span>Two @@ hold the data records until the bottom of the DATA step.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234221[]' id='answer-id-929949' class='answer   answerof-234221 ' value='929949'   \/><label for='answer-id-929949' id='answer-label-929949' class=' answer'><span>Two @@ hold the raw data record across iterations of the DATA step.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234221[]' id='answer-id-929950' class='answer   answerof-234221 ' value='929950'   \/><label for='answer-id-929950' id='answer-label-929950' class=' answer'><span>Two @@ are invalid syntax and will cause the program to fail to execute.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-38' style=';'><div id='questionWrap-38'  class='   watupro-question-id-234222'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>38. <\/span>Which statement correctly computes the average of four numerical values?<\/div><input type='hidden' name='question_id[]' id='qID_38' value='234222' \/><input type='hidden' id='answerType234222' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234222[]' id='answer-id-929951' class='answer   answerof-234222 ' value='929951'   \/><label for='answer-id-929951' id='answer-label-929951' class=' answer'><span>average = mean(num1, num4);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234222[]' id='answer-id-929952' class='answer   answerof-234222 ' value='929952'   \/><label for='answer-id-929952' id='answer-label-929952' class=' answer'><span>average = mean(num1 - num4);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234222[]' id='answer-id-929953' class='answer   answerof-234222 ' value='929953'   \/><label for='answer-id-929953' id='answer-label-929953' class=' answer'><span>average = mean(ofnum1 - num4)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234222[]' id='answer-id-929954' class='answer   answerof-234222 ' value='929954'   \/><label for='answer-id-929954' id='answer-label-929954' class=' answer'><span>average = mean(num1 num2 num3 num4);<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-39' style=';'><div id='questionWrap-39'  class='   watupro-question-id-234223'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>39. <\/span>The following SAS program is submitted: <br \/>\r<br><br><img decoding=\"async\" width=307 height=59 id=\"\u56fe\u7247 165\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image014-30.jpg\"><br><br \/>\r<br>What new variables are created?<\/div><input type='hidden' name='question_id[]' id='qID_39' value='234223' \/><input type='hidden' id='answerType234223' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234223[]' id='answer-id-929955' class='answer   answerof-234223 ' value='929955'   \/><label for='answer-id-929955' id='answer-label-929955' class=' answer'><span>Difcount1, Difcount2 and Difcount3<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234223[]' id='answer-id-929956' class='answer   answerof-234223 ' value='929956'   \/><label for='answer-id-929956' id='answer-label-929956' class=' answer'><span>Diff1, Diff2 and Diff3<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234223[]' id='answer-id-929957' class='answer   answerof-234223 ' value='929957'   \/><label for='answer-id-929957' id='answer-label-929957' class=' answer'><span>Janpt, Febpt, and Marpt<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234223[]' id='answer-id-929958' class='answer   answerof-234223 ' value='929958'   \/><label for='answer-id-929958' id='answer-label-929958' class=' answer'><span>Patients1, Patients2 and Patients3<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-40' style=';'><div id='questionWrap-40'  class='   watupro-question-id-234224'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>40. <\/span>Given the SAS data set ONE: <br \/>\r<br>ONE <br \/>\r<br>ObsDte <br \/>\r<br>------------- <br \/>\r<br>109JAN2005 <br \/>\r<br>212JAN2005 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data two; <br \/>\r<br>set one; <br \/>\r<br>day = &lt;insert expression here&gt;; <br \/>\r<br>format dte date9.; <br \/>\r<br>run; <br \/>\r<br>The data set TWO is created: <br \/>\r<br>TWO <br \/>\r<br>ObsDteDay <br \/>\r<br>109JAN20051 <br \/>\r<br>12JAN20054 <br \/>\r<br>Which expression successfully completed the program and created the variable DAY?<\/div><input type='hidden' name='question_id[]' id='qID_40' value='234224' \/><input type='hidden' id='answerType234224' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234224[]' id='answer-id-929959' class='answer   answerof-234224 ' value='929959'   \/><label for='answer-id-929959' id='answer-label-929959' class=' answer'><span>day(dte)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234224[]' id='answer-id-929960' class='answer   answerof-234224 ' value='929960'   \/><label for='answer-id-929960' id='answer-label-929960' class=' answer'><span>weekday(dte)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234224[]' id='answer-id-929961' class='answer   answerof-234224 ' value='929961'   \/><label for='answer-id-929961' id='answer-label-929961' class=' answer'><span>dayofweek(dte)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234224[]' id='answer-id-929962' class='answer   answerof-234224 ' value='929962'   \/><label for='answer-id-929962' id='answer-label-929962' class=' answer'><span>datdif(dte,\u201901jan2005\u2019d,\u2019act\/act\u2019)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-41' style=';'><div id='questionWrap-41'  class='   watupro-question-id-234225'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>41. <\/span>The following SAS program is submitted: <br \/>\r<br>data WORK.ACCOUNTING; <br \/>\r<br>set WORK.DEPARTMENT; <br \/>\r<br>label Jobcode='Job Description'; <br \/>\r<br>run; <br \/>\r<br>Which statement is true about the output dataset?<\/div><input type='hidden' name='question_id[]' id='qID_41' value='234225' \/><input type='hidden' id='answerType234225' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234225[]' id='answer-id-929963' class='answer   answerof-234225 ' value='929963'   \/><label for='answer-id-929963' id='answer-label-929963' class=' answer'><span>The label of the variable Jobcode is Job (only the first word).<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234225[]' id='answer-id-929964' class='answer   answerof-234225 ' value='929964'   \/><label for='answer-id-929964' id='answer-label-929964' class=' answer'><span>The label of the variable Jobcode is Job Desc (only the first 8 characters).<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234225[]' id='answer-id-929965' class='answer   answerof-234225 ' value='929965'   \/><label for='answer-id-929965' id='answer-label-929965' class=' answer'><span>The label of the variable Jobcode is Job Description.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234225[]' id='answer-id-929966' class='answer   answerof-234225 ' value='929966'   \/><label for='answer-id-929966' id='answer-label-929966' class=' answer'><span>The program fails to execute due to errors. Labels must be defined in a PROC step.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-42' style=';'><div id='questionWrap-42'  class='   watupro-question-id-234226'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>42. <\/span>The following SAS program is submitted: <br \/>\r<br>data work.empsalary; <br \/>\r<br>set work.people (in = inemp) <br \/>\r<br>work.money (in = insal); <br \/>\r<br>if insal and inemp; <br \/>\r<br>run; <br \/>\r<br>The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. <br \/>\r<br>How many observations will the data set WORK.EMPSALARY contain?<\/div><input type='hidden' name='question_id[]' id='qID_42' value='234226' \/><input type='hidden' id='answerType234226' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234226[]' id='answer-id-929967' class='answer   answerof-234226 ' value='929967'   \/><label for='answer-id-929967' id='answer-label-929967' class=' answer'><span>0<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234226[]' id='answer-id-929968' class='answer   answerof-234226 ' value='929968'   \/><label for='answer-id-929968' id='answer-label-929968' class=' answer'><span>5<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234226[]' id='answer-id-929969' class='answer   answerof-234226 ' value='929969'   \/><label for='answer-id-929969' id='answer-label-929969' class=' answer'><span>7<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234226[]' id='answer-id-929970' class='answer   answerof-234226 ' value='929970'   \/><label for='answer-id-929970' id='answer-label-929970' class=' answer'><span>12<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-43' style=';'><div id='questionWrap-43'  class='   watupro-question-id-234227'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>43. <\/span>1941 1 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data coins; <br \/>\r<br>infile \u2018yearamt\u2019; <br \/>\r<br>input year quantity; <br \/>\r<br>&lt;insert statement(s) here&gt; <br \/>\r<br>run; <br \/>\r<br>Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?<\/div><input type='hidden' name='question_id[]' id='qID_43' value='234227' \/><input type='hidden' id='answerType234227' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234227[]' id='answer-id-929971' class='answer   answerof-234227 ' value='929971'   \/><label for='answer-id-929971' id='answer-label-929971' class=' answer'><span>totquantity + quantity;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234227[]' id='answer-id-929972' class='answer   answerof-234227 ' value='929972'   \/><label for='answer-id-929972' id='answer-label-929972' class=' answer'><span>totquantity = sum(totquantity + quantity);<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234227[]' id='answer-id-929973' class='answer   answerof-234227 ' value='929973'   \/><label for='answer-id-929973' id='answer-label-929973' class=' answer'><span>retain totquantity; totquantity = totquantity + quantity;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234227[]' id='answer-id-929974' class='answer   answerof-234227 ' value='929974'   \/><label for='answer-id-929974' id='answer-label-929974' class=' answer'><span>retain totquantity0; totquantity = totquantity + quantity;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-44' style=';'><div id='questionWrap-44'  class='   watupro-question-id-234228'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>44. <\/span>The following SAS program is submitted: <br \/>\r<br>libname temp \u2018SAS data library\u2019; <br \/>\r<br>data temp.sales; <br \/>\r<br>merge temp.sales <br \/>\r<br>work.receipt; <br \/>\r<br>by names; <br \/>\r<br>run; <br \/>\r<br>The input data files are sorted by the NAMES variable: <br \/>\r<br>What is the result?<\/div><input type='hidden' name='question_id[]' id='qID_44' value='234228' \/><input type='hidden' id='answerType234228' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234228[]' id='answer-id-929975' class='answer   answerof-234228 ' value='929975'   \/><label for='answer-id-929975' id='answer-label-929975' class=' answer'><span>The program executes successfully and a temporary SAS data set is created.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234228[]' id='answer-id-929976' class='answer   answerof-234228 ' value='929976'   \/><label for='answer-id-929976' id='answer-label-929976' class=' answer'><span>The program executes successfully and a permanent SAS data set is created.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234228[]' id='answer-id-929977' class='answer   answerof-234228 ' value='929977'   \/><label for='answer-id-929977' id='answer-label-929977' class=' answer'><span>The program fails execution because the same SAS data set is referenced for both read and write operations.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234228[]' id='answer-id-929978' class='answer   answerof-234228 ' value='929978'   \/><label for='answer-id-929978' id='answer-label-929978' class=' answer'><span>The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-45' style=';'><div id='questionWrap-45'  class='   watupro-question-id-234229'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>45. <\/span>Given the SAS data set PEPM.STUDENTS: <br \/>\r<br>PERM.STUDENTS <br \/>\r<br>NAME AGE <br \/>\r<br>Alfred 14 <br \/>\r<br>Alice13 <br \/>\r<br>Barbara13 <br \/>\r<br>Carol14 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>libname perm \u2018SAS data library\u2019; <br \/>\r<br>data students; <br \/>\r<br>set perm. Students; <br \/>\r<br>file \u2018file specification\u2019; <br \/>\r<br>put name $15. @5 age 2.; <br \/>\r<br>run; <br \/>\r<br>What is written to the output raw data file?<\/div><input type='hidden' name='question_id[]' id='qID_45' value='234229' \/><input type='hidden' id='answerType234229' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234229[]' id='answer-id-929979' class='answer   answerof-234229 ' value='929979'   \/><label for='answer-id-929979' id='answer-label-929979' class=' answer'><span>----I----10---I----20---I---- 30 \r\nAlfred 14 \r\nAlice 13 \r\nBarbara 13 \r\nCarol 14<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234229[]' id='answer-id-929980' class='answer   answerof-234229 ' value='929980'   \/><label for='answer-id-929980' id='answer-label-929980' class=' answer'><span>---- I----10---I----20---I----30 \r\nAlfr14 \r\nAlic13 \r\nBarb13a \r\nCarol 4<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234229[]' id='answer-id-929981' class='answer   answerof-234229 ' value='929981'   \/><label for='answer-id-929981' id='answer-label-929981' class=' answer'><span>----I----10---I----20---I----30 \r\nAlfr14ed \r\nAlic130 \r\nBarb13ara \r\nCaro141<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234229[]' id='answer-id-929982' class='answer   answerof-234229 ' value='929982'   \/><label for='answer-id-929982' id='answer-label-929982' class=' answer'><span>----I----10---I----20---I----30 \r\nAlfred14 \r\nAlice13 \r\nBarbara13 \r\nCarol14<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-46' style=';'><div id='questionWrap-46'  class='   watupro-question-id-234230'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>46. <\/span>00100.00 <br \/>\r<br>Total10100.00 <br \/>\r<br>Which option correctly completes the program and creates the report?<\/div><input type='hidden' name='question_id[]' id='qID_46' value='234230' \/><input type='hidden' id='answerType234230' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234230[]' id='answer-id-929983' class='answer   answerof-234230 ' value='929983'   \/><label for='answer-id-929983' id='answer-label-929983' class=' answer'><span>LIST<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234230[]' id='answer-id-929984' class='answer   answerof-234230 ' value='929984'   \/><label for='answer-id-929984' id='answer-label-929984' class=' answer'><span>NOCOLS<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234230[]' id='answer-id-929985' class='answer   answerof-234230 ' value='929985'   \/><label for='answer-id-929985' id='answer-label-929985' class=' answer'><span>CROSSLIST<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234230[]' id='answer-id-929986' class='answer   answerof-234230 ' value='929986'   \/><label for='answer-id-929986' id='answer-label-929986' class=' answer'><span>NOCROSSTAB<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-47' style=';'><div id='questionWrap-47'  class='   watupro-question-id-234231'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>47. <\/span>Given the contents of the raw data file TYPECOLOR: <br \/>\r<br>----I----10---I----20---I----30 <br \/>\r<br>Daisyyellow <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data flowers; <br \/>\r<br>infile \u2018typecolor\u2019; <br \/>\r<br>input type$ 1-5+1 color$; <br \/>\r<br>run; <br \/>\r<br>What are the values of the variables TYPE and COLOR?<\/div><input type='hidden' name='question_id[]' id='qID_47' value='234231' \/><input type='hidden' id='answerType234231' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234231[]' id='answer-id-929987' class='answer   answerof-234231 ' value='929987'   \/><label for='answer-id-929987' id='answer-label-929987' class=' answer'><span>type colordaisygreen<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234231[]' id='answer-id-929988' class='answer   answerof-234231 ' value='929988'   \/><label for='answer-id-929988' id='answer-label-929988' class=' answer'><span>type colordaisy ellow<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234231[]' id='answer-id-929989' class='answer   answerof-234231 ' value='929989'   \/><label for='answer-id-929989' id='answer-label-929989' class=' answer'><span>type colordaisyyellow\u201d \u201c(missing character value)<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234231[]' id='answer-id-929990' class='answer   answerof-234231 ' value='929990'   \/><label for='answer-id-929990' id='answer-label-929990' class=' answer'><span>No values are stored for the TYPE and COLOR variables.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-48' style=';'><div id='questionWrap-48'  class='   watupro-question-id-234232'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>48. <\/span>Given the contents of the raw data file EMPLOYEE: <br \/>\r<br>----|----10----|----20----|----30 <br \/>\r<br>Alan <br \/>\r<br>19\/2\/2004 <br \/>\r<br>ACCT <br \/>\r<br>Rob <br \/>\r<br>22\/5\/2004 <br \/>\r<br>MKTG <br \/>\r<br>MaryJane <br \/>\r<br>14\/3\/2004 <br \/>\r<br>EDUC <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data emps; <br \/>\r<br>infile \u2018employee\u2019; <br \/>\r<br>input@1 name$ <br \/>\r<br>@15 date &lt;insert INFORMAT here&gt; <br \/>\r<br>@25 department$; <br \/>\r<br>run; <br \/>\r<br>Which INFORMAT correctly completes the program?<\/div><input type='hidden' name='question_id[]' id='qID_48' value='234232' \/><input type='hidden' id='answerType234232' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234232[]' id='answer-id-929991' class='answer   answerof-234232 ' value='929991'   \/><label for='answer-id-929991' id='answer-label-929991' class=' answer'><span>date9.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234232[]' id='answer-id-929992' class='answer   answerof-234232 ' value='929992'   \/><label for='answer-id-929992' id='answer-label-929992' class=' answer'><span>ddmmyyyy9.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234232[]' id='answer-id-929993' class='answer   answerof-234232 ' value='929993'   \/><label for='answer-id-929993' id='answer-label-929993' class=' answer'><span>ddmmyy10.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234232[]' id='answer-id-929994' class='answer   answerof-234232 ' value='929994'   \/><label for='answer-id-929994' id='answer-label-929994' class=' answer'><span>ddmmyyyy10.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-49' style=';'><div id='questionWrap-49'  class='   watupro-question-id-234233'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>49. <\/span>The following SAS program is submitted: <br \/>\r<br>libname temp \u2018SAS data library\u2019; <br \/>\r<br>data work.new; <br \/>\r<br>set temp.jobs; <br \/>\r<br>format newdate mmddw10.; <br \/>\r<br>mdate = month(newdate); <br \/>\r<br>ddate = weekday(newdate); <br \/>\r<br>run; <br \/>\r<br>proc print data = work.new; run; <br \/>\r<br>The variable NEWDATE contains the SAS date value for April 15. 2005. <br \/>\r<br>What output is produced if April 15, 2005 falls on a Friday?<\/div><input type='hidden' name='question_id[]' id='qID_49' value='234233' \/><input type='hidden' id='answerType234233' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234233[]' id='answer-id-929995' class='answer   answerof-234233 ' value='929995'   \/><label for='answer-id-929995' id='answer-label-929995' class=' answer'><span>Obsnewdate mdate ddate104\/15\/2005 APR 6<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234233[]' id='answer-id-929996' class='answer   answerof-234233 ' value='929996'   \/><label for='answer-id-929996' id='answer-label-929996' class=' answer'><span>Obs newdate mdate ddate104\/15\/2005 4 6<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234233[]' id='answer-id-929997' class='answer   answerof-234233 ' value='929997'   \/><label for='answer-id-929997' id='answer-label-929997' class=' answer'><span>Obs newdate mdate ddate104\/15\/2005 APR 7<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234233[]' id='answer-id-929998' class='answer   answerof-234233 ' value='929998'   \/><label for='answer-id-929998' id='answer-label-929998' class=' answer'><span>Obs newdate mdate ddate104\/15\/2005 4 7<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-50' style=';'><div id='questionWrap-50'  class='   watupro-question-id-234234'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>50. <\/span>Given the following data step: <br \/>\r<br><br><img decoding=\"async\" width=204 height=170 id=\"\u56fe\u7247 167\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image015-30.jpg\"><br><br \/>\r<br>After data step execution, what will data set WORK.GEO contain? <br \/>\r<br><br><img decoding=\"async\" width=219 height=423 id=\"\u56fe\u7247 169\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image016-27.jpg\"><br><\/div><input type='hidden' name='question_id[]' id='qID_50' value='234234' \/><input type='hidden' id='answerType234234' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234234[]' id='answer-id-929999' class='answer   answerof-234234 ' value='929999'   \/><label for='answer-id-929999' id='answer-label-929999' class=' answer'><span>Option A<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234234[]' id='answer-id-930000' class='answer   answerof-234234 ' value='930000'   \/><label for='answer-id-930000' id='answer-label-930000' class=' answer'><span>Option B<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234234[]' id='answer-id-930001' class='answer   answerof-234234 ' value='930001'   \/><label for='answer-id-930001' id='answer-label-930001' class=' answer'><span>Option C<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234234[]' id='answer-id-930002' class='answer   answerof-234234 ' value='930002'   \/><label for='answer-id-930002' id='answer-label-930002' class=' answer'><span>Option D<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-51' style=';'><div id='questionWrap-51'  class='   watupro-question-id-234235'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>51. <\/span>Given the SAS data set AGES: <br \/>\r<br>AGES <br \/>\r<br>AGE <br \/>\r<br>--------- <br \/>\r<br>The variable AGE contains character values. The following SAS program is submitted: <br \/>\r<br>data subset; <br \/>\r<br>set ages; <br \/>\r<br>where age&gt; 12; <br \/>\r<br>run; <br \/>\r<br>How many observations are written out to the data set SUBSET?<\/div><input type='hidden' name='question_id[]' id='qID_51' value='234235' \/><input type='hidden' id='answerType234235' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234235[]' id='answer-id-930003' class='answer   answerof-234235 ' value='930003'   \/><label for='answer-id-930003' id='answer-label-930003' class=' answer'><span>0<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234235[]' id='answer-id-930004' class='answer   answerof-234235 ' value='930004'   \/><label for='answer-id-930004' id='answer-label-930004' class=' answer'><span>1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234235[]' id='answer-id-930005' class='answer   answerof-234235 ' value='930005'   \/><label for='answer-id-930005' id='answer-label-930005' class=' answer'><span>2<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234235[]' id='answer-id-930006' class='answer   answerof-234235 ' value='930006'   \/><label for='answer-id-930006' id='answer-label-930006' class=' answer'><span>3<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-52' style=';'><div id='questionWrap-52'  class='   watupro-question-id-234236'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>52. <\/span>The following SAS program is submitted: <br \/>\r<br>footnote1 \u2018Sales Report for Last Month\u2019; <br \/>\r<br>footnote2 \u2018Selected Products Only\u2019; <br \/>\r<br>footnote3 \u2018All Regions\u2019; <br \/>\r<br>footnote4 \u2018All Figures in Thousands of Dollars\u2019; proc print data = sasuser.shoes; footnote2 \u2018All Products\u2019; <br \/>\r<br>run; <br \/>\r<br>Which footnote(s) is\/are displayed in the report?<\/div><input type='hidden' name='question_id[]' id='qID_52' value='234236' \/><input type='hidden' id='answerType234236' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234236[]' id='answer-id-930007' class='answer   answerof-234236 ' value='930007'   \/><label for='answer-id-930007' id='answer-label-930007' class=' answer'><span>All Products<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234236[]' id='answer-id-930008' class='answer   answerof-234236 ' value='930008'   \/><label for='answer-id-930008' id='answer-label-930008' class=' answer'><span>Sales Report for Last Month All Products<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234236[]' id='answer-id-930009' class='answer   answerof-234236 ' value='930009'   \/><label for='answer-id-930009' id='answer-label-930009' class=' answer'><span>All Products All Regions All Figures in Thousands of Dollars<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234236[]' id='answer-id-930010' class='answer   answerof-234236 ' value='930010'   \/><label for='answer-id-930010' id='answer-label-930010' class=' answer'><span>Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-53' style=';'><div id='questionWrap-53'  class='   watupro-question-id-234237'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>53. <\/span>The following SAS program is submitted: <br \/>\r<br>Data_null_; <br \/>\r<br>set old; <br \/>\r<br>put sales 1 sales2; <br \/>\r<br>run; <br \/>\r<br>Where is the output written?<\/div><input type='hidden' name='question_id[]' id='qID_53' value='234237' \/><input type='hidden' id='answerType234237' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234237[]' id='answer-id-930011' class='answer   answerof-234237 ' value='930011'   \/><label for='answer-id-930011' id='answer-label-930011' class=' answer'><span>to the SAS log<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234237[]' id='answer-id-930012' class='answer   answerof-234237 ' value='930012'   \/><label for='answer-id-930012' id='answer-label-930012' class=' answer'><span>to the SAS data set _NULL_<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234237[]' id='answer-id-930013' class='answer   answerof-234237 ' value='930013'   \/><label for='answer-id-930013' id='answer-label-930013' class=' answer'><span>to the SAS output window or to an output file<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234237[]' id='answer-id-930014' class='answer   answerof-234237 ' value='930014'   \/><label for='answer-id-930014' id='answer-label-930014' class=' answer'><span>to the raw data file that was most recently opened<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-54' style=';'><div id='questionWrap-54'  class='   watupro-question-id-234238'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>54. <\/span>The following SAS program is submitted: <br \/>\r<br>data ONE TWO SASUSER.TWO <br \/>\r<br>set SASUSER.ONE; <br \/>\r<br>run; <br \/>\r<br>Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?<\/div><input type='hidden' name='question_id[]' id='qID_54' value='234238' \/><input type='hidden' id='answerType234238' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234238[]' id='answer-id-930015' class='answer   answerof-234238 ' value='930015'   \/><label for='answer-id-930015' id='answer-label-930015' class=' answer'><span>2 temporary and 1 permanent SAS data sets are created<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234238[]' id='answer-id-930016' class='answer   answerof-234238 ' value='930016'   \/><label for='answer-id-930016' id='answer-label-930016' class=' answer'><span>3 temporary and 2 permanent SAS data sets are created<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234238[]' id='answer-id-930017' class='answer   answerof-234238 ' value='930017'   \/><label for='answer-id-930017' id='answer-label-930017' class=' answer'><span>2 temporary and 2 permanent SAS data sets are created<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234238[]' id='answer-id-930018' class='answer   answerof-234238 ' value='930018'   \/><label for='answer-id-930018' id='answer-label-930018' class=' answer'><span>there is an error and no new data sets are created<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-55' style=';'><div id='questionWrap-55'  class='   watupro-question-id-234239'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>55. <\/span>The following SAS program is submitted: <br \/>\r<br>data work.sets; <br \/>\r<br>do until (prod gt 6); <br \/>\r<br>prod + 1; <br \/>\r<br>end; <br \/>\r<br>run; <br \/>\r<br>What is the value of the variable PROD in the output data set?<\/div><input type='hidden' name='question_id[]' id='qID_55' value='234239' \/><input type='hidden' id='answerType234239' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234239[]' id='answer-id-930019' class='answer   answerof-234239 ' value='930019'   \/><label for='answer-id-930019' id='answer-label-930019' class=' answer'><span>6<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234239[]' id='answer-id-930020' class='answer   answerof-234239 ' value='930020'   \/><label for='answer-id-930020' id='answer-label-930020' class=' answer'><span>7<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234239[]' id='answer-id-930021' class='answer   answerof-234239 ' value='930021'   \/><label for='answer-id-930021' id='answer-label-930021' class=' answer'><span>8<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234239[]' id='answer-id-930022' class='answer   answerof-234239 ' value='930022'   \/><label for='answer-id-930022' id='answer-label-930022' class=' answer'><span>(missing numeric)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-56' style=';'><div id='questionWrap-56'  class='   watupro-question-id-234240'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>56. <\/span>The Excel workbook REGIONS.XLS contains the following four worksheets: <br \/>\r<br>EAST <br \/>\r<br>WEST <br \/>\r<br>NORTH <br \/>\r<br>SOUTH <br \/>\r<br>The following program is submitted: <br \/>\r<br>libname MYXLS 'regions.xls'; <br \/>\r<br>Which PROC PRINT step correctly displays the NORTH worksheet?<\/div><input type='hidden' name='question_id[]' id='qID_56' value='234240' \/><input type='hidden' id='answerType234240' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234240[]' id='answer-id-930023' class='answer   answerof-234240 ' value='930023'   \/><label for='answer-id-930023' id='answer-label-930023' class=' answer'><span>proc print data=MYXL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234240[]' id='answer-id-930024' class='answer   answerof-234240 ' value='930024'   \/><label for='answer-id-930024' id='answer-label-930024' class=' answer'><span>NORTH;run;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234240[]' id='answer-id-930025' class='answer   answerof-234240 ' value='930025'   \/><label for='answer-id-930025' id='answer-label-930025' class=' answer'><span>proc print data=MYXL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234240[]' id='answer-id-930026' class='answer   answerof-234240 ' value='930026'   \/><label for='answer-id-930026' id='answer-label-930026' class=' answer'><span>NORTH$;run;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234240[]' id='answer-id-930027' class='answer   answerof-234240 ' value='930027'   \/><label for='answer-id-930027' id='answer-label-930027' class=' answer'><span>proc print data=MYXL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234240[]' id='answer-id-930028' class='answer   answerof-234240 ' value='930028'   \/><label for='answer-id-930028' id='answer-label-930028' class=' answer'><span>'NORTH'e;run;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234240[]' id='answer-id-930029' class='answer   answerof-234240 ' value='930029'   \/><label for='answer-id-930029' id='answer-label-930029' class=' answer'><span>proc print data=MYXL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234240[]' id='answer-id-930030' class='answer   answerof-234240 ' value='930030'   \/><label for='answer-id-930030' id='answer-label-930030' class=' answer'><span>'NORTH$'n;run;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-57' style=';'><div id='questionWrap-57'  class='   watupro-question-id-234241'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>57. <\/span>The following code was modified to generate the results further below: <br \/>\r<br>proc format; <br \/>\r<br>value agegrp <br \/>\r<br>low-12 ='Pre-Teen' <br \/>\r<br>13-high = 'Teen'; <br \/>\r<br>run; <br \/>\r<br>proc means data=SASHELP.CLASS; <br \/>\r<br>var Height; <br \/>\r<br>class Sex Age; <br \/>\r<br>format Age agegrp.; <br \/>\r<br>run; <br \/>\r<br>The following results were generated to display only specific statistics and limit the decimals with the modification: <br \/>\r<br><br><img decoding=\"async\" width=649 height=195 id=\"\u56fe\u7247 174\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image017-28.jpg\"><br><br \/>\r<br>Which statement below was modified or added to generate the results above:<\/div><input type='hidden' name='question_id[]' id='qID_57' value='234241' \/><input type='hidden' id='answerType234241' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234241[]' id='answer-id-930031' class='answer   answerof-234241 ' value='930031'   \/><label for='answer-id-930031' id='answer-label-930031' class=' answer'><span>var Height \/ nobs min max mean maxdec=1;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234241[]' id='answer-id-930032' class='answer   answerof-234241 ' value='930032'   \/><label for='answer-id-930032' id='answer-label-930032' class=' answer'><span>proc means data=SASHEL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234241[]' id='answer-id-930033' class='answer   answerof-234241 ' value='930033'   \/><label for='answer-id-930033' id='answer-label-930033' class=' answer'><span>CLASS maxdec=1 ;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234241[]' id='answer-id-930034' class='answer   answerof-234241 ' value='930034'   \/><label for='answer-id-930034' id='answer-label-930034' class=' answer'><span>proc means data=SASHEL<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234241[]' id='answer-id-930035' class='answer   answerof-234241 ' value='930035'   \/><label for='answer-id-930035' id='answer-label-930035' class=' answer'><span>CLASS min max mean maxdec=1;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234241[]' id='answer-id-930036' class='answer   answerof-234241 ' value='930036'   \/><label for='answer-id-930036' id='answer-label-930036' class=' answer'><span>output nobs min max mean maxdec=1;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-58' style=';'><div id='questionWrap-58'  class='   watupro-question-id-234242'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>58. <\/span>Which is a valid LIBNAME statement?<\/div><input type='hidden' name='question_id[]' id='qID_58' value='234242' \/><input type='hidden' id='answerType234242' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234242[]' id='answer-id-930037' class='answer   answerof-234242 ' value='930037'   \/><label for='answer-id-930037' id='answer-label-930037' class=' answer'><span>libname &quot;_SAS_data_library_location_&quot;;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234242[]' id='answer-id-930038' class='answer   answerof-234242 ' value='930038'   \/><label for='answer-id-930038' id='answer-label-930038' class=' answer'><span>sasdata libname &quot;_SAS_data_library_location_&quot;;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234242[]' id='answer-id-930039' class='answer   answerof-234242 ' value='930039'   \/><label for='answer-id-930039' id='answer-label-930039' class=' answer'><span>libname sasdata &quot;_SAS_data_library_location_&quot;;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234242[]' id='answer-id-930040' class='answer   answerof-234242 ' value='930040'   \/><label for='answer-id-930040' id='answer-label-930040' class=' answer'><span>libname sasdata sas &quot;_SAS_data_library_location_&quot;;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-59' style=';'><div id='questionWrap-59'  class='   watupro-question-id-234243'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>59. <\/span>What describes the SAS automatic _ERROR_ variable?<\/div><input type='hidden' name='question_id[]' id='qID_59' value='234243' \/><input type='hidden' id='answerType234243' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234243[]' id='answer-id-930041' class='answer   answerof-234243 ' value='930041'   \/><label for='answer-id-930041' id='answer-label-930041' class=' answer'><span>The _ERROR_ variable contains the values \u2018TRUE\u2019 or \u2018FALS<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234243[]' id='answer-id-930042' class='answer   answerof-234243 ' value='930042'   \/><label for='answer-id-930042' id='answer-label-930042' class=' answer'><span>\u2019<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234243[]' id='answer-id-930043' class='answer   answerof-234243 ' value='930043'   \/><label for='answer-id-930043' id='answer-label-930043' class=' answer'><span>The _ERROR variable maintains a count of the number of data errors.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234243[]' id='answer-id-930044' class='answer   answerof-234243 ' value='930044'   \/><label for='answer-id-930044' id='answer-label-930044' class=' answer'><span>The _ERROR_ variable can be used in expressions or calculations in the DATA step.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234243[]' id='answer-id-930045' class='answer   answerof-234243 ' value='930045'   \/><label for='answer-id-930045' id='answer-label-930045' class=' answer'><span>The ERROR_variable contains the number or the observation that caused the error.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-60' style=';'><div id='questionWrap-60'  class='   watupro-question-id-234244'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>60. <\/span>The SAS data set PETS is sorted by the variables TYPE and BREED. <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>proc print data = pets; <br \/>\r<br>var type breed; <br \/>\r<br>sum number; <br \/>\r<br>run; <br \/>\r<br>What is the result?<\/div><input type='hidden' name='question_id[]' id='qID_60' value='234244' \/><input type='hidden' id='answerType234244' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234244[]' id='answer-id-930046' class='answer   answerof-234244 ' value='930046'   \/><label for='answer-id-930046' id='answer-label-930046' class=' answer'><span>The SUM statement produces only a grand total of NUMBE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234244[]' id='answer-id-930047' class='answer   answerof-234244 ' value='930047'   \/><label for='answer-id-930047' id='answer-label-930047' class=' answer'><span>The SUM statement produces only subtotals of NUMBER for each value of TYP<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234244[]' id='answer-id-930048' class='answer   answerof-234244 ' value='930048'   \/><label for='answer-id-930048' id='answer-label-930048' class=' answer'><span>The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYP<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234244[]' id='answer-id-930049' class='answer   answerof-234244 ' value='930049'   \/><label for='answer-id-930049' id='answer-label-930049' class=' answer'><span>Nothing is produced by the SUM statement; the program fails to execute.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-61' style=';'><div id='questionWrap-61'  class='   watupro-question-id-234245'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>61. <\/span>Given the AIRPLANES data set <br \/>\r<br>AlRPLANES <br \/>\r<br>TYPE MPG <br \/>\r<br>-------- ------ <br \/>\r<br>F-18 105 <br \/>\r<br>C-130 25 <br \/>\r<br>Harrier 75 <br \/>\r<br>A-6 110 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data gt100; <br \/>\r<br>set airplanes(keep = type mpg load); <br \/>\r<br>load = mpg * 150; <br \/>\r<br>run; <br \/>\r<br>The program fails to execute due to syntax errors. <br \/>\r<br>What is the cause of the syntax error?<\/div><input type='hidden' name='question_id[]' id='qID_61' value='234245' \/><input type='hidden' id='answerType234245' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234245[]' id='answer-id-930050' class='answer   answerof-234245 ' value='930050'   \/><label for='answer-id-930050' id='answer-label-930050' class=' answer'><span>MPG is not a numeric variable.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234245[]' id='answer-id-930051' class='answer   answerof-234245 ' value='930051'   \/><label for='answer-id-930051' id='answer-label-930051' class=' answer'><span>LOAD is not a variable in the data set GT100.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234245[]' id='answer-id-930052' class='answer   answerof-234245 ' value='930052'   \/><label for='answer-id-930052' id='answer-label-930052' class=' answer'><span>LOAD is not variable in the data set AIRPLANE<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234245[]' id='answer-id-930053' class='answer   answerof-234245 ' value='930053'   \/><label for='answer-id-930053' id='answer-label-930053' class=' answer'><span>LOAD must be defined prior to the SET statement.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-62' style=';'><div id='questionWrap-62'  class='   watupro-question-id-234246'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>62. <\/span>Read the table: <br \/>\r<br>Given the SAS data set SASUSER.HOUSES: <br \/>\r<br>Obsstylebedroomsbathspricesqteetstreet <br \/>\r<br>1CONDO21.5800501200MAIN <br \/>\r<br>2CONDO32.5793501300ELM <br \/>\r<br>3CONDO42.51271501400OAK <br \/>\r<br>4CONDO22.01107001100FIFTH <br \/>\r<br>5TWOSTORY43.01072502100SECOND <br \/>\r<br>6TWOSTORY21.0556501600WEST <br \/>\r<br>7TWOSTORY21.0692501450NORTH <br \/>\r<br>6TWOSTORY42.5102950 2000SOUTH <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>proc report data = sasuser.houses nowd headline; <br \/>\r<br>column style price; <br \/>\r<br>where price It 100000; <br \/>\r<br>&lt;insert DEFINE statement here&gt; <br \/>\r<br>define price \/ mean width = 9 format = dollar12.; <br \/>\r<br>title; <br \/>\r<br>run; <br \/>\r<br>The following output is desired: <br \/>\r<br>- style price <br \/>\r<br>- CONDO$79,700 <br \/>\r<br>- TWOSTORY$62550 <br \/>\r<br>Which DEFINE statement completes the program and produces the desired output?<\/div><input type='hidden' name='question_id[]' id='qID_62' value='234246' \/><input type='hidden' id='answerType234246' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234246[]' id='answer-id-930054' class='answer   answerof-234246 ' value='930054'   \/><label for='answer-id-930054' id='answer-label-930054' class=' answer'><span>define style \/ width = 9,<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234246[]' id='answer-id-930055' class='answer   answerof-234246 ' value='930055'   \/><label for='answer-id-930055' id='answer-label-930055' class=' answer'><span>define style \/ order width = 9;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234246[]' id='answer-id-930056' class='answer   answerof-234246 ' value='930056'   \/><label for='answer-id-930056' id='answer-label-930056' class=' answer'><span>define style \/ group width = 9;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234246[]' id='answer-id-930057' class='answer   answerof-234246 ' value='930057'   \/><label for='answer-id-930057' id='answer-label-930057' class=' answer'><span>define style \/ display width = 9;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-63' style=';'><div id='questionWrap-63'  class='   watupro-question-id-234247'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>63. <\/span>What is the purpose or the MISSOVER option on the INFILE statement?<\/div><input type='hidden' name='question_id[]' id='qID_63' value='234247' \/><input type='hidden' id='answerType234247' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234247[]' id='answer-id-930058' class='answer   answerof-234247 ' value='930058'   \/><label for='answer-id-930058' id='answer-label-930058' class=' answer'><span>It prevents SAS from loading a new record when the end of the current record is reached.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234247[]' id='answer-id-930059' class='answer   answerof-234247 ' value='930059'   \/><label for='answer-id-930059' id='answer-label-930059' class=' answer'><span>It enables SAS to scan the input data records until the character string that is specified in the @\u2018character-string\u2019 expression is round.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234247[]' id='answer-id-930060' class='answer   answerof-234247 ' value='930060'   \/><label for='answer-id-930060' id='answer-label-930060' class=' answer'><span>It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234247[]' id='answer-id-930061' class='answer   answerof-234247 ' value='930061'   \/><label for='answer-id-930061' id='answer-label-930061' class=' answer'><span>It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-64' style=';'><div id='questionWrap-64'  class='   watupro-question-id-234248'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>64. <\/span>The following SAS program is submitted: <br \/>\r<br>data work.total; <br \/>\r<br>set work.salary(keep = department wagerate); <br \/>\r<br>by department; <br \/>\r<br>if first.department <br \/>\r<br>then payroll = 0; <br \/>\r<br>payroll + wagerate; <br \/>\r<br>if last.department; <br \/>\r<br>run; <br \/>\r<br>The SAS data set named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT. <br \/>\r<br>Which statement is true?<\/div><input type='hidden' name='question_id[]' id='qID_64' value='234248' \/><input type='hidden' id='answerType234248' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234248[]' id='answer-id-930062' class='answer   answerof-234248 ' value='930062'   \/><label for='answer-id-930062' id='answer-label-930062' class=' answer'><span>The BY statement in the DATA step causes a syntax error.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234248[]' id='answer-id-930063' class='answer   answerof-234248 ' value='930063'   \/><label for='answer-id-930063' id='answer-label-930063' class=' answer'><span>The statement payroll + wagerate; in the DATA step causes a syntax error.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234248[]' id='answer-id-930064' class='answer   answerof-234248 ' value='930064'   \/><label for='answer-id-930064' id='answer-label-930064' class=' answer'><span>The values of the variable PAYROLL represent the total for each department in the WOR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234248[]' id='answer-id-930065' class='answer   answerof-234248 ' value='930065'   \/><label for='answer-id-930065' id='answer-label-930065' class=' answer'><span>SALARY data set.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234248[]' id='answer-id-930066' class='answer   answerof-234248 ' value='930066'   \/><label for='answer-id-930066' id='answer-label-930066' class=' answer'><span>The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-65' style=';'><div id='questionWrap-65'  class='   watupro-question-id-234249'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>65. <\/span>Given the raw data record DEPT: <br \/>\r<br>----|----10---|----20---|----30 <br \/>\r<br>Printing 750 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data bonus; <br \/>\r<br>infile \u2018dept\u2019; <br \/>\r<br>inputdept$ 1-11 number 13- 15; <br \/>\r<br>&lt;insert statement here&gt; <br \/>\r<br>run; <br \/>\r<br>Which SAS statement completes the program and results in a value of \u2018Printing750\u2019 for the DEPARTMENT variable?<\/div><input type='hidden' name='question_id[]' id='qID_65' value='234249' \/><input type='hidden' id='answerType234249' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234249[]' id='answer-id-930067' class='answer   answerof-234249 ' value='930067'   \/><label for='answer-id-930067' id='answer-label-930067' class=' answer'><span>department = dept II number;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234249[]' id='answer-id-930068' class='answer   answerof-234249 ' value='930068'   \/><label for='answer-id-930068' id='answer-label-930068' class=' answer'><span>department = left(dept) II number;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234249[]' id='answer-id-930069' class='answer   answerof-234249 ' value='930069'   \/><label for='answer-id-930069' id='answer-label-930069' class=' answer'><span>department = trim(dept) number;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234249[]' id='answer-id-930070' class='answer   answerof-234249 ' value='930070'   \/><label for='answer-id-930070' id='answer-label-930070' class=' answer'><span>department=trim(dept)||put(number,3.);<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-66' style=';'><div id='questionWrap-66'  class='   watupro-question-id-234250'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>66. <\/span>Given the SAS data set WORKAWARDS: <br \/>\r<br>WORK.AWARDS <br \/>\r<br>FNAMEPOINTSMONTH <br \/>\r<br>---------------------------------- <br \/>\r<br>Amy24 <br \/>\r<br>Amy17 <br \/>\r<br>Gerard33 <br \/>\r<br>Wang33 <br \/>\r<br>Wang112 <br \/>\r<br>Wang18 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>proc sort data = work.awards; <br \/>\r<br>by descending fname points; <br \/>\r<br>run; <br \/>\r<br>How are the observations sorted?<\/div><input type='hidden' name='question_id[]' id='qID_66' value='234250' \/><input type='hidden' id='answerType234250' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234250[]' id='answer-id-930071' class='answer   answerof-234250 ' value='930071'   \/><label for='answer-id-930071' id='answer-label-930071' class=' answer'><span>ENAME POINTS MONTH \r\nWang33 \r\nWang112 \r\nWang18 \r\nGerard33 \r\nAmy24 \r\nAmy17<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234250[]' id='answer-id-930072' class='answer   answerof-234250 ' value='930072'   \/><label for='answer-id-930072' id='answer-label-930072' class=' answer'><span>ENAME POINTS MONTH \r\nAmy24 \r\nAmy17 \r\nGerard33 \r\nWang33 \r\nWang18 \r\nWang112<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234250[]' id='answer-id-930073' class='answer   answerof-234250 ' value='930073'   \/><label for='answer-id-930073' id='answer-label-930073' class=' answer'><span>ENAME POINTS MONTH \r\nWang33 \r\nWang18 \r\nWang112 \r\nGerard33 \r\nAmy24 \r\nAmy17<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234250[]' id='answer-id-930074' class='answer   answerof-234250 ' value='930074'   \/><label for='answer-id-930074' id='answer-label-930074' class=' answer'><span>ENAME POINTS MONTH \r\nWang112 \r\nWang18 \r\nWang33 \r\nGerard33 \r\nAmy17 \r\nAmy24<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-67' style=';'><div id='questionWrap-67'  class='   watupro-question-id-234251'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>67. <\/span>The following SAS program is submitted: <br \/>\r<br><br><img decoding=\"async\" width=265 height=135 id=\"\u56fe\u7247 175\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image018-24.jpg\"><br><br \/>\r<br>How will the Exam variable value be displayed in the FREQ procedure output?<\/div><input type='hidden' name='question_id[]' id='qID_67' value='234251' \/><input type='hidden' id='answerType234251' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234251[]' id='answer-id-930075' class='answer   answerof-234251 ' value='930075'   \/><label for='answer-id-930075' id='answer-label-930075' class=' answer'><span>Fail<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234251[]' id='answer-id-930076' class='answer   answerof-234251 ' value='930076'   \/><label for='answer-id-930076' id='answer-label-930076' class=' answer'><span>Pass<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234251[]' id='answer-id-930077' class='answer   answerof-234251 ' value='930077'   \/><label for='answer-id-930077' id='answer-label-930077' class=' answer'><span>50.5<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234251[]' id='answer-id-930078' class='answer   answerof-234251 ' value='930078'   \/><label for='answer-id-930078' id='answer-label-930078' class=' answer'><span>.(missing numeric value)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-68' style=';'><div id='questionWrap-68'  class='   watupro-question-id-234252'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>68. <\/span>The following SAS program is submitted: <br \/>\r<br>&lt;insert ODS statement here&gt; <br \/>\r<br>proc means data = sasuser.shoes; <br \/>\r<br>where product in (\u2018Sandal\u2019 , \u2018Slipper\u2019 , \u2018Boot\u2019); <br \/>\r<br>run; <br \/>\r<br>&lt;insert ODS statement here&gt; <br \/>\r<br>Which ODS statements complete the program and send the report to an HTML file?<\/div><input type='hidden' name='question_id[]' id='qID_68' value='234252' \/><input type='hidden' id='answerType234252' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234252[]' id='answer-id-930079' class='answer   answerof-234252 ' value='930079'   \/><label for='answer-id-930079' id='answer-label-930079' class=' answer'><span>ods html = \u2018sales.html\u2019; \r\nods html close;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234252[]' id='answer-id-930080' class='answer   answerof-234252 ' value='930080'   \/><label for='answer-id-930080' id='answer-label-930080' class=' answer'><span>ods file = \u2018sales.html\u2019; \r\nods file close;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234252[]' id='answer-id-930081' class='answer   answerof-234252 ' value='930081'   \/><label for='answer-id-930081' id='answer-label-930081' class=' answer'><span>ods file html = \u2018sales.html\u2019; \r\nods file close;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234252[]' id='answer-id-930082' class='answer   answerof-234252 ' value='930082'   \/><label for='answer-id-930082' id='answer-label-930082' class=' answer'><span>ods html file = \u2018sales.html\u2019; \r\nods html close;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-69' style=';'><div id='questionWrap-69'  class='   watupro-question-id-234253'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>69. <\/span>The following SAS program is submitted: <br \/>\r<br><br><img decoding=\"async\" width=350 height=94 id=\"\u56fe\u7247 177\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image019-25.jpg\"><br><br \/>\r<br>The program fails execution due to syntax errors. <br \/>\r<br>What is the cause of the syntax error?<\/div><input type='hidden' name='question_id[]' id='qID_69' value='234253' \/><input type='hidden' id='answerType234253' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234253[]' id='answer-id-930083' class='answer   answerof-234253 ' value='930083'   \/><label for='answer-id-930083' id='answer-label-930083' class=' answer'><span>The variable MONTHSALES does not exist.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234253[]' id='answer-id-930084' class='answer   answerof-234253 ' value='930084'   \/><label for='answer-id-930084' id='answer-label-930084' class=' answer'><span>An array cannot be referenced on a KEEP data set option.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234253[]' id='answer-id-930085' class='answer   answerof-234253 ' value='930085'   \/><label for='answer-id-930085' id='answer-label-930085' class=' answer'><span>The KEEP= data set option should be (KEEP = MONTHSALES).<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234253[]' id='answer-id-930086' class='answer   answerof-234253 ' value='930086'   \/><label for='answer-id-930086' id='answer-label-930086' class=' answer'><span>The KEEP= data set option should be the statement KEEP MONTHSALES{12}.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-70' style=';'><div id='questionWrap-70'  class='   watupro-question-id-234254'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>70. <\/span>The following SAS program is submitted: <br \/>\r<br>data WORK.ONE; <br \/>\r<br>Text=\u2019Australia, US, Denmark\u2019; <br \/>\r<br>Pos=find (Text,\u2019US\u2019,\u2019i\u2019,5); <br \/>\r<br>run; <br \/>\r<br>What value will SAS assign to Pos?<\/div><input type='hidden' name='question_id[]' id='qID_70' value='234254' \/><input type='hidden' id='answerType234254' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234254[]' id='answer-id-930087' class='answer   answerof-234254 ' value='930087'   \/><label for='answer-id-930087' id='answer-label-930087' class=' answer'><span>0<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234254[]' id='answer-id-930088' class='answer   answerof-234254 ' value='930088'   \/><label for='answer-id-930088' id='answer-label-930088' class=' answer'><span>1<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234254[]' id='answer-id-930089' class='answer   answerof-234254 ' value='930089'   \/><label for='answer-id-930089' id='answer-label-930089' class=' answer'><span>2<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234254[]' id='answer-id-930090' class='answer   answerof-234254 ' value='930090'   \/><label for='answer-id-930090' id='answer-label-930090' class=' answer'><span>12<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-71' style=';'><div id='questionWrap-71'  class='   watupro-question-id-234255'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>71. <\/span>The following SAS program is submitted: <br \/>\r<br>data work.flights; <br \/>\r<br>destination = \u2018cph\u2019; <br \/>\r<br>select(destination); <br \/>\r<br>when(\u2019LHR\u2019) city = \u2018London\u2019; <br \/>\r<br>when(\u2019CPH\u2019) city = \u2018Copenhagen\u2019; <br \/>\r<br>otherwise city = \u2018Other\u2019; <br \/>\r<br>end; <br \/>\r<br>run; <br \/>\r<br>What is the value of the CITY variable?<\/div><input type='hidden' name='question_id[]' id='qID_71' value='234255' \/><input type='hidden' id='answerType234255' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234255[]' id='answer-id-930091' class='answer   answerof-234255 ' value='930091'   \/><label for='answer-id-930091' id='answer-label-930091' class=' answer'><span>Other<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234255[]' id='answer-id-930092' class='answer   answerof-234255 ' value='930092'   \/><label for='answer-id-930092' id='answer-label-930092' class=' answer'><span>Copenh<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234255[]' id='answer-id-930093' class='answer   answerof-234255 ' value='930093'   \/><label for='answer-id-930093' id='answer-label-930093' class=' answer'><span>Copenhagen<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234255[]' id='answer-id-930094' class='answer   answerof-234255 ' value='930094'   \/><label for='answer-id-930094' id='answer-label-930094' class=' answer'><span>\u2018\u2018(missing character value)<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-72' style=';'><div id='questionWrap-72'  class='   watupro-question-id-234256'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>72. <\/span>After a SAS program is submitted, the following is written to the SAS log: <br \/>\r<br>105 data january; <br \/>\r<br>106 set allmonths(keep = product month num_sold cost); <br \/>\r<br>107 if month = \u2018Jan\u2019 then output january; <br \/>\r<br>108 sales = cost * num_sold; <br \/>\r<br>109 keep = product sales; <br \/>\r<br>------ <br \/>\r<br>22 <br \/>\r<br>ERROR 22-322: Syntax error, expecting one of the following:!, !!, &amp;, *,**, +, -,\/, &lt;,&lt; =, &lt;&gt;, =, &gt;, &gt;&lt;, &gt;=, <br \/>\r<br>AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II, <br \/>\r<br>110 run; <br \/>\r<br>What changes should be made to the KEEP statement to correct the errors in the LOG?<\/div><input type='hidden' name='question_id[]' id='qID_72' value='234256' \/><input type='hidden' id='answerType234256' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234256[]' id='answer-id-930095' class='answer   answerof-234256 ' value='930095'   \/><label for='answer-id-930095' id='answer-label-930095' class=' answer'><span>keep product sales;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234256[]' id='answer-id-930096' class='answer   answerof-234256 ' value='930096'   \/><label for='answer-id-930096' id='answer-label-930096' class=' answer'><span>keep product, sales;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234256[]' id='answer-id-930097' class='answer   answerof-234256 ' value='930097'   \/><label for='answer-id-930097' id='answer-label-930097' class=' answer'><span>keep = product, sales;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234256[]' id='answer-id-930098' class='answer   answerof-234256 ' value='930098'   \/><label for='answer-id-930098' id='answer-label-930098' class=' answer'><span>keep = (product sales);<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-73' style=';'><div id='questionWrap-73'  class='   watupro-question-id-234257'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>73. <\/span>The following SAS program is submitted: <br \/>\r<br>data one; <br \/>\r<br>date = \u201804juI2005\u2019d; <br \/>\r<br>format date weekdate.; run; <br \/>\r<br>proc print data = one; run; <br \/>\r<br>What output is generated?<\/div><input type='hidden' name='question_id[]' id='qID_73' value='234257' \/><input type='hidden' id='answerType234257' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234257[]' id='answer-id-930099' class='answer   answerof-234257 ' value='930099'   \/><label for='answer-id-930099' id='answer-label-930099' class=' answer'><span>Obs date \r\n1 Monday, July 4, 2005<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234257[]' id='answer-id-930100' class='answer   answerof-234257 ' value='930100'   \/><label for='answer-id-930100' id='answer-label-930100' class=' answer'><span>Obs date \r\n1 July4, 2005<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234257[]' id='answer-id-930101' class='answer   answerof-234257 ' value='930101'   \/><label for='answer-id-930101' id='answer-label-930101' class=' answer'><span>Obs date \r\n1 04Jul2005<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234257[]' id='answer-id-930102' class='answer   answerof-234257 ' value='930102'   \/><label for='answer-id-930102' id='answer-label-930102' class=' answer'><span>Obs date \r\n1 Monday, 07\/04\/2005<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-74' style=';'><div id='questionWrap-74'  class='   watupro-question-id-234258'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>74. <\/span>The following SAS program is submitted: <br \/>\r<br>data work.total; <br \/>\r<br>set work.salary(keep = department wagerate); <br \/>\r<br>by department; <br \/>\r<br>if first.department <br \/>\r<br>then payroll = 0; <br \/>\r<br>payroll + wagerate; <br \/>\r<br>if last.department <br \/>\r<br>run; <br \/>\r<br>The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments. <br \/>\r<br>What is the result?<\/div><input type='hidden' name='question_id[]' id='qID_74' value='234258' \/><input type='hidden' id='answerType234258' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234258[]' id='answer-id-930103' class='answer   answerof-234258 ' value='930103'   \/><label for='answer-id-930103' id='answer-label-930103' class=' answer'><span>The WOR<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234258[]' id='answer-id-930104' class='answer   answerof-234258 ' value='930104'   \/><label for='answer-id-930104' id='answer-label-930104' class=' answer'><span>TOTAL data set contains 5 observations.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234258[]' id='answer-id-930105' class='answer   answerof-234258 ' value='930105'   \/><label for='answer-id-930105' id='answer-label-930105' class=' answer'><span>The WORKTDTAL data set contains 100 observations.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234258[]' id='answer-id-930106' class='answer   answerof-234258 ' value='930106'   \/><label for='answer-id-930106' id='answer-label-930106' class=' answer'><span>The WORKTOTAL data set contains 500 observations.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234258[]' id='answer-id-930107' class='answer   answerof-234258 ' value='930107'   \/><label for='answer-id-930107' id='answer-label-930107' class=' answer'><span>The program fails to execute due to errors.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-75' style=';'><div id='questionWrap-75'  class='   watupro-question-id-234259'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>75. <\/span>The following SAS program is submitted: <br \/>\r<br>&lt;_insert_ods_code_&gt; <br \/>\r<br>proc means data=SASUSER.SHOES; <br \/>\r<br>where Product in ('Sandal' , 'Slipper' , 'Boot'); <br \/>\r<br>run; <br \/>\r<br>&lt;_insert_ods_code_&gt; <br \/>\r<br>Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?<\/div><input type='hidden' name='question_id[]' id='qID_75' value='234259' \/><input type='hidden' id='answerType234259' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234259[]' id='answer-id-930108' class='answer   answerof-234259 ' value='930108'   \/><label for='answer-id-930108' id='answer-label-930108' class=' answer'><span>ods html open='sales.html';ods html close;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234259[]' id='answer-id-930109' class='answer   answerof-234259 ' value='930109'   \/><label for='answer-id-930109' id='answer-label-930109' class=' answer'><span>ods file='sales.html' \/ html;ods file close;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234259[]' id='answer-id-930110' class='answer   answerof-234259 ' value='930110'   \/><label for='answer-id-930110' id='answer-label-930110' class=' answer'><span>ods html file='sales.html';ods html close;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234259[]' id='answer-id-930111' class='answer   answerof-234259 ' value='930111'   \/><label for='answer-id-930111' id='answer-label-930111' class=' answer'><span>ods file html='sales.html';ods file close;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-76' style=';'><div id='questionWrap-76'  class='   watupro-question-id-234260'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>76. <\/span>The following output is created by the FREQUENCY procedure: <br \/>\r<br><br><img decoding=\"async\" width=554 height=467 id=\"\u56fe\u7247 179\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/uploads\/2022\/09\/image020-24.jpg\"><br><br \/>\r<br>Which TABLES statement was used to completed the following program that produced the output? <br \/>\r<br>proc freq data=sales; <br \/>\r<br>&lt;_insert_code_&gt; <br \/>\r<br>run;<\/div><input type='hidden' name='question_id[]' id='qID_76' value='234260' \/><input type='hidden' id='answerType234260' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234260[]' id='answer-id-930112' class='answer   answerof-234260 ' value='930112'   \/><label for='answer-id-930112' id='answer-label-930112' class=' answer'><span>tables region product;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234260[]' id='answer-id-930113' class='answer   answerof-234260 ' value='930113'   \/><label for='answer-id-930113' id='answer-label-930113' class=' answer'><span>tables region,product<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234260[]' id='answer-id-930114' class='answer   answerof-234260 ' value='930114'   \/><label for='answer-id-930114' id='answer-label-930114' class=' answer'><span>tables region\/product;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234260[]' id='answer-id-930115' class='answer   answerof-234260 ' value='930115'   \/><label for='answer-id-930115' id='answer-label-930115' class=' answer'><span>tables region*product;<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-77' style=';'><div id='questionWrap-77'  class='   watupro-question-id-234261'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>77. <\/span>The following SAS program is submitted: <br \/>\r<br>data work.test; <br \/>\r<br>set work.staff (keep = jansales febsales marsales); <br \/>\r<br>array diff_sales{3} difsales1 - difsales3; <br \/>\r<br>array monthly{3} jansales febsales marsales; <br \/>\r<br>run; <br \/>\r<br>What new variables are created?<\/div><input type='hidden' name='question_id[]' id='qID_77' value='234261' \/><input type='hidden' id='answerType234261' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234261[]' id='answer-id-930116' class='answer   answerof-234261 ' value='930116'   \/><label for='answer-id-930116' id='answer-label-930116' class=' answer'><span>JANSALES, FEBSALES and MARSALES<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234261[]' id='answer-id-930117' class='answer   answerof-234261 ' value='930117'   \/><label for='answer-id-930117' id='answer-label-930117' class=' answer'><span>MONTHLY1, MONTHLY2 and MONTHLY3<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234261[]' id='answer-id-930118' class='answer   answerof-234261 ' value='930118'   \/><label for='answer-id-930118' id='answer-label-930118' class=' answer'><span>DIFSALES1, DIFSALES2 and DIFSALES3<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234261[]' id='answer-id-930119' class='answer   answerof-234261 ' value='930119'   \/><label for='answer-id-930119' id='answer-label-930119' class=' answer'><span>DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-78' style=';'><div id='questionWrap-78'  class='   watupro-question-id-234262'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>78. <\/span>Given the raw data file AMOUNT: <br \/>\r<br>----I---- 10---I----20---I----30 <br \/>\r<br>$1,234 <br \/>\r<br>The following SAS program is submitted: <br \/>\r<br>data test; <br \/>\r<br>infile \u2018amount\u2019; <br \/>\r<br>input@1 salary 6.; <br \/>\r<br>if_error_then description = \u2018Problems\u2019; <br \/>\r<br>else description = \u2018No Problems\u2019; <br \/>\r<br>run; <br \/>\r<br>What is the result?<\/div><input type='hidden' name='question_id[]' id='qID_78' value='234262' \/><input type='hidden' id='answerType234262' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234262[]' id='answer-id-930120' class='answer   answerof-234262 ' value='930120'   \/><label for='answer-id-930120' id='answer-label-930120' class=' answer'><span>The value of the DESCRIPTION variable is No Probl.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234262[]' id='answer-id-930121' class='answer   answerof-234262 ' value='930121'   \/><label for='answer-id-930121' id='answer-label-930121' class=' answer'><span>The value of the DESCRIPTION variable is Problems.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234262[]' id='answer-id-930122' class='answer   answerof-234262 ' value='930122'   \/><label for='answer-id-930122' id='answer-label-930122' class=' answer'><span>The value of the DESCRIPTION variable is No Problems.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234262[]' id='answer-id-930123' class='answer   answerof-234262 ' value='930123'   \/><label for='answer-id-930123' id='answer-label-930123' class=' answer'><span>The value of the DESCRIPTION variable can not be determined.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-79' style=';'><div id='questionWrap-79'  class='   watupro-question-id-234263'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>79. <\/span>The following SAS program is submitted: <br \/>\r<br>data WORK.DATE_INFO; <br \/>\r<br>X=&quot;01Jan1960&quot; D; <br \/>\r<br>run; <br \/>\r<br>What variable X contains what value?<\/div><input type='hidden' name='question_id[]' id='qID_79' value='234263' \/><input type='hidden' id='answerType234263' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234263[]' id='answer-id-930124' class='answer   answerof-234263 ' value='930124'   \/><label for='answer-id-930124' id='answer-label-930124' class=' answer'><span>the numeric value 0<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234263[]' id='answer-id-930125' class='answer   answerof-234263 ' value='930125'   \/><label for='answer-id-930125' id='answer-label-930125' class=' answer'><span>the character value &quot;01Jan1960&quot;<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234263[]' id='answer-id-930126' class='answer   answerof-234263 ' value='930126'   \/><label for='answer-id-930126' id='answer-label-930126' class=' answer'><span>the date value 01011960<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234263[]' id='answer-id-930127' class='answer   answerof-234263 ' value='930127'   \/><label for='answer-id-930127' id='answer-label-930127' class=' answer'><span>the code contains a syntax error and does not execute.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div class='watu-question ' id='question-80' style=';'><div id='questionWrap-80'  class='   watupro-question-id-234264'>\n\t\t\t<div class='question-content'><div><span class='watupro_num'>80. <\/span>Which statement is true concerning the SAS automatic variable _ERROR_?<\/div><input type='hidden' name='question_id[]' id='qID_80' value='234264' \/><input type='hidden' id='answerType234264' value='radio'><!-- end question-content--><\/div><div class='question-choices watupro-choices-columns '><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234264[]' id='answer-id-930128' class='answer   answerof-234264 ' value='930128'   \/><label for='answer-id-930128' id='answer-label-930128' class=' answer'><span>It cannot be used in an if\/then condition.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234264[]' id='answer-id-930129' class='answer   answerof-234264 ' value='930129'   \/><label for='answer-id-930129' id='answer-label-930129' class=' answer'><span>It cannot be used in an assignment statement.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234264[]' id='answer-id-930130' class='answer   answerof-234264 ' value='930130'   \/><label for='answer-id-930130' id='answer-label-930130' class=' answer'><span>It can be put into a keep statement or keep= option.<\/span><\/label><\/div><div class='watupro-question-choice  ' dir='auto' ><input type='radio' name='answer-234264[]' id='answer-id-930131' class='answer   answerof-234264 ' value='930131'   \/><label for='answer-id-930131' id='answer-label-930131' class=' answer'><span>It is automatically dropped.<\/span><\/label><\/div><!-- end question-choices--><\/div><!-- end questionWrap--><\/div><\/div><div style='display:none' id='question-81'>\n\t<div class='question-content'>\n\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/img\/loading.gif\" width=\"16\" height=\"16\" alt=\"Loading...\" title=\"Loading...\" \/>&nbsp;Loading...\t<\/div>\n<\/div>\n\n<br \/>\n\t\n\t\t\t<div class=\"watupro_buttons flex \" id=\"watuPROButtons6612\" >\n\t\t  <div id=\"prev-question\" style=\"display:none;\"><input type=\"button\" value=\"&lt; Previous\" onclick=\"WatuPRO.nextQuestion(event, 'previous');\"\/><\/div>\t\t  \t\t  \t\t   \n\t\t   \t  \t\t<div><input type=\"button\" name=\"action\" class=\"watupro-submit-button\" onclick=\"WatuPRO.submitResult(event)\" id=\"action-button\" value=\"View Results\"  \/>\n\t\t<\/div>\n\t\t<\/div>\n\t\t\n\t<input type=\"hidden\" name=\"quiz_id\" value=\"6612\" id=\"watuPROExamID\"\/>\n\t<input type=\"hidden\" name=\"start_time\" id=\"startTime\" value=\"2026-05-07 17:18:29\" \/>\n\t<input type=\"hidden\" name=\"start_timestamp\" id=\"startTimeStamp\" value=\"1778174309\" \/>\n\t<input type=\"hidden\" name=\"question_ids\" value=\"\" \/>\n\t<input type=\"hidden\" name=\"watupro_questions\" value=\"234185:929791,929792,929793,929794 | 234186:929795,929796,929797,929798 | 234187:929799,929800,929801,929802 | 234188:929803,929804,929805,929806 | 234189:929807,929808,929809,929810 | 234190:929811,929812,929813,929814 | 234191:929815,929816,929817,929818 | 234192:929819,929820,929821,929822 | 234193:929823,929824,929825,929826,929827 | 234194:929828,929829,929830,929831 | 234195:929832,929833,929834,929835 | 234196:929836,929837,929838,929839 | 234197:929840,929841,929842,929843 | 234198:929844,929845,929846,929847 | 234199:929848,929849,929850,929851 | 234200:929852,929853,929854,929855 | 234201:929856,929857,929858,929859 | 234202:929860,929861,929862,929863 | 234203:929864,929865,929866,929867 | 234204:929868,929869,929870,929871 | 234205:929872,929873,929874,929875 | 234206:929876,929877,929878,929879 | 234207:929880,929881,929882,929883 | 234208:929884,929885,929886,929887 | 234209:929888,929889,929890,929891,929892,929893 | 234210:929894,929895,929896,929897 | 234211:929898,929899,929900,929901 | 234212:929902,929903,929904,929905 | 234213:929906,929907,929908,929909,929910,929911,929912,929913,929914,929915,929916,929917,929918 | 234214:929919,929920,929921,929922 | 234215:929923,929924,929925,929926 | 234216:929927,929928,929929,929930 | 234217:929931,929932,929933,929934 | 234218:929935,929936,929937,929938 | 234219:929939,929940,929941,929942 | 234220:929943,929944,929945,929946 | 234221:929947,929948,929949,929950 | 234222:929951,929952,929953,929954 | 234223:929955,929956,929957,929958 | 234224:929959,929960,929961,929962 | 234225:929963,929964,929965,929966 | 234226:929967,929968,929969,929970 | 234227:929971,929972,929973,929974 | 234228:929975,929976,929977,929978 | 234229:929979,929980,929981,929982 | 234230:929983,929984,929985,929986 | 234231:929987,929988,929989,929990 | 234232:929991,929992,929993,929994 | 234233:929995,929996,929997,929998 | 234234:929999,930000,930001,930002 | 234235:930003,930004,930005,930006 | 234236:930007,930008,930009,930010 | 234237:930011,930012,930013,930014 | 234238:930015,930016,930017,930018 | 234239:930019,930020,930021,930022 | 234240:930023,930024,930025,930026,930027,930028,930029,930030 | 234241:930031,930032,930033,930034,930035,930036 | 234242:930037,930038,930039,930040 | 234243:930041,930042,930043,930044,930045 | 234244:930046,930047,930048,930049 | 234245:930050,930051,930052,930053 | 234246:930054,930055,930056,930057 | 234247:930058,930059,930060,930061 | 234248:930062,930063,930064,930065,930066 | 234249:930067,930068,930069,930070 | 234250:930071,930072,930073,930074 | 234251:930075,930076,930077,930078 | 234252:930079,930080,930081,930082 | 234253:930083,930084,930085,930086 | 234254:930087,930088,930089,930090 | 234255:930091,930092,930093,930094 | 234256:930095,930096,930097,930098 | 234257:930099,930100,930101,930102 | 234258:930103,930104,930105,930106,930107 | 234259:930108,930109,930110,930111 | 234260:930112,930113,930114,930115 | 234261:930116,930117,930118,930119 | 234262:930120,930121,930122,930123 | 234263:930124,930125,930126,930127 | 234264:930128,930129,930130,930131\" \/>\n\t<input type=\"hidden\" name=\"no_ajax\" value=\"0\">\t\t\t<\/form>\n\t<p>&nbsp;<\/p>\n<\/div>\n\n<script type=\"text\/javascript\">\n\/\/jQuery(document).ready(function(){\ndocument.addEventListener(\"DOMContentLoaded\", function(event) { \t\nvar question_ids = \"234185,234186,234187,234188,234189,234190,234191,234192,234193,234194,234195,234196,234197,234198,234199,234200,234201,234202,234203,234204,234205,234206,234207,234208,234209,234210,234211,234212,234213,234214,234215,234216,234217,234218,234219,234220,234221,234222,234223,234224,234225,234226,234227,234228,234229,234230,234231,234232,234233,234234,234235,234236,234237,234238,234239,234240,234241,234242,234243,234244,234245,234246,234247,234248,234249,234250,234251,234252,234253,234254,234255,234256,234257,234258,234259,234260,234261,234262,234263,234264\";\nWatuPROSettings[6612] = {};\nWatuPRO.qArr = question_ids.split(',');\nWatuPRO.exam_id = 6612;\t    \nWatuPRO.post_id = 45869;\nWatuPRO.store_progress = 0;\nWatuPRO.curCatPage = 1;\nWatuPRO.requiredIDs=\"0\".split(\",\");\nWatuPRO.hAppID = \"0.20628700 1778174309\";\nvar url = \"https:\/\/www.dumpsbase.com\/freedumps\/wp-content\/plugins\/watupro\/show_exam.php\";\nWatuPRO.examMode = 1;\nWatuPRO.siteURL=\"https:\/\/www.dumpsbase.com\/freedumps\/wp-admin\/admin-ajax.php\";\nWatuPRO.emailIsNotRequired = 0;\nWatuPROIntel.init(6612);\nWatuPRO.inCategoryPages=1;});    \t \n<\/script>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[284,285],"tags":[14469,14470,14471,14472],"class_list":["post-45869","post","type-post","status-publish","format-standard","hentry","category-sas-institute","category-sas-institute-systems-certification","tag-a00-231","tag-a00-231-dumps","tag-a00-231-exam-dumps","tag-a00-231-free-dumps"],"_links":{"self":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/45869","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/comments?post=45869"}],"version-history":[{"count":1,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/45869\/revisions"}],"predecessor-version":[{"id":45878,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/posts\/45869\/revisions\/45878"}],"wp:attachment":[{"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/media?parent=45869"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/categories?post=45869"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dumpsbase.com\/freedumps\/wp-json\/wp\/v2\/tags?post=45869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}