SAS Institute A00-215 Online Practice Questions and Exam Preparation

SAS Institute A00-215 Online Questions & Answers

• Question 51:

  Which two data sets are permanent?

  A. New
  B. Mylib.new
  C. Work.new
  D. Temp.new
  C. Work.new

• Question 52:

  Which program correctly subnets the SASHELP. BASEBALL data set to include only the players in the East Division with 75 or more hits?

  A. data bball; set sashelp.baseball; whete Division and nHits run;
  B. data bball; sot sashelp.baseball; where Division -- 'East; where nHits >= 75; run;
  C. data bball; set sashelp.baseball; where Division = * East; or nHits .= 75;
  D. data bball; set sashelp.basaball; whero Division -- 'Eas run,
  A. data bball; set sashelp.baseball; whete Division and nHits run;

• Question 53:

  What type of error does NOT produce the expected results and does NOT generate errors or warnings in the log?

  A. Syntax error
  B. Logic error
  C. Special error
  D. Data error
  B. Logic error

• Question 54:

  Given the display of the CITIES data set:

  

  Which program creates the PROC PRINT report below?

  

  A. proc print data=cities showlabelse; label Name= ' Employee Name City =Birth City
  B. proc print data-cities label noobs; label Name='Employee Name' City=' Birth City' ; run;
  C. proc print data=cities ; Name=' Employee Name' ; City='Birth City'; run;
  D. options noobs labels; proc print data=cities; display Name=' Employee Name* city='Birth City', run;
  C. proc print data=cities ; Name=' Employee Name' ; City='Birth City'; run;

• Question 55:

  Given the report shown below:

  

  Which PROC PREQ step creates the frequency report?

  A. proc freq data= cars; tables make drivetrain; run;
  B. proc freq data= cars; tables make *drivetrain; run;
  C. proc freq data- cars; tables drivetrain make; run;
  D. proc freq data- cars; tables drivetrain* make; run;
  D. proc freq data- cars; tables drivetrain* make; run;

• Question 56:

  Given the input data set INVENTORY as shown below:

  

  Two output data sets are desired, CHIPS and OTHERSNACKS.

  *

  The CHIPS data set should only include QtySold, Price, and Product.

  *

  The OTHERSNACKS data set should include QtySold, Price, product, and Type. Which Data step creates the two desired output data sets

  A. data chips othersnacks; set: inventory; if Type="chips" then do; keep QtySold Price Product; output chips; end; else output othersnacks; run;
  B. data chips ( keep=QtySold Price Product) othersnacks; set inventory; if Type="chipa" then output chips; else output otharsnacks; run;
  C. data chips otharsnacks; set inventory; if Type="chips" then output chips else output otharsnacks; keep QtySold Price Product; run;
  D. data chips othersnack" set inventory (keep=QtySold Price Product); if Typo~"chips" then output chips; else output othersnacks; run;
  D. data chips othersnack" set inventory (keep=QtySold Price Product); if Typo~"chips" then output chips; else output othersnacks; run;

• Question 57:

  The sashelp. class data set has 19 observations. Given the frequency information about the Age, shown below:

  

  How many observations are written to output data set when the following code is submitted?

  A. preteen will have 7 observations and teen will have 19 observations
  B. preteen will have 7 observations and teen will have 12 observations
  C. preteen will have 26 observations and teen will have 31 observations
  D. preteen will have 10 observations and teen will have 9 observations
  C. preteen will have 26 observations and teen will have 31 observations

• Question 58:

  Which statement is true regarding the SET statement?

  A. The SET statement specifies an input data set in the DATA step.
  B. The SET statement specifies an output data set in the PROC SORT step.
  C. The SET statement specifies an input data sot in the PROC SORT step
  D. The SET statement specifies an output data 5et in the DAI A step.
  C. The SET statement specifies an input data sot in the PROC SORT step

• Question 59:

  Given the data set NAMES:

  

  Which PROC SORT program creates the NAMES data set shown below?

  

  A. proc sort data=Names; orderby Age
  B. proc sort data=Names; by Age
  C. proc sort data=Names; by Age Name
  D. proc sort data=Names; orderby Name; run;
  A. proc sort data=Names; orderby Age

• Question 60:

  What step has correct syntax for the CONTENTS procedure?

  A. Proc contents file=sashelp .shoes; Run;
  B. Proc contents lib=sashelp data=shoes; Run;
  C. Proc contents data=sashelp.shoes; Run;
  D. Proc contents sashelp. Shoes; run;
  D. Proc contents sashelp. Shoes; run;