SAS Institute A00-215 Online Practice Questions and Exam Preparation

SAS Institute A00-215 Online Questions & Answers

• Question 1:

  Given the SAS data set WORK PRODUCTS:

  

  The following SAS program is submitted:

  

  How many variables does the WORK REVENUE data set contains?

  A. 4
  B. 5
  C. 2
  D. 3
  D. 3

• Question 2:

  Which PROC PRINT option displays variable labels in the report?

  A. SHOWLABELS
  B. COLS
  C. LABELS=
  D. LABEL
  C. LABELS=

• Question 3:

  The SAS log of a submitted DATA step is shown below:

  

  Which action resolve the error messages?

  A. Remove the period after the value of Inc.
  B. Enclose the value of ABC Inc . in quotation marks.
  C. Add a LENGTH statement to declare the company variable as character
  D. Enclose the value of ABC Inc. in parentheses.
  A. Remove the period after the value of Inc.

• Question 4:

  Which PROC PRINT step correctly displays only the first 10 observations in the data set?

  A. proc print data=sashelp.class(obs=l10); run;
  B. proc print data=sashelp.class; obs=10; run;
  C. proc print data=sashelp.class obs=10; run;
  D. proc print data=sashelp.class (oba?10' ) ; run;
  B. proc print data=sashelp.class; obs=10; run;

• Question 5:

  Given the following DATA step:

  

  What is the value of average?

  A. 3
  A. 3

• Question 6:

  Given the input data sets EMPLOYEES and DONATIONS, and the output data set NODONATIONS below: EMPLOYERS

  

  DONATIONS

  

  NODONATIONS

  

  A. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=0 and inD-0; run;
  B. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; run;
  C. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=1 and inD-0; run;
  D. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=1 and inD-1; run;
  D. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=1 and inD-1; run;

• Question 7:

  Given the PATIENT and VISIT data sets and the DATA step shown below: PATIENT

  

  VISIT

  

  How many observations are created in the ALLVISITS data set?

  A. 5
  B. 12
  C. 7
  C. 7

• Question 8:

  Which statement is true about the DROP statement during the compilation phase of the DATA step?

  A. The DROP statement flags the variables in the Program Data Vector to be dropped at output.
  B. The DROP statement determines the order of the variables in the Program Data Vector
  C. Variables on the DROP statement are removed from the input data set.
  D. Variables on the DROP statement are not created in the Program Data Vector
  C. Variables on the DROP statement are removed from the input data set.

• Question 9:

  Which statement is true when creating two SAS data sets with a DATA step?

  A. Name both data sets in the DATA statement
  B. Use an OUT= option in the WHERE statement to output the observations to the appropriate data sets.
  C. Use a PUT statement to output the observations to the appropriate data sets.
  D. Use a separate SET statement for each data set.
  D. Use a separate SET statement for each data set.

• Question 10:

  Which iterative DO statement is invalid?

  A. Do 100 to 1200 by 100;
  B. Do num = 1.1 to 1.9 by 0.1;
  C. Do year = 2000 to 2016 by 2;
  D. Do reverse = 10 to 1 by -1;
  A. Do 100 to 1200 by 100;