SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 171:

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

  The following SAS program is submitted:

  proc sort data = sales tagsort;

  by month year;

  run;

  Which of the following resource(s) is the TAGSORT option reducing?

  A. I/O usage only
  B. CPU usage only
  C. I/O and CPU usage
  D. temporary disk usage
  D. temporary disk usage

• Question 173:

  Given the data set shown in the left, the SAS program on the right is submitted.

  

  Which program will result in the identical report?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 174:

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

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

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

  The following are values of the variable STYLE from the SAS data set SASUSER.HOUSES: SASUSERS.HOUSES OBS STYLE

  1 RANCH 2 SPLIT 3 CONDO 4 TWOSTORY 5 RANCH 6 SPLIT 7 SPLIT The following SAS program is submitted: proc sql noprint; select distinct style into :styles separated by ' ' from sasuser.houses order by style; quit; Which one of the following is the value of the resulting macro variable?

  A. CONDO RANCH SPLIT TWOSTORY
  B. RANCH SPLIT CONDO TWOSTORY
  C. CONDO RANCH RANCH SPLIT SPLIT SPLIT TWOSTORY
  D. RANCH SPLIT CONDO TWOSTORY RANCH SPLIT SPLIT
  A. CONDO RANCH SPLIT TWOSTORY

• Question 178:

  Given the following SAS data sets ONE and TWO: ONE TWO NUM CHAR1 NUM CHAR2 1 A 2 X

  2 B 3 Y 4 D 5 V The following SAS program is submitted creating the output table THREE: data three;

  set one two;

  run;

  THREE

  NUM CHAR1 CHAR2

  1 A

  2 B

  4 D

  2 X

  3 Y

  5 V

  Which one of the following SQL programs creates an equivalent SAS data set THREE?

  A. proc sql; create table three as select * from one outer union corr select * from two; quit;
  B. proc sql; create table three as select * from one outer union select * from two; quit;
  C. proc sql; create table three as select * from one outer union select * quit;
  D. proc sql; create table three as select * from one union corr select * from two; quit;
  A. proc sql; create table three as select * from one outer union corr select * from two; quit;

• Question 179:

  Given the following SAS data set ONE: ONE CATEGORY AGE SALARY BONUS

  M 28 200 .

  M 25 100 10

  F 18 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 180:

  Given has SAS dataset ONE:

  

  The following SAS program is submitted:

  

  Proc sql;

  from one;

  quit;

  The following output is desired:

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

  A. Select salary, salary*.10 var=BONUS
  B. Select salary, salary*.10 label='BONUS'
  C. Select salary, salary *.10 column='BONUS'
  D. Select salary, salary*.10 name='BONUS'
  B. Select salary, salary*.10 label='BONUS'