SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 111:

  The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:

  EMPLOYEE SALARY

  name age name salary

  Bruce 30 Bruce 40000

  Dan 35 Bruce 35000

  Dan 37000

  Dan .

  The following SAS program is submitted:

  data work.empsalary;

  merge work.employee (in = inemp)

  work.salary (in = insal);

  by name;

  if inemp and insal;

  run;

  How many observations will the data set WORK.EMPSALARY contain?

  A. 2
  B. 4
  C. 5
  D. 6
  B. 4

• Question 112:

  The following SAS program is submitted:

  data numrecords;

  infile `file specification';

  input@1 patient $15.

  relative$ 16-26@;

  if relative = `children' then

  input @54 diagnosis $15. @;

  else if relative = `parents' then

  input @28 doctor $15.

  clinic $ 44-53

  @54 diagnosis $15. @;

  input age;

  run;

  How many raw data records are read during each iteration of the DATA step execution?

  A. 1
  B. 2
  C. 3
  D. 4
  B. 2

• Question 113:

  Which one of the following SAS system options displays the time on a report?

  A. TIME
  B. DATE
  C. TODAY
  D. DATETIME
  B. DATE

• Question 114:

  The following SAS program is submitted:

  <_insert_ods_code_>

  proc means data=SASUSER.SHOES;

  where Product in ('Sandal' , 'Slipper' , 'Boot');

  run;

  <_insert_ods_code_>

  Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?

  A. ods html open='sales.html'; ods html close;
  B. ods file='sales.html' / html; ods file close;
  C. ods html file='sales.html'; ods html close;
  D. ods file html='sales.html'; ods file close;
  C. ods html file='sales.html'; ods html close;

• Question 115:

  Given the data set WORK.DEPARTMENTS:

  

  The following SAS program is submitted:

  

  

  Which output will be generated?

  B. C. D.
  B. C. D.

• Question 116:

  Given the following raw data record:

  07Jan2005

  Which INFORMAT reads this raw data and stores it as a SAS date value?

  A. dmy9.
  B. date9.
  C. ddMMMyy9.
  D. ddmmmyyyy9.
  B. date9.

• Question 117:

  Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable Month:

  

  The following SAS program is submitted:

  proc sort data=WORK.TEMPS; by Day descending Month; run;

  proc print data=WORK.TEMPS; run;

  Which output is correct?

  

  A. B.
  C. D.
  B

• Question 118:

  The following SAS program is submitted:

  data work.company; set work.dept1(keep = jobcode) work.dept2(rename = (jcode = jobcode)); run;

  Which one of the following is the result?

  A. The variable JCODE is written to the output data set.
  B. The variable JOBCODE is written to the output data set.
  C. Neither variable JCODE nor JOBCODE is written to the output data set.
  D. The program fails to execute due to errors.
  B. The variable JOBCODE is written to the output data set.

• Question 119:

  A user-defined format has been created using the FORMAT procedure. How is it stored?

  A. in a SAS catalog
  B. in a memory resident lookup table
  C. in a SAS data set in the WORK library
  D. in a SAS dataset in a permanent SAS data library
  A. in a SAS catalog

• Question 120:

  This question will ask you to provide a segment of missing code. Given the SAS data set WORK.ONE:

  

  The following SAS program is submitted:

  

  The data set WORK.TWO is created, where Day would be the day of the month:

  

  Which expression successfully completed the program and creates the variable Day?

  A. day(BeginDate)
  B. weekday(BeginDate)
  C. dayofmonth(BeginDate)
  D. getday(BeginDate)
  B. weekday(BeginDate)