Free SASInstitute A00-231 Practice Test & Real Exam Questions
The following SAS program is submitted:
How many observations are written to the WORK.SALES data set?
How many observations are written to the WORK.SALES data set?
Correct Answer: B
Vote an answer
The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?
Correct Answer: A
Vote an answer
The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price".
Which SAS program temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?
Which SAS program temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?
Correct Answer: B
Vote an answer
Given the following raw data records:
The following output is desired:
Which SAS program correctly reads in the raw data?
The following output is desired:
Which SAS program correctly reads in the raw data?
Correct Answer: C
Vote an answer
The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
run;
Which one of the following IF statements writes the last observation to the output data set?
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
run;
Which one of the following IF statements writes the last observation to the output data set?
Correct Answer: D
Vote an answer
Given the following data set:
Which type of statement was included as a component of a transpose procedure step to produce the following data set?
Select one:
Which type of statement was included as a component of a transpose procedure step to produce the following data set?
Select one:
Correct Answer: D
Vote an answer
Scenario:
Open the existing program, program48.sasfrom folder cert\errors. At any time, you may save your corrected program asprogram48incert\programs. This program is intended to:
* Create 3 groups for C var: A-G is Group=1; H-N is Group=2; O-Z is Group=3.
* All variations of the variable should be in the same group, i.e. "A" and "a" should be in Group=1.
* Calculate the average of X and Y by Group. There are multiple errors in the program. These may be syntax errors, logic errors, or problems with the program structure. Logic errors might not produce messages in the log, but will cause the program to produce results different than intended. Correct the errors, run the program, and then use the results to answer the next 2 questions. What is the average (mean) of X for Group=2? Enter your answer to the nearest whole number. Enter your numeric answer in the space below:
Open the existing program, program48.sasfrom folder cert\errors. At any time, you may save your corrected program asprogram48incert\programs. This program is intended to:
* Create 3 groups for C var: A-G is Group=1; H-N is Group=2; O-Z is Group=3.
* All variations of the variable should be in the same group, i.e. "A" and "a" should be in Group=1.
* Calculate the average of X and Y by Group. There are multiple errors in the program. These may be syntax errors, logic errors, or problems with the program structure. Logic errors might not produce messages in the log, but will cause the program to produce results different than intended. Correct the errors, run the program, and then use the results to answer the next 2 questions. What is the average (mean) of X for Group=2? Enter your answer to the nearest whole number. Enter your numeric answer in the space below:
Correct Answer:
47
The following SAS program is submitted:
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
Which one of the following OPTIONS statements resets the page number to 1 for the second report?
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
Which one of the following OPTIONS statements resets the page number to 1 for the second report?
Correct Answer: C
Vote an answer
Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
data bonus;
infile 'dept';
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
data bonus;
infile 'dept';
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
Which statement is true about the output data set?
Which statement is true about the output data set?
Correct Answer: C
Vote an answer
