SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 81:

  Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?

  A. CHECK
  B. UNIQUE
  C. FORMAT
  D. DISTINCT
  A. CHECK

• Question 82:

  Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

  A. RENAME statement only
  B. CHANGE statement only
  C. MODIFY and RENAME statements
  D. MODIFY and CHANGE statements
  B. CHANGE statement only

• Question 83:

  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 84:

  Given the following SAS data set ONE:

  ONE REP COST

  SMITH 200

  SMITH 400

  JONES 100

  SMITH 600

  JONES 100

  JONES 200

  JONES 400

  SMITH 800

  JONES 100

  JONES 300

  The following SAS program is submitted:

  proc sql;

  select rep, avg(cost) as AVERAGE

  from one group by rep

  having avg(cost) > (select avg(cost) from one);

  quit;

  Which one of the following reports is generated?

  A. REP AVERAGE JONES 200
  B. REP AVERAGE JONES 320
  C. REP AVERAGE SMITH 320
  D. REP AVERAGE SMITH 500
  D. REP AVERAGE SMITH 500

• Question 85:

  Given the following SAS data sets ONE and TWO:

  ONE TWO NUM COUNTRY NUM CITY

  1 CANADA 3 BERLIN

  2 FRANCE 5 TOKYO

  3 GERMANY 4 BELGIUM

  5 JAPAN

  The following SAS program is submitted:

  proc sql;

  select country from one where not exists

  (select * from two where one.num = two.num);

  quit;

  Which one of the following reports is generated?

  A. COUNTRY GERMANY JAPAN
  B. COUNTRY FRANCE BELGIUM
  C. COUNTRY CANADA FRANCE BELGIUM
  D. COUNTRY CANADA FRANCE GERMANY
  C. COUNTRY CANADA FRANCE BELGIUM

• Question 86:

  Which one of the following statements is true?

  A. The WHERE statement can be executed conditionally as part of an IF statement.
  B. The WHERE statement selects observations before they are brought into the PDV.
  C. The subsetting IF statement works on observations before they are read into the PDV.
  D. The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.
  B. The WHERE statement selects observations before they are brought into the PDV.

• Question 87:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  YEAR QTR BUDGET YEAR QTR SALES

  ------------------------------ ---------------------------- 2001 3 500 2001 4 300

  2001 4 400 2002 1 600

  2002 1 700

  The following SAS program is submitted:

  proc sql;

  select one.*, sales

  from one, two;

  quit;

  Which one of the following reports is generated?

  A. YEAR QTR BUDGET SALES 2001 4 400 300 2002 1 700 600
  B. YEAR QTR BUDGET SALES 2001 3 500 . 2001 4 400 300 2002 1 700 600
  C. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600
  D. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600
  D. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600

• Question 88:

  The following SAS program is submitted:

  options yearcutoff = 1950;

  %macro y2kopt(date);

  %if anddate >= 14610 %then %do;

  options yearcutoff = 2000;

  %end;

  %else %do;

  options yearcutoff = 1900;

  %end;

  %mend;

  data _null_ ;

  date = "01jan2000"d;

  call symput("date",left(date));

  run;

  %y2kopt(anddate)

  The SAS date for January 1, 2000 is 14610 and the SAS system option for YEARCUTOFF is set to 1920 prior to submitting the above program.

  Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

  A. 1900
  B. 1920
  C. 1950
  D. 2000
  D. 2000

• Question 89:

  The following SAS ARRAY statement is submitted: array score{*} a4 - a10, a25 ;

  Which one of the following is the maximum number of elements stored?

  A. 3
  B. 7
  C. 8
  D. 11
  C. 8

• Question 90:

  The following SAS code is submitted:

  %macro houses(dsn = houses,sub = RANCH);

  data anddsn;

  set sasuser.houses;

  if style = "andsub";

  run;

  %mend;

  %houses(sub = SPLIT)

  %houses(dsn = ranch)

  %houses(sub = TWOSTORY)

  Which one of the following is the value of the automatic macro variable SYSLAST?

  A. work.ranch
  B. work.houses
  C. WORK.RANCH
  D. WORK.HOUSES
  D. WORK.HOUSES