SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 141:

  The contents of the raw data file CALENDAR are listed below:

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

  01012000

  The following SAS program is submitted:

  data test;

  infile 'calendar';

  input @1 date mmddyy10.;

  if date = '01012000'd then event = 'January 1st';

  run;

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

  A. 01012000
  B. January 1st
  C. . (missing numeric value)
  D. The value can not be determined as the program fails to execute due to errors
  D. The value can not be determined as the program fails to execute due to errors

• Question 142:

  The following program is submitted:

  proc contents data=_all_;

  Which statement best describes the output from the submitted program?

  A. The output displays only a list of the SAS data sets that are contained in the WORK library.
  B. The output displays only the contents of the SAS data sets that are contained in the WORK library.
  C. The output displays only the variables in the SAS data sets that are contained in the WORK library.
  D. The output displays a list of the SAS data sets that are contained in the WORK library and displays their contents.
  D. The output displays a list of the SAS data sets that are contained in the WORK library and displays their contents.

• Question 143:

  Given the SAS data set WORK.ORDERS:

  

  The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".

  Which of the following statement will correctly create the value and assign it to ship_note?

  A. ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);
  B. ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);
  C. ship_note=catx(' ','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);
  D. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);
  D. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);

• Question 144:

  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.
  C. The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.

• Question 145:

  This questions will ask you to provide two missing variable names.

  The following SAS program is submitted:

  data WORK.TOTAL;

  set WORK.SALARY;

  by Department Gender;

  if First. then Payroll=0

  Payroll+Wagerate;

  if Last.;

  run;

  The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

  variable 2: Department

  A. variable 1: Gender
  B. variable 1: Gender variable 2: Gender
  C. variable 1: Department variable 2: Gender variable 2: Department
  D. variable 1: Department
  B. variable 1: Gender variable 2: Gender

• Question 146:

  The following SAS program is submitted:

  data _null_;

  set old (keep = prod sales1 sales2);

  file 'file-specification';

  put sales1 sales2;

  run;

  Which one of the following default delimiters separates the fields in the raw data file created?

  A. : (colon)
  B. (space)
  C. , (comma)
  D. ; (semicolon)
  B. (space)

• Question 147:

  The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY. The following SAS program is submitted:

  proc sort data = work.test out = work.testsorted;

  by name;

  run;

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

  A. The data set WORK.TEST is stored in ascending order by values of the NAME variable.
  B. The data set WORK.TEST is stored in descending order by values of the NAME variable.
  C. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.
  D. The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable.
  C. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.

• Question 148:

  The following SAS program is submitted:

  data test;

  set sasuser.employees;

  if 2 le years_service le 10 then

  amount = 1000;

  else amount = 0;

  amount_per_year = years_service / amount

  run;

  What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?

  B. 0.001
  C. 1
  D. . (missing numeric value)
  D. . (missing numeric value)

• Question 149:

  Given the following raw data records in DATAFILE.TXT:

  

  Which output is correct based on the submitted program?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C

• Question 150:

  The contents of the raw data file EMPLOYEE are listed below:

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

  Ruth 39 11

  Jose 32 22

  Sue 30 33

  John 40 44

  The following SAS program is submitted:

  data test;

  infile 'employee';

  input employee_name $ 1-4;

  if employee_name = 'Sue' then input age 7-8;

  else input idnum 10-11;

  run;

  Which one of the following values does the variable AGE contain when the name of the employee is "Sue"?

  A. 30
  B. 33
  C. 40
  D. . (missing numeric value)
  C. 40