SASInstitute SAS Institute Systems Certification A00-201 Questions & Answers

• Question 1:

  The SASDATA.BANKS data set has five observations when the following SAS program is submitted; libname sasdata `SAS-data-library';

  data allobs;

  set sasdata.banks;

  capitaI=0;

  do year = 2000 to 2020 by 5;

  capital + ((capital+2000) * rate);

  output;

  end;

  run;

  How many observations will the ALLOBS data set contain?

  A. 5

  B. 15

  C. 20

  D. 25

  Correct Answer: D

• Question 2:

  The following SAS program is submitted:

  data work.test;

  Author = `Agatha Christie';

  First = substr(scan(author,1,' ,`)1 ,1);

  run;

  Which one of the following is the length of the variable FIRST in the output data set?

  A. 1

  B. 6

  C. 15

  D. 200

  Correct Answer: D

• Question 3:

  The following SAS program is submitted: I

  ibname company `SAS-data-library';

  proc sort data = company.payroll;

  by EmployeelDNumber;

  run;

  Write access has been granted to the COMPANY library.

  Which one of the following represents how the observations are sorted?

  A. COMPANY.PAYROLL is recreated in sorted order by EmployeelDNumber.

  B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeelDNumber.

  C. COMPANYPAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeelDNumber.

  D. COMPANY.PAYROLL is recreated in sorted order by EmployeelDNumber, and a new data set PAYROLL is created in sorted order by Emp loyeelDNumber.

  Correct Answer: A

• Question 4:

  The following SAS program is submitted:

  data work.test;

  set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 - ditsales3;

  array monthly{3} jansales febsales marsales;

  run;

  Which one of the following represents the new variables that are created?

  A. JANSALES, FEBSALES and MARSALES

  B. MONTHLY1, MONTHLY2 and MONTHLY3

  C. DIFSALES1, DIFSALES2 and DIFSALES3

  D. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3

  Correct Answer: C

• Question 5:

  The following SAS program is submitted:

  data work.accounting; set work.dept1 work.dept2; run;

  A character variable named JOBCOE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set.

  Which one of the following is the length of the variable JOBCODE in the output data set?

  B. 7

  C. 8

  D. 12

  Correct Answer: A

• Question 6:

  The contents of the raw data file NAMENUM are listed below: ----I----10---I----20---I----30 Joe xx

  The following SAS program is submitted:

  data test; infile `namenum'; input name $ number; run;

  Which one of the following is the value of the NUMBER variable?

  A. xx

  B. Joe

  C. (missing numeric value)

  D. The value can not be determined as the program fails to execute due to errors.

  Correct Answer: C

• Question 7:

  The following SAS program is submitted:

  libname sasdata `SAS-data-library';

  data test;

  set sasdata.chemists (keep = job_code);

  if job_code `chem3'

  then description = `Senior Chemist';

  run;

  The variable JOB_CODE is a character variable with a length of 6 bytes.

  Which one of the following is the length of the variable DESCRIPTION in the output data set?

  A. 6 bytes

  B. 8 bytes

  C. 14bytes

  D. 200 bytes

  Correct Answer: C

• Question 8:

  The SAS data sets WORK.EMPLOYEE and WORKSALARY are listed below:

  WORK.EMPLOYEE WORK. SALARY

  name age name salary

  Bruce 30 Bruce 25000

  Dan 40 Bruce 35000

  Dan 25000

  The following SAS program is submitted:

  data work.empdata;

  merge work.employee

  work.salary;

  by fname;

  totsal + salary;

  run;

  How many variables are output to the WORK.EMPDATA data set?

  A. 3

  B. 4

  C. 5

  D. No variables are output to the data set as the program fails to execute due to errors.

  Correct Answer: B

• Question 9:

  The following SAS program is submitted:

  data work.staff; JobCategory' = `FA'; JobLevel = `1';

  JobCategory = JobCategory || JobLevel; run;

  Which one of the following is the value of the variable JOSCATEGORY in the output data set?

  A. FA

  B. FA1

  C. FA1

  D. ``(missing character value)

  Correct Answer: A

• Question 10:

  The SAS data set BANKS is listed below:

  BANKS

  name rate

  FirstCapital 0.0718

  DirectBank 0.0721

  VirtualDirect 0.0728

  The following SAS program is submitted:

  data newbank;

  do year = 1 to 3;

  set banks;

  capital + 5000;

  end;

  run;

  Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?

  A. 0 observations and 0 variables

  B. 1 observations and 4 variables

  C. 3 observations and 3 variables

  D. 9 observations and 2 variables

  Correct Answer: B