SAS Institute SAS Institute Certifications A00-201 Questions & Answers

• Question 91:

  The contents of the SAS data set PERM.JAN_SALES are listed below:

  A comma delimited raw data tile needs to be created from the PERM.JAN_SALES data set.

  VARIABLE NAME TYPE idnum character variable sales_date numeric date value

  The SALES_DATE values need to be in a MMDDYY10 form.

  Which one of the following SAS DATA steps correctly creates this raw data file?

  A. libname perm `SAS-data-library'; data_null; set perm.jan_sales; file `file-specification' dsd = `,'; put idnum sales_date: mmddyy10.; run;

  B. libname perm `SAS-data-library'; data_null_; set perm.jan_sales; file `file-specification' dIm = `,'; put idnum sales_date : mmddyy10.; run;

  C. libname perm `SAS-data-library'; data_null_; set perm.jan_sales; file `file-specification'; put idnum sales_date : mmddyq10.dIm = `,'; run;

  D. libname perm `SAS-data-library"; data_null_; set perm jan_sales; file `file-specification'; put idnum sales_date: mmddyy10. dsd = `,'; put idnum sales_date: mmddw10. dsd = `,'; run;

  Correct Answer: B

• Question 92:

  The SAS data sets WORKEMPLOYEE and WORKSALARY are shown below:

  WORK.EMPLOYEE WORK.SALARY

  fname age fname salary

  Bruce 30 Bruce 25000

  Dan 40 Bruce 35000

  Dan 25000

  The following SAS program is submitted:

  data work.empdata;

  by fname;

  totsal + salary;

  run;

  Which one of the following statements completes the merge of the two data sets by the ENAME variable?

  A. merge work.employee work.salary (fname = name);

  B. merge work.employee work.salary (name = fname);

  C. merge work.employee work.salary (rename = (fname = name));

  D. merge work.employee work.salary (rename = (name = fname));

  Correct Answer: D

• Question 93:

  The following SAS program is submitted:

  proc sort data = sasuser.houses out = houses;

  by style;

  run;

  proc print data = houses;

  run;

  Click on the Exhibit button to view the report produced.

  

  Which of the following SAS statement(s) create(s) the report?

  A. id style;

  B. id style; var style bedrooms baths price;

  C. id style; by style; var bedrooms baths price;

  D. id style; by style; var style bedrooms baths price;

  Correct Answer: C

• Question 94:

  Which one of the following SAS statements correctly computes the average of four numerical values?

  A. average = mean(num1 - num4);

  B. average = mean(of num1 - num4)

  C. average = mean(of num1 to num4);

  D. average = mean(num1 num2 num3 num4);

  Correct Answer: B

• Question 95:

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

  A. TIME

  B. DATE

  C. TODAY

  D. DATETIME

  Correct Answer: B

• Question 96:

  Which one of the following is true of the SUM statement in a SAS DATA step program?

  A. It is only valid in conjunction with a SUM function.

  B. It is not valid with the SET, MERGE and UPDATE statements.

  C. It adds the value of an expression to an accumulator variable and ignores missing values.

  D. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.

  Correct Answer: C

• Question 97:

  The following SAS program is submitted:

  data work january;

  set work.allmonths (keep = product month num_sold cost); if month = `Jan' then output work.january;

  sales = cost * num_sold; keep product sales;

  run;

  Which variables does the WORK.JANUARY data set contain?

  A. PRODUCT and SALES only

  B. PRODUCT, MONTH, NUM_SOLD and COST only

  C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only

  D. An incomplete output data set is created due to syntax errors.

  Correct Answer: D

• Question 98:

  Which one to the following SAS procedures displays the data portion of a SAS data set?

  A. PRINT

  B. FSLIST

  C. CONTENTS

  D. DATASETS

  Correct Answer: A

• Question 99:

  The following SAS DATA step is submitted:

  data work.accounting; set work.department; length jobcode $ 12; run;

  The WORK.DEPARTMENT SAS data set contains a character variable named JOSCODE with a length of 5.

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

  A. 5

  B. 8

  C. 12

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

  Correct Answer: A

• Question 100:

  The following SAS program is submitted:

  data work.totalsales;

  set work.monthlysales(keep = year product sales);

  retain monthsales {12};

  array monthsales {12};

  do i = 1 to 12;

  monthsales{i} = sales;

  end;

  cnt + 1;

  monthsales{cnt} = sales;

  run;

  The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.

  Which one of the following is the result of the above program?

  A. The program fails execution due to data errors.

  B. The program fails execution due to syntax errors.

  C. The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.

  D. The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations.

  Correct Answer: B