SAS Institute SAS Institute Certifications A00-211 Questions & Answers

• Question 201:

  Given the following code:

  proc print data=SASHELP.CLASS(firstobs=5 obs=15);

  where Sex='M';

  run;

  How many observations will be displayed?

  A. 11

  B. 15

  C. 10 or fewer

  D. 11 or fewer

  Correct Answer: D

• Question 202:

  The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:

  

  Which statement is true?

  A. The by statement in the DATA step causes a syntax error.

  B. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.

  C. The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.

  D. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.

  Correct Answer: C

• Question 203:

  Given the contents of the raw data file TYPECOLOR.DAT:

  

  The following SAS program is submitted: What are the values of the variables Type and Color?

  

  A. Type=daisy, Color=yellow

  B. Type=daisy, Color=w

  C. Type=daisy, Color=daisyyellow

  D. Type=daisy, Color=

  Correct Answer: D

• Question 204:

  The following SAS program is submitted:

  

  What new variables are created?

  A. Difcount1, Difcount2 and Difcount3

  B. Diff1, Diff2 and Diff3

  C. Janpt, Febpt, and Marpt

  D. Patients1, Patients2 and Patients3

  Correct Answer: A

• Question 205:

  Given the raw data record in the file phone.txt:

  

  Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?

  A. FullName=CATX(' ',EmpFName,EmpLName);

  B. FullName=CAT(' ',EmpFName,EmpLName);

  C. FullName=EmpFName!!EmpLName;

  D. FullName=EmpFName + EmpLName;

  Correct Answer: A

• Question 206:

  Given the SAS data set PERM.STUDENTS:

  PERM.STUDENTS NAME AGE

  --------- ------- Alfred 14

  Alice 13

  Barbara 13

  Carol 14

  The following SAS program is submitted:

  libname perm `SAS data library';

  data students;

  set perm.students;

  file `file specification';

  put name $ age;

  run;

  The following double-spaced file is desired as output

  Alfred 14

  Alice 13

  Barbara 13

  Carol 14

  Which statement completes the program and creates the desired file?

  A. put

  B. put/;

  C. double;

  D. put _null_;

  Correct Answer: A

• Question 207:

  The following SAS program is submitted:

  data work.total;

  set work.salary(keep = department wagerate);

  by department;

  if first.department

  then payroll = 0;

  payroll + wagerate;

  if last.department;

  run;

  The SAS data set named WORKSALARY contains 10 observations for each department, and is currently

  ordered by DEPARTMENT.

  Which statement is true?

  A. The BY statement in the DATA step causes a syntax error.

  B. The statement payroll + wagerate; in the DATA step causes a syntax error.

  C. The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.

  D. The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.

  Correct Answer: C

• Question 208:

  Given the contents of the raw data file EMPLOYEE:

  ----|----10----|----20----|----30

  Alan 19/2/2004 ACCT

  Rob 22/5/2004 MKTG

  MaryJane 14/3/2004 EDUC

  The following SAS program is submitted:

  data emps;

  infile `employee';

  input@1 name$

  @15 date

  @25 department$;

  run;

  Which INFORMAT correctly completes the program?

  A. date9.

  B. ddmmyyyy9.

  C. ddmmyy10.

  D. ddmmyyyy10.

  Correct Answer: C

• Question 209:

  The following SAS program is submitted:

  data test;

  infile `file specification';

  input name $ amount@@;

  run;

  Which of the following is true?

  A. Two @@ together are the same as one c.

  B. Two @@ hold the data records until the bottom of the DATA step.

  C. Two @@ hold the raw data record across iterations of the DATA step.

  D. Two @@ are invalid syntax and will cause the program to fail to execute.

  Correct Answer: C

• Question 210:

  Given the SAS data set QTR 1_REVENUE:

  destination revenue YYZ 53634 FRA 62129 FRA 75962 RDU 76254 YYZ 82174

  The following SAS program is submitted:

  proc sort data = qtr1_revenue; by destination descending revenue; run;

  What is the first observation in the output data set?

  A. destination revenue FRA 62129

  B. destination revenue FRA 75962

  C. destination revenue YYZ 53634

  D. destination revenue YYZ 82174

  Correct Answer: B