SAS Institute A00-215 Online Practice Questions and Exam Preparation

SAS Institute A00-215 Online Questions & Answers

• Question 21:

  Given the following code:

  

  Which variables are created with the BY statement?

  A. State. First and State. Last
  B. First. State and Last. State
  C. First_State and Last_State
  D. First. and Last.
  C. First_State and Last_State

• Question 22:

  Which program generates the PROC MEANS report below?

  

  A. proc means data=sashelp.class nodec; class Age; run;
  B. proc means data=sashelp. class; group Age; run;
  C. proc means data=sashelp. class; by Age; run;
  D. proc means data=sashelp. class maxdec=0; var Age; run;
  B. proc means data=sashelp. class; group Age; run;

• Question 23:

  Given the program shown below:

  

  Given the partial PROC PRINT report below:

  

  Why are the labels for msbp, MPG_city, and MPG_Highway NOT displaying in the PROC PRINT report^

  A. You must use the LABEL option on the PROC PRINT statement
  B. You must put the LABEL statement in the PROC PRINT step
  C. You must put the LABEL statement after the KEEP statement In the DATA stop
  D. You must use a single LABEL statement for each variable.
  A. You must use the LABEL option on the PROC PRINT statement

• Question 24:

  Which statement is true regarding variable names?

  A. Variable names are case sensitive.
  B. Variable names are from 1 to 32 characters in length.
  C. Variable names are optional when you create a data set
  D. Variable names can start with a number or an underscore
  B. Variable names are from 1 to 32 characters in length.

• Question 25:

  When the following code is submitted, execution fails.

  

  Why does the execution fail?

  A. Multiple executable statements are not allowed in the DO block.
  B. The OUTPUT statement is not allowed in the DO block.
  C. There are two unclosed DO block.
  D. The conditional logic expressions fail for the DO block
  A. Multiple executable statements are not allowed in the DO block.

• Question 26:

  Which PROC IMPORT step correctly creates the MYDATA,SALES data set from the SALES.SCV file?

  A. proc import data="mydata. sales" dbms=csv out="mydata.sales; nun
  B. proc import datafile="sales.csv" dbms=csv out-mydata. sales;
  C. proc import data=mydata.sales dbms=csv out=mydata.gales; run,
  D. proc import datafile=sales.csv dbms=csv out--"mydata,sales"; run;
  D. proc import datafile=sales.csv dbms=csv out--"mydata,sales"; run;

• Question 27:

  Which LABEL statement has correct syncytax?

  A. Label1 FName=' First Name' ; LName =; Last Name` ;
  B. Label1 FName=' First Name' LName =' Last Name` ;
  C. Label1 FName=' First Name' and LName =' Last Name` ;
  D. Label1 FName=' First Name' , LName =; Last Name` ;
  D. Label1 FName=' First Name' , LName =; Last Name` ;

• Question 28:

  Which LIBNAME statement has the correct syntax for accessing SAS data sets?

  A. libname 'c:\sas\data' mydata;
  B. libname mydata 'c:\sas\data';
  C. libname mydata='c:\sas\data';
  D. libname 'c:\sas\data'=mydata;
  D. libname 'c:\sas\data'=mydata;

• Question 29:

  How many statements are In the program shown below?

  

  A. 9
  B. 6
  C. 10
  D. 2
  D. 2

• Question 30:

  Which statement is true about the SUM statement?

  A. The SUM statement includes an equal sign.
  B. Multiple accumulating variables can be created with one SUM statement.
  C. The SUM statement ignores missing values.
  D. By default, the accumulating variable is initialized to 1.
  B. Multiple accumulating variables can be created with one SUM statement.