A00-215 Exam: Absolutely Free Online Practice

Question 1
- Which PROC MEANS program creates the report below?
  
  A : proc means data-sashelp. shoes sum mean;
  var Sales;
  Class Product;
  run;
  
  B : proc means data=sashelp. 'shoes
  var Sale;
  group Product;
  run/
  
  C : Pror moans data-uashelp . shoes sum mean nobe;
  by sales;
  class product
  
  D : proc means data-esea= ashelp. shoes.
  sum Salad;
  mean Sales;
  by product;
  run."
  
  Answer: A
Question 2
- Which statements read the input data set SASHELP. SHOES and create the output data set WORK. TOTAL?
  A : data sashalp.shoes;
  out work.total;
  
  B : data sashelp.shoes;
  output work.total;
  
  C : data work.total;
  set sashelp.shoes;
  
  D : data out=work.total;
  input sasholp.shoes
  
  Answer: C
Question 3
- Which sentence is true regarding the VALUE statement in the FORMAT procedure?
  A : The keyword UNKNOWN can be specified on the VALUE statement.
  
  B : Numeric format names in the VALUE statement must begin with a $ sign.
  
  C : The VALUE statement can create numeric and character formats.
  
  D : The VALUE statement uses the LIB= option to specify the location of the format.
  
  Answer: C
Question 4
- Given the following SAS program:
  What footnotes appear for the second PROC PRINY report?
  A : Created by HR
  
  B : Draft - Do Not Distribute
  Create by HR
  
  C : Draft –Do NOT Distribute
  
  Answer: C
Question 5
- The data set SASHELP. CARS contains information on different vehicles. How do you correctly write the observations with Type of 'SUV' to the suv data set and Type of 'Sedan' to the sedans data set?
  
  A : data=SUV data=Sedans;
  set sashelp.cars;
  if Type = 'SUV' then output SUV;
  else if Type = 'Sedan' then output Sedans;
  run;
  
  B : data SUV Sedans;
  set sashelp.cars;
  if Type = 'SUV' then output SUV;
  else if Type = 'Sedan' then output Sedans;
  run;
  
  C : data SUV;
  data Sedans;
  set sashelp.cars;
  if Type = SUV then output SUV;
  else if Type = Sedan then output Sedans;
  run;
  
  D : data= (SUV Sedans) ;
  set sashelp.cars;
  if Type = 'SUV' then output SUV;
  else if Type = 'Sedan' then output Sedans;
  run;
  
  Answer: B

Free SAS Institute A00-215 Exam Questions

Absolute Free A00-215 Exam Practice for Comprehensive Preparation