SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 251:

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

  A. in a SAS catalog
  B. in an external binary file
  C. in a SAS dataset in the WORK library
  D. in a SAS dataset in a permanent SAS data library
  A. in a SAS catalog

• Question 252:

  Population is currently at 34,278,400 for country A and is expected to rise at a rate of 2%.

  Which DO LOOP will correctly calculate growth rate over the next 10 years beginning in 2012 as shown in the graphic below?

  

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

• Question 253:

  The following SAS program is submitted:

  

  Which statement is true about the output data set?

  A. The label of the variable Jobcode is Job (only the first word).
  B. The label of the variable Jobcode is Job Desc (only the first 8 characters).
  C. The label of the variable Jobcode is Job Description.
  D. Labels can only be defined in PROC steps. The program fails to execute due to errors and the data set is not created.
  C. The label of the variable Jobcode is Job Description.

• Question 254:

  The following SAS program is submitted:

  proc means data = sasuser.houses std mean max;

  var sqfeet;

  run;

  Which one of the following is needed to display the standard deviation with only two decimal places?

  A. Add the option MAXDEC = 2 to the MEANS procedure statement.
  B. Add the statement MAXDEC = 7.2; in the MEANS procedure step.
  C. Add the statement FORMAT STD 7.2; in the MEANS procedure step.
  D. Add the option FORMAT = 7.2 option to the MEANS procedure statement.
  A. Add the option MAXDEC = 2 to the MEANS procedure statement.

• Question 255:

  The following SAS program is submitted:

  data work.retail; cost = `20000'; total= .10* cost run;

  What is the result?

  A. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.
  B. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
  C. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.
  D. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.
  B. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.

• Question 256:

  This question will ask you to provide a missing format: Given the contents of the raw data file 'EMPLOYEE.TXT'

  

  Which SAS information correctly completes the program?

  A. date10
  B. mmddyy10
  C. ddmmyy10
  D. date9
  B. mmddyy10

• Question 257:

  Given the SAS data set WORK.ORDERS:

  

  The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value.

  A programmer would like to create a new variable called Note, that shows a character value with the Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the following: "Order 9341 shipped on

  02FEB2009".

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

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

• Question 258:

  Given the raw data file EMPLOYEE:

  ----I----1 0---I----20---I----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 = `Ruth' then input idnum 10-11;

  else input age 7-8;

  run;

  What value does the variable IDNUM contain when the name of the employee is "Ruth"?

  A. 11
  B. 22
  C. 33
  D. (missing numeric value)
  B. 22

• Question 259:

  The following code was modified to generate the results further below:

  proc format;

  value agegrp

  low-12 ='Pre-Teen'

  13-high = 'Teen';

  run;

  proc means data=SASHELP.CLASS;

  var Height;

  class Sex Age;

  format Age agegrp.;

  run;

  The following results were generated to display only specific statistics and limit the decimals with the modification: Which statement below was modified or added to generate the results above:

  

  A. var Height / nobs min max mean maxdec=1;
  B. proc means data=SASHELP.CLASS maxdec=1 ;
  C. proc means data=SASHELP.CLASS min max mean maxdec=1;
  D. output nobs min max mean maxdec=1;
  C. proc means data=SASHELP.CLASS min max mean maxdec=1;

• Question 260:

  The following SAS program is submitted:

  data work.passengers;

  if OrigPassengers = . then'

  OrigPassengers = 100;

  TransPassengers = 100;

  OrigPassengers = .;

  TotalPassengers = sum (OrigPassengers, TransPassengers) +0;

  run;

  What is the value of the TOTALPASSENGERS variable in the output data set?

  B. 100
  C. 200
  D. (missing numeric value)
  B. 100