SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 171:

  The following SAS program is submitted:

  data allobs;

  set sasdata.origin (firstobs = 75 obs = 499);

  run;

  The SAS data set SASDATA.ORIGIN contains 1000 observations.

  How many observations does the ALLOBS data set contain?

  A. 424
  B. 425
  C. 499
  D. 1000
  B. 425

• Question 172:

  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
  B. 1 observations and 4 variables

• Question 173:

  Given the raw data record DEPT:

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

  Printing 750

  The following SAS program is submitted:

  data bonus;

  infile `dept';

  inputdept$ 1-11 number 13- 15;

  run;

  Which SAS statement completes the program and results in a value of `Printing750' for the DEPARTMENT variable?

  A. department = dept II number;
  B. department = left(dept) II number;
  C. department = trim(dept) number;
  D. department=trim(dept)||put(number,3.);
  D. department=trim(dept)||put(number,3.);

• Question 174:

  The following program is submitted:

  

  Why does the program fail?

  A. The PAGENO option is invalid in the OPTIONS statement.
  B. The RUN statement is missing after the FORMAT procedure.
  C. The format name contains a period in the VALUE statement.
  D. The LABEL option is missing from the PROC PRINT statement.
  C. The format name contains a period in the VALUE statement.

• Question 175:

  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
  B. The program fails execution due to syntax errors.

• Question 176:

  Which one of the following is true when SAS encounters a data error in a DATA step?

  A. The DATA step stops executing at the point of the error, and no SAS data set is created.
  B. A note is written to the SAS log explaining the error, and the DATA step continues to execute.
  C. A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
  D. The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
  B. A note is written to the SAS log explaining the error, and the DATA step continues to execute.

• Question 177:

  After a SAS program is submitted, the following is written to the SAS log:

  

  What issue generated the error in the log?

  A. There should have been commas between the variable names.
  B. The list of variables should have been enclosed in parentheses.
  C. A drop statement and a keep= data set option cannot both be used at the same time.
  D. The syntax of the drop statement does not use an equals sign.
  C. A drop statement and a keep= data set option cannot both be used at the same time.

• Question 178:

  The following SAS program is submitted:

  

  What is produced as output?

  A. A file named test.cvs that can only be opened in Excel.
  B. A text file named test.cvs that can be opened in Excel or in any text editor.
  C. A text file named test.cvs that can only be opened in a text editor.
  D. A file named test.cvs that can only be opened by SAS.
  B. A text file named test.cvs that can be opened in Excel or in any text editor.

• Question 179:

  The following SAS program is submitted:

  proc format

  value score 1 - 50 = `Fail'

  51 - 100 = `Pass';

  run;

  proc report data = work.courses nowd;

  column exam;

  define exam / display format = score.;

  run;

  The variable EXAM has a value of 50.5.

  How will the EXAM variable value be displayed in the REPORT procedure output?

  A. Fail
  B. Pass
  C. 50.5
  D. . (missing numeric value)
  C. 50.5

• Question 180:

  Which one of the following SAS system options prevents the page number from appearing on a report?

  A. NONUM
  B. NOPAGE
  C. NONUMBER
  D. NOPAGENUM
  C. NONUMBER