SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 121:

  The following SAS SORT procedure step generates an output data set

  proc sort data = sasuser.houses out = report;

  by style;

  run;

  In which library is the output data set stored?

  A. WORK
  B. REPORT
  C. HOUSES
  D. SASUSER
  A. WORK

• Question 122:

  The following SAS program is submitted:

  data work.one;

  x = 3;

  y = 2;

  z = x **y;

  run;

  Which one of the following is the value of the variable Z in the output data set?

  A. 6
  B. 9
  C. .(missing numeric value)
  D. The program fails to execute due to errors.
  B. 9

• Question 123:

  The following SAS program is submitted:

  Data_null;

  set old (keep = prod sales 1 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 124:

  Click the Exhibit button to view the output of a FREQ procedure.

  

  The variable STYLE has a permanent label of `Style of homes" and the variable BEDROOMS has a permanent label of "Number of bedrooms".

  Which one of the following SAS programs produced the output shown in the exhibit?

  A. proc freq data = sasuser.houses; tables style and bedrooms; run;
  B. proc freq data = sasuser.houses; tables style * bedrooms; run;
  C. proc freq data = sasuser.houses; tables style bedrooms; run;
  D. proc freq data = sasuser.houses; tables style; tables bedrooms; run;
  B. proc freq data = sasuser.houses; tables style * bedrooms; run;

• Question 125:

  The following SAS program is submitted:

  data allobs;

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

  run;

  The SAS data set SASDATADRIGIN contains 1000 observations.

  How many observations does the ALLOBS data set contain?

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

• Question 126:

  The following SAS program is submitted:

  data work.flights;

  destination = `cph';

  select(destination); when('LHR') city = `London';

  when('CPH') city = `Copenhagen';

  otherwise city = `Other';

  end;

  run;

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

  A. Other
  B. Copenh
  C. Copenhagen
  D. ``(missing character value)
  A. Other

• Question 127:

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

  A. It can be used to assign an initial value to _N_.
  B. It is only valid in conjunction with a SUM function.
  C. It has no effect on variables read with the SET, MERGE and UPDATE statements.
  D. It adds the value of an expression to an accumulator variable and ignores missing values.
  B. It is only valid in conjunction with a SUM function.

• Question 128:

  The following SAS program is submitted:

  proc print data = sasuser.houses;

  run;

  proc means data = sasuser.shoes;

  run;

  Which one of the following OPTIONS statements resets the page number to 1 for the second report?

  A. options pageno = 1;
  B. options pagenum = 1;
  C. options reset pageno = 1;
  D. options reset pagenum = 1;
  C. options reset pageno = 1;

• Question 129:

  The SAS data set EMPLOYEE_INFO is listed below:

  IDNUMBER Expenses 2542 100.00 3612 133.15 2198 234.34 2198 111.12

  The following SAS program is submitted:

  proc sort data = employee_info; run;

  Which one of the following BY statements completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

  A. by Expenses IDNumber;
  B. by IDNumber Expenses;
  C. by ascending (IDNumber Expenses);
  D. by ascending IDNumber ascending Expenses;
  B. by IDNumber Expenses;

• Question 130:

  The following SAS program is submitted:

  proc report data = work.houses nowd;

  column style price;

  where price < 100000;

  title;

  run;

  Click the Exhibit button to view the output from the REPORT procedure.

  

  Assume permanent variable labels have been assigned.

  Which one of the following completes the program and produces the output displayed in the exhibit?

  A. define style / display width = 9; define price / sum format = comma9. width = 10;
  B. define style / width = 9; define price / sum format = comma9. width = 10;
  C. define style / group width = 9; define price / sum format = comma9. width = 10;
  D. define style / order width = 9; define price / sum format = comma9. width = 10;
  D. define style / order width = 9; define price / sum format = comma9. width = 10;