SASInstitute SAS Institute Systems Certification A00-212 Questions & Answers

• Question 1:

  The following SAS program is submitted:

  %macro check(num=4);

  %let result=%sysevalf(andnum+0.5);

  %put result is andresult;

  %mend;

  %check(num=10)

  What is the written to the SAS log?

  A. result is

  B. result is 10

  C. result is 10.5

  D. result is 10+0.5

  Correct Answer: C

• Question 2:

  The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and The following SAS program is submitted:

  Proc format cntlin=wor.tempdata;

  Run;

  What is the result of submitting the FORMAT procedure step?

  A. It uses the WORK.TEMPDATA SAS data set as input to create the format

  B. All formats created will be stored in two WORK.TEMPDATA SAS data set

  C. An ERROR message is written to the SAS log because the program is incomplete

  D. NO formats are created in this step

  Correct Answer: A

• Question 3:

  The following SAS program is submitted:

  proc contents data = testdata.one;

  run;

  Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA.ONE?

  A. proc sql; Contents table testdata.one; Quit;

  B. proc sql; Describe table testdata.one; Quit;

  C. proc sql; describe testdata.one; Quit;

  D. proc sql; Contents testdata.one; Quit;

  Correct Answer: B

• Question 4:

  What is an advantage of using a hash object in a SAS DATA step?

  A. The hash object persists after the DATA step has executed

  B. The hash object key values can be multiple numeric and character data values

  C. The hash object automatically sorts the data

  D. The hash object does not require unique keys

  Correct Answer: B

• Question 5:

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

  Which SAS System option(s) can aid in benchmarking?

  A. SYSTIMER

  B. IOBLOCKSIZE=

  C. BUFSIZE = and BUFNO=

  D. FULLSTIMER

  Correct Answer: D

  Reference: http://web.utk.edu/sas/OnlineTutor/1.2/en/60477/m80/m80_8.htm

• Question 7:

  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.

  Correct Answer: B

• Question 8:

  The following SAS program is submitted:

  %macro check(num=4);

  %let result=%eval(andnm gt 5);

  %put result is andresult;

  %mend;

  %check (num=10)

  What is written to the SAS log?

  A. result is true

  B. result is 10 gt 5

  C. result is 1

  D. result is 0

  Correct Answer: C

• Question 9:

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

  Given the following SAS data set ONE: ONE JOB LEVEL SALARY ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 . ACC 3 . MGR 2 400 The following SAS data set TWO is created: TWO JOB LEVEL BONUS ACC 2 30 MGR 3 70 MGR 2 40 Which one of the following SAS programs creates data set TWO?

  A. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where bonus > 20; quit;

  B. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where salary > 20; quit;

  C. proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated salary * 0.1 > 20; quit;

  D. proc sql;D.proc sql; create table two as select job, level, salary * 0.1 as bonus from one where calculated bonus > 20; quit;

  Correct Answer: D