Ensurepass  QUESTION 81 Given the following SAS data set ONE:   ONE   CATEGORY AGE SALARY BONUS   ---   M 28 200 . M 25 100 10   F 18 100 50   F 25 200 10   The following SAS program is submitted:   proc sql;   create table two as   select category, salary + bonus as EARNINGS   from one; quit;   Which one of the following represents the data values stored in the data set TWO?   A. CATEGORY EARNINGS M 200 M 110 F 150 F 210 Read more [...]
Ensurepass  QUESTION 11 The following SAS program is submitted:   %let lib=%upcase(sauser); proc sql;   select nvar form dictionary.tables where libname='&lib"; quit;   Several SAS data sets exist in the SAUSER library.   What is generated as output?   A. A report showing the names of the columns in each table in SASUSER B. A report showing the number of columns in each table in SASUSER C. A report showing the numeric columns in each table in SASUSER Read more [...]
Ensurepass  QUESTION 21 Given the non-indexed SAS data set TEMP:   TEMP   X Y   - -   P 52   P 45   A 13   A 56   R 34   R 12   R 78   The following SAS program is submitted:   Proc print data=temp;   <insert BY statement here>   run;   Which BY statement completes the program, creates a listing report that is grouped by X and completes without errors?   A. By X notsorted; B. By X grouped; C. By Read more [...]
Ensurepass  QUESTION 31 Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?   A. MODIFY and CHANGE statements B. RENAME statement only C. CHANGE statement only D. MODIFY and RENAME statements   Correct Answer: C     QUESTION 32 The following SAS program is submitted:   %macro loop;   data one;   %do I=1 %to 3;   var&I=&I;%   end   run;   %mend;   %loop Read more [...]
Ensurepass  QUESTION 41 Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS system options writes that text to the log?   A. MPRINT B. MLOGIC C. MSOURCE D. SOURCE2   Correct Answer: A     QUESTION 42 The following SAS program is submitted:   %micro cols1;   name age;   %mend;   %macro cols2;   height weight %mend   proc print data=sashelp.class;   <insert VAR statement here> Read more [...]
Ensurepass  QUESTION 51 The following SAS program is submitted:   %macro test(var);   %let jobs = BLACKSMITH WORDSMITH SWORDSMITH;   %let type = %index(&jobs,&var);   %mend;   %test(SMITH)   Which one of the following is the resulting value of the macro variable TYPE?   A. 0 B. 3 C. 6 D. null   Correct Answer: C     QUESTION 52 The following SAS program is submitted:   %let a=cat;   %macro animal(a=frog);   Read more [...]
Ensurepass  QUESTION 61 Given the following SAS data set named WORK.INTERNAT:   WORK.INTERNAT   LOCATION SUM   USA 30   EUR 40   The following SAS program is submitted:   %let LOC = Usa;   proc sql;   select *   from internat   where location = "&Loc";   quit;   Which one of the following is the result when the above code is executed on the above data set?   A. A report is generated with one destination. B. No report Read more [...]
Ensurepass  QUESTION 71 Given the following SAS data set SASUSER.HIGHWAY:   SASUSER.HIGHWAY   STEERING SEATBELT SPEED STATUS COUNT   absent no 0-29 serious 31   absent no 0-29 not 1419   absent no 30-49 serious 191   absent no 30-49 not 2004   absent no 50+ serious 216   The following SAS program is submitted:   %macro highway;   proc sql noprint;   select count(distinct status)   into :numgrp   from sasuser.highway;   %let Read more [...]
Ensurepass QUESTION 1 Which one of the following is true regarding the KEEP statement?   A. The KEEP statement is available in both the DATA and the PROC steps. B. The KEEP statement selects the variables read from the input data set(s). C. The KEEP statement applies to all data sets created within the same DATA step. D. The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is created.   Correct Answer: C     Read more [...]