SAS Institute A00-202 Online Practice Questions and Exam Preparation

SAS Institute A00-202 Online Questions & Answers

• Question 51:

  Which one of the following is an advantage of creating and using a SAS DATA step view?

  A. It can store an index.
  B. It always accesses the most current data.
  C. It works quickly through multiple passes of the data.
  D. It is useful when the underlying data file structure changes.
  B. It always accesses the most current data.

• Question 52:

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

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

  Given the following SAS data set ONE:

  ONE

  CATEGORY AGE SALARY BONUS

  --------------------------------------------------- M 28 200 .

  M 25 100 10

  F 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
  B. CATEGORY EARNINGS M . M 110 F 150 F 210
  C. CATEGORY SALARY BONUS EARNINGS --------------------------------------------------------------- M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210
  D. CATEGORY SALARY BONUS EARNINGS M 200 . . M 100 10 110 M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210
  B. CATEGORY EARNINGS M . M 110 F 150 F 210

• Question 55:

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

  Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

  A. MODIFY
  B. FORMAT
  C. CONTENTS
  D. DATASETS
  D. DATASETS

• Question 57:

  The variable attributes of SAS data sets ONE and TWO are shown below:

  ONE TWO

  # Variable Type Len Pos # Variable Type Len Pos

  2 sales Num 8 8 2 budget Num 8 8

  1 year Num 8 0 3 sales Char 8 16

  1 year Num 8 0

  Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR. The following SAS program is submitted:

  data three;

  merge one two;

  by year;

  run;

  Which one of the following is the result of the program execution?

  A. No messages are written to the SAS log.
  B. ERROR and WARNING messages are written to the SAS log.
  C. Data set THREE is created with two variables and 50 observations.
  D. Data set THREE is created with three variables and 100 observations.
  B. ERROR and WARNING messages are written to the SAS log.

• Question 58:

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

  The following SAS program is submitted.

  filename sales ('external-file1' 'external-file2'); data new;

  infile sales;

  input date date9. company $ revenue;

  run;

  Which one of the following is the result of including the FILENAME statement in this program?

  A. The FILENAME statement produces an ERROR message in the SAS log.
  B. The FILENAME statement associates SALES with external-file2 followed by external-file1.
  C. The FILENAME statement associates SALES with external-file1 followed by external-file2.
  D. The FILENAME statement reads record 1 from external-file 1, reads record 1 from external-file 2, and combines them into one record.
  C. The FILENAME statement associates SALES with external-file1 followed by external-file2.

• Question 60:

  The following SAS program is submitted:

  data one;

  do i = 1 to 10;

  ptobs = ceil(ranuni(0) * totobs);

  set temp point = ptobs

  nobs = totobs;

  output;

  end;

  stop;

  run;

  The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?

  A. any integer between 1 and 10
  B. any real number between 0 and 1
  C. any integer between 1 and 2,500,000
  D. any real number between 1 and 2,500,000
  C. any integer between 1 and 2,500,000