SASInstitute SAS 9.4 Base Programming - Performance-based - A00-231 Exam Practice Test
Read the table
The following SAS program is submitted:
proc freq data = sales;
<insert TABLES statement here>
run;
The following output is created by the FREQUENCY procedure:
Which TABLES statement(s) completed the program and produced the output?
The following SAS program is submitted:
proc freq data = sales;
<insert TABLES statement here>
run;
The following output is created by the FREQUENCY procedure:
Which TABLES statement(s) completed the program and produced the output?
Correct Answer: A
Vote an answer
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
proc format
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?
proc format
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?
Correct Answer: B
Vote an answer
The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?
Correct Answer: C
Vote an answer
The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?
Correct Answer: A
Vote an answer
Which step displays a listing of all the data sets in the WORK library?
Correct Answer: A
Vote an answer
The following SAS program is submitted:
What are the values for x and y in the output data set?
Select one:
What are the values for x and y in the output data set?
Select one:
Correct Answer: C
Vote an answer
Given the raw data record in the file phone.txt:
Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?
Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?
Correct Answer: B
Vote an answer