SASInstitute SAS Institute Systems Certification A00-202 Questions & Answers

• Question 11:

  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.

  Correct Answer: C

• Question 12:

  Which one of the following options controls the pagesize of a SAS data set?

  A. SIZE=

  B. BUFNO=

  C. BUFSIZE=

  D. PAGESIZE=

  Correct Answer: C

• Question 13:

  Given the following SAS data set ONE:

  ONE

  CATEGORY AGE SALARY BONUS

  ----------------------------------------------------- M 28 200 20

  M 25 100 10

  M 28 300 10

  M 33 300 30

  F 18 100 50

  F 25 200 10

  F 35 400 50

  The following SQL program is submitted:

  proc sql;

  create table two as

  select distinct age

  from one

  where age < 33;

  quit;

  How many rows are written to the SAS data set TWO?

  A. 3

  B. 4

  C. 5

  D. 6

  Correct Answer: A

• Question 14:

  The following SAS program is submitted:

  data two;

  y = '2';

  run;

  %let x = 10;

  %let var = y;

  data one;

  set two (keep = andvar);

  z = andvar * andx;

  run;

  Which one of the following is the value of the variable Z when the program finishes execution?

  A. _ERROR_

  B. 20 (as a numeric)

  C. 20 (as a character)

  D. . (missing numeric)

  Correct Answer: B

• Question 15:

  Given the following SAS statement: %let idcode = Prod567;

  Which one of the following statements stores the value 567 in the macro variable CODENUM?

  A. %let codenum = substr(andidcode,length(andidcode)-2);

  B. %let codenum = substr(andidcode,length(andidcode)-3);

  C. %let codenum = %substr(andidcode,%length(andidcode)-2);

  D. %let codenum = %substr(andidcode,%length(andidcode)-3);

  Correct Answer: C

• Question 16:

  The following SAS program is submitted:

  %let a = cat;

  %macro animal(a = frog);

  %let a = bird;

  %mend;

  %animal(a = pig)

  %put a is anda;

  Which one of the following is written to the SAS log?

  A. a is anda

  B. a is cat

  C. a is pig

  D. a is bird

  Correct Answer: B

• Question 17:

  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.

  Correct Answer: C

• Question 18:

  In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

  A. data three; set one; set two key = char1; run;

  B. data three; set one; if char1 in ('new york' 'los angeles'); run;

  C. data three; set one; where char1 in ('new york' 'los angeles'); run;

  D. proc sql; create table three as select * from one, two where one.char1 > two.char1; quit;

  Correct Answer: A

• Question 19:

  The following SAS program is submitted:

  %let first = yourname;

  %let last = first;

  %put andandandlast;

  Which one of the following is the result in the log of the %PUT statement?

  A. first

  B. andfirst

  C. yourname

  D. andyourname

  Correct Answer: C

• Question 20:

  Given the following SAS data set ONE:

  ONE DIVISION SALES

  A 1234

  A 3654

  B 5678

  The following SAS program is submitted:

  data _null_;

  set one;

  by division;

  if first.division then

  call symput('mfirst',sales);

  if last.division then

  call symput('mlast',sales);

  run;

  Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?

  A. null

  B. 1234

  C. 3654

  D. 5678

  Correct Answer: D