SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 151:

  Given the SAS data set ONE: ONE

  NUM VAR 1 A

  2 B

  3 C

  Which SQL procedure program deletes the data set ONE?

  A. proc sql; Drop table one; Quit;
  B. proc sql; Remove table one; Quit;
  C. proc sql; Delete table one; Quit;
  D. proc sql; Delete from one; Quit;
  A. proc sql; Drop table one; Quit;

• Question 152:

  The DICTIONARY.MACROS table stores information about which of the following?

  A. user defined macro variables only
  B. system defined macro variables only
  C. both user and system defined macro variables
  D. macros stored in the autocall macro library only
  C. both user and system defined macro variables

• Question 153:

  Given the SAS data sets ONE and TWO:

  

  The following SAS program is submitted:

  Proc sql;

  Select two.*,budget from one two on one.year=two.year,

  Quit;

  The following output is desired:

  

  Which JOIN operator completes the program and generates the desired output?

  A. FULL JOIN
  B. INNER JOIN
  C. LEFT JOIN
  D. RIGHT JOIN
  A. FULL JOIN

• Question 154:

  Given the data set SASHELP.CLASS:

  

  The following SAS program is submitted:

  

  The PROC steps execute successfully?

  A. PROC PRINT only
  B. PROC MEANS and PROC PRINT
  C. PROC MEANS only
  D. No PROC steps execute successfully
  C. PROC MEANS only

• Question 155:

  Which one of the following SAS programs displays the descriptor portion of each data set stored in the SASUSER library?

  A. proc datasets lib = sasuser.all; quit;
  B. proc datasets lib = sasuser._all_; quit;
  C. proc datasets lib = sasuser; contents data = all; quit;
  D. proc datasets lib = sasuser; contents data = _all_; quit;
  D. proc datasets lib = sasuser; contents data = _all_; quit;

• Question 156:

  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 = "andLoc";

  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 is generated as the case of the compared values is different.
  C. No report is generated as the case of the macro variable name is different.
  D. A report is generated with the two original observations as the where clause does not work.
  B. No report is generated as the case of the compared values is different.

• Question 157:

  Consider the following SAS log:

  229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;

  230 set sasuser.houses;

  231 if style = 'RANCH' then output sasuser.ranch;

  232 else if style = 'CONDO' then output sasuser.condo;

  233 run;

  NOTE: DATA STEP view saved on file SASUSER.RANCH.

  NOTE: A stored DATA STEP view cannot run under a different operating system.

  235 proc print data = sasuser.condo;

  ERROR: File SASUSER.CONDO.DATA does not exist.

  236 run;

  NOTE: The SAS System stopped processing this step because of errors.

  Which one of the following explains why the PRINT procedure fails?

  A. SASUSER.CONDO is a stored DATA step program.
  B. A SAS data file and SAS data view cannot be created in the same DATA step.
  C. A second VIEW=SASUSER.CONDO option was omitted on the DATA statement.
  D. The view SASUSER.RANCH must be processed before SASUSER.CONDO is created.
  D. The view SASUSER.RANCH must be processed before SASUSER.CONDO is created.

• Question 158:

  Given the following SAS data set ONE: ONE

  COUNTRY CITY VISIT

  USA BOSTON 10

  UK LONDON 5

  USA DALLAS 10

  UK MARLOW 10

  USA BOSTON 20

  UK LONDON 15

  USA DALLAS 10

  The following SAS program is submitted:

  proc sql;

  select country, city, sum(visit) as TOTAL

  from one

  group by country, city

  order by country, total desc;

  quit;

  Which one of the following reports is generated?

  A. COUNTRY CITY TOTAL UK MARLOW 10 UK LONDON 20 USA BOSTON 50 USA DALLAS 20
  B. COUNTRY CITY TOTAL UK LONDON 20 UK MARLOW 10 USA BOSTON 50 USA DALLAS 20
  C. COUNTRY CITY TOTAL USA BOSTON 50
  D. COUNTRY CITY TOTAL UK MARLOW 10 UK LONDON 20 USA DALLAS 20 USA BOSTON 50
  B. COUNTRY CITY TOTAL UK LONDON 20 UK MARLOW 10 USA BOSTON 50 USA DALLAS 20

• Question 159:

  Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?

  A. It temporarily compresses observations in a SAS data set.
  B. It allows users to update the same SAS data set concurrently.
  C. It allows new observations to be inserted wherever enough free space exists.
  D. It specifies that a new empty data set with a given name replaces an existing data set with the same name.
  C. It allows new observations to be inserted wherever enough free space exists.

• Question 160:

  This question will ask you to provide a missing reference. Given the SAS data set SASUSER HIGHWAY:

  

  The following SAS program is submitted:

  

  What macro variable reference completes the program to create the WORK.NOT and WORK SERIOUS data sets?

  A. and Status and Count
  B. and and Status and i
  C. and and Status and Count
  D. and Status and i
  B. and and Status and i