SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 71:

  The following SAS program is submitted:

  data temp;

  array points{2,3} (10,15,20,25,30,35);

  run;

  What impact does the ARRAY statement have in the Program Data Vector(PDV)?

  A. No variable are created in the PDV
  B. The variables named POINTS10, POINTS15, POINTS20, POINTS25, POINTS30, POINTS35 are created in the PDV
  C. The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV
  D. The variables named POINTS11, POINTS12, POINTS21, POINTS22, POINTS23 are created in the PDV
  C. The variables named POINTS1, POINTS2, POINTS3 POINTS4, POINTS5, POINTS6 are created in the PDV

• Question 72:

  The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X.

  Which one of the following SAS programs uses the index to select observations from the data set ONE?

  A. data two; set three; set one key = X; run;
  B. data two; set three key = X; set one; run;
  C. data two; set one; set three key = X; run;
  D. data two; set three; set one (key = X); run;
  A. data two; set three; set one key = X; run;

• Question 73:

  Given the following scenario:

  The SAS libraries LIBRARY and MYLIB are successfully defined in your current SAS session.

  There is a SAS Data Set named WORK.GENDERS with a column called MF containing single character values.

  The SAS program on the left is submitted and the desired output is shown in the right.

  

  Which statement is true?

  A. The statement OPTIONS FMTSEARCH = (Mylib Library); is required before the PRINT procedure to attain the resulting output
  B. The statement OPTIONS FMSEARCH = (Library Mylib); is required before the PRINT procedure to attain the resulting output
  C. No OPTIONS FMSEARCH ( ) statement is needed to attain resulting output
  D. The statement OPTIONS FMSEARCH = (Mylib); is required before the print procedure to attain the resulting output
  D. The statement OPTIONS FMSEARCH = (Mylib); is required before the print procedure to attain the resulting output

• Question 74:

  This question will ask you to provide missing option.

  

  Which option is required to complete the program correctly?

  A. CAMPLIB
  B. FMTSEARCH
  C. LIBREF
  D. UTILLOC
  C. LIBREF

• Question 75:

  Given the SAS data set ONE: ONE REP COST SMITH 200 SMITH 400 JONES 100 SMITH 600 JONES 100 The following SAS program is submitted: Proc sql; Select rep, avg(cost) as AVERAGE From one Group by rep quit; The following output is desired:

  

  Which SQL procedure clause completes the program and generates the desired output?

  A. having avg(cost) < select avg(cost) from one);
  B. Having avg(cost)>(select avg(cost) from one);
  C. Where avg(cost)>(select avg(cost) from one);
  D. Where calculated average > (select avg(cost) from one);
  B. Having avg(cost)>(select avg(cost) from one);

• Question 76:

  Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

  A. andRC
  B. andERR
  C. andSYSRC
  D. andSYSERR
  D. andSYSERR

• Question 77:

  The following SAS program is submitted:

  %macro execute;

  proc print data = sasuser.houses;

  run;

  %end;

  %mend;

  Which of the following completes the above program so that it executes on Tuesday?

  A. %if andsysday = Tuesday %then %do;
  B. %if andsysday = 'Tuesday' %then %do;
  C. %if "andsysday" = Tuesday %then %do;
  D. %if 'andsysday' = 'Tuesday' %then %do;
  A. %if andsysday = Tuesday %then %do;

• Question 78:

  Given the following SAS data set ONE: ONE REP AREA COST SMITH NORTH 100 SMITH SOUTH 200 JONES EAST 100

  SMITH NORTH 300 JONES WEST 100 JONES NORTH 200 JONES NORTH 400 SMITH NORTH 400 JONES WEST 100 JONES WEST 300 The following SAS program is submitted: proc sql; select rep, area, count(*) as TOTAL from one group by rep, area; quit; Which one of the following reports is generated?

  A. REP AREA COUNT JONES EAST 100 JONES NORTH 600 JONES WEST 500 SMITH NORTH 800 SMITH SOUTH 200
  B. REP AREA TOTAL JONES EAST 100 JONES NORTH 600 JONES WEST 500 SMITH NORTH 800 SMITH SOUTH 200
  C. REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1
  D. REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1 SMITH NORTH 3 SMITH SOUTH 1
  C. REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1
  D. REP AREA TOTAL JONES EAST 1 JONES NORTH 2 JONES WEST 3 SMITH NORTH 3 SMITH SOUTH 1 SMITH NORTH 3 SMITH SOUTH 1

• Question 79:

  Given a SAS data set with the following characteristics:

  200 million observations 300 variables Compressed Resides on a network location

  A SAS DATA Step program is written that will retrieve 20% of the data using a search based on a range of a character variable.

  Which type of statement is the best choice to minimize computer resource utilization when subsetting this data?

  A. KEEP/DROP
  B. WHERE
  C. CASE
  D. IF/THEN/ELSE
  A. KEEP/DROP

• Question 80:

  Given the following SAS data set ONE: ONE JOB LEVEL SALARY ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400 The following SAS data set TWO is created: TWO JOB LEVEL BONUS ACC 2 30 MGR 3 70 MGR 2 40 Which one of the following SAS programs creates data set TWO?

  A. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where bonus > 20; quit;
  B. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where salary > 20; quit;
  C. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated salary * 0.1 > 20; quit;
  D. proc sql;D.proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated bonus > 20; quit;
  D. proc sql;D.proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated bonus > 20; quit;