SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 71:

  Consider the following data step:

  

  In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing value?

  A. X would get a value of 1.
  B. X would get a value of 3.
  C. X would retain its original value of missing.
  D. This step does not run because of syntax errors.
  A. X would get a value of 1.

• Question 72:

  The following SAS program is submitted:

  data one; date = `04juI2005'd; format date weekdate.; run; proc print data = one; run;

  What output is generated?

  A. Obs date 1 Monday, July 4, 2005
  B. Obs date 1 July4, 2005
  C. Obs date 1 04Jul2005
  D. Obs date 1 Monday, 07/04/2005
  A. Obs date 1 Monday, July 4, 2005

• Question 73:

  Given the following raw data record:

  ----I----10---I----20---I----30 son Travis, The following output is desired: Obs relation firstname 1 son Travis

  Which SAS program correctly reads in the raw data?

  A. data family ( dIm = `,'); infile `tile specification'; input relation $ firstname $; run;
  B. options dIm = `,'; data family; infile `file specification'; input relation $ firstname $; run;
  C. data family; infile `file specification' dIm = `,'; input relation $ firstname $; run;
  D. data family; infile `file specification'; input relation $ firstname $ / dim = `,'; run;
  C. data family; infile `file specification' dIm = `,'; input relation $ firstname $; run;

• Question 74:

  The following SAS program is submitted, creating the SAS data set ONE:

  data one;

  infile `file specification';

  input num chars$;

  run;

  ONE

  NUM CHAR

  1 23 3 23 1 77

  The following SAS program is submitted:

  proc print data = one; where char = 23; run;

  What is output?

  A. NUM CHAR 1 77
  B. NUM CHAR 1 23 3 23
  C. NUM CHAR 1 23 3 23 1 77
  D. No output is generated.
  D. No output is generated.

• Question 75:

  Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

  A. infile 'customer.txt' eof=10;
  B. infile 'customer.txt' obs=10;
  C. infile 'customer.txt' obs=10;
  D. infile 'customer.txt' obs=1-10;
  D. infile 'customer.txt' obs=1-10;

• Question 76:

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

  VARIABLE NAME TYPE idnum character variable sales_date numeric date value

  A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. 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' dlm = ','; 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 : mmddyy10. dlm = ','; run;
  D. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dsd = ','; run;
  B. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dlm = ','; put idnum sales_date : mmddyy10.; run;

• Question 77:

  The following SAS program is submitted:

  data work.test; array items{3} _temporary_; run;

  What are the names of the variable(s) in the WORKTEST data set?

  A. ITEMS
  B. ITEMS1, ITEMS2, ITEMS3
  C. No variables are created because it is a temporary array.
  D. The program fails to execute because there are no variables listed on the ARRAY statement.
  C. No variables are created because it is a temporary array.

• Question 78:

  Given the SAS data set EMPLOYEES:

  EMPLOYEES

  NAME SALARY

  Innis 60000

  Jolli 50000

  Ellis 55000

  Liu 45000

  The following SAS program is submitted:

  proc print data = employees; where name like `_i%';

  run;

  What is contained in the output?

  A. Liu only
  B. Innis and Ellis only
  C. Innis, Ellis, and Liu only
  D. Innis, Jolli, Ellis, and Liu
  A. Liu only

• Question 79:

  Given the SAS data set WORK.ONE:

  

  The following SAS program is submitted:

  

  What value will SAS assign to Total?

  A. 4.8
  B. 1.6
  C. (missing value)
  D. 1.2
  B. 1.6

• Question 80:

  The following SAS program is submitted:

  data revenue; set year_1; var1 = mdy(1,15,1960); run;

  Which one of the following values does the variable named VAR1 contain?

  A. 14
  B. 15
  C. 1151960
  D. '1/15/1960'
  A. 14