SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 71:

  When is it appropriate to create indexes on a SAS data set for efficient processing?

  A. if small subsets of data are often retrieved
  B. if the key variable has very few unique values
  C. if the data are often used for BY group processing
  D. if the SAS data set file page count is less than three pages
  A. if small subsets of data are often retrieved

• Question 72:

  The following SAS program is submitted:

  data temp;

  array points{3,2}_temporary_ (10,20,30,40,50,60); score = points{2,1}

  run;

  Which one of the following is the value of the variable SCORE in the data set TEMP?

  A. 10
  B. 20
  C. 30
  D. 40
  C. 30

• Question 73:

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

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

  The following SAS program is submitted:

  proc datasets lib = testdata;

  modify one;

  label num = 'Number';

  format num 4.;

  quit;

  Which one of the following SQL programs produces the same results as the above DATASETS procedure?

  A. proc sql; modify table testdata.one num format = 4. label = 'Number'; quit;
  B. proc sql; alter table testdata.one modify num format = 4. label = 'Number'; quit;
  C. proc sql; modify table testdata.one alter num format = 4. label = 'Number'; quit;
  D. proc sql; alter table testdata.one modify num (format = 4. label = 'Number'); quit;
  B. proc sql; alter table testdata.one modify num format = 4. label = 'Number'; quit;

• Question 76:

  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.
  C. The KEEP statement applies to all data sets created within the same DATA step.

• Question 77:

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

  The following SAS FORMAT procedure is submitted:

  proc format lib = sasuser;

  value tempc low < 0 = 'BELOW FREEZING'

  0 < 5 = 'COLD'

  5 < 10 = 'MILD'

  10 < 15 = 'WARM'

  15 high = 'HOT';

  run;

  How is the value 10 displayed when the format TEMPC is applied?

  A. 10
  B. MILD
  C. WARM
  D. BELOW FREEZING
  C. WARM

• Question 79:

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

  The following SAS program is submitted:

  %let value = .5;

  %let add = 5;

  %let newval = %eval(andvalue + andadd);

  Which one of the following is the resulting value of the macro variable NEWVAL?

  A. 5
  B. 5.5
  C. .5 + 5
  D. null
  D. null