Free SASInstitute A00-211 Exam Dumps Questions & Answers

The following SAS program is submitted:
<_insert_ods_code_>
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
run;
<_insert_ods_code_>
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?

• A.ods file html='sales.html';ods file close;
• B.ods html file='sales.html';ods html close;
• C.ods file='sales.html' / html;ods file close;
• D.ods html open='sales.html';ods html close;

This question will ask you to provide a line of missing code.
The following SAS program is submitted:
proc freq data = WORK.SALES;
<insert code here>
run;
The following output is created by the FREQUENCY procedure:

Which statement was used to complete the above program that produced the output?

• A.var region product;
• B.tables region*product;
• C.var region * product;
• D.tables region product;

The following SAS program is submitted:
proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;
run;
Click on the Exhibit button to view the report produced.
style bedrooms baths price
CONDO 2 1.5 80050
3 2.5 79350
4 2.5 127150
2 2.0 110700 RANCH 2 1.0 64000
3 3.0 86650
3 1.0 89100
1 1.0 34550 SPLIT 1 1.0 65850
4 3.0 94450
3 1.5 73650 TWOSTORY 4 3.0 107250
2 1.0 55850
2 1.0 69250
4 2.5 102950

• A.id style;
• B.id style;
  by style;
  var bedrooms baths price;
• C.id style;
  var style bedrooms baths price;
• D.id style;
  by style;
  var style bedrooms baths price;
  Which of the following SAS statement(s) create(s) the report?

After a SAS program is submitted, the following is written to the SAS log:

What changes should be made to the KEEP statement to correct the errors in the LOG?

• A.keep Product Sales;
• B.keep Product, Sales;
• C.keep=Product, Sales;
• D.keep=(Product Sales);

Given the SAS data set WORK.PRODUCTS:

How many variables does the WORK.REVENUE data set contain?

• A.6
• B.2
• C.3
• D.4