SASInstitute A00-231 Actual Free Exam Questions & Community Discussion
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :
Which expression successfully completed the program and creates the variable DAY?
The following SAS program is submitted:
The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :
Which expression successfully completed the program and creates the variable DAY?
Correct Answer: C
Vote an answer
After a SAS program is submitted, the following is written to the SAS log:
105 data january;
106 set allmonths(keep = product month num_sold cost);
107 if month = 'Jan' then output january;
108 sales = cost * num_sold;
109 keep = product sales;
------
22
ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, <,< =, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,
110 run;
What changes should be made to the KEEP statement to correct the errors in the LOG?
105 data january;
106 set allmonths(keep = product month num_sold cost);
107 if month = 'Jan' then output january;
108 sales = cost * num_sold;
109 keep = product sales;
------
22
ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, <,< =, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,
110 run;
What changes should be made to the KEEP statement to correct the errors in the LOG?
Correct Answer: D
Vote an answer
Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?
Correct Answer: B
Vote an answer
Given the SAS data set WORK. PRODUCTS:
The following SAS program is submitted:
data WORK. REVENUE (drop=Sales Returns);
set WORK. PRODUCTS (keep=ProdId Price Sales Returns); Revenue-Price* (Sales-Returns); run; How many variables does the WORK.REVENUE data set contain?
The following SAS program is submitted:
data WORK. REVENUE (drop=Sales Returns);
set WORK. PRODUCTS (keep=ProdId Price Sales Returns); Revenue-Price* (Sales-Returns); run; How many variables does the WORK.REVENUE data set contain?
Correct Answer: B
Vote an answer
Which statement correctly computes the average of four numerical values?
Correct Answer: D
Vote an answer
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
What is the result?
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
What is the result?
Correct Answer: C
Vote an answer
The following SAS program is submitted:
data work.one;
x = 3;
y = 2;
z = x ** y;
run;
Which one of the following is the value of the variable Z in the output data set?
data work.one;
x = 3;
y = 2;
z = x ** y;
run;
Which one of the following is the value of the variable Z in the output data set?
Correct Answer: D
Vote an answer
Given the SAS data set WORK.THREE:
The following SAS program is submitted:
What is the result?
The following SAS program is submitted:
What is the result?
Correct Answer: D
Vote an answer
You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:
What does it mean?
What does it mean?
Correct Answer: A
Vote an answer
Given the contents of the raw data file TYPECOLOR.DAT:
The following SAS program is submitted:
What are the values of the variables Type and Color?
The following SAS program is submitted:
What are the values of the variables Type and Color?
Correct Answer: B
Vote an answer
Scenario:
This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs. Write a SAS program that will clean the data incert.input36as follows:
Step 1:
create a temporary data set, cleandata36.
In this data set, convert all case.
Then keep only observations with group equal to 'A' or 'B'.
Step 2:
Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.
Step 3:
* Create results.output36 from cleandata36
* Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.
* If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respectivegroup(A,B) calculated in step 2 What is the MEAN Kilograms value for group='A' in the results.output36 data set?
This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs. Write a SAS program that will clean the data incert.input36as follows:
Step 1:
create a temporary data set, cleandata36.
In this data set, convert all case.
Then keep only observations with group equal to 'A' or 'B'.
Step 2:
Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.
Step 3:
* Create results.output36 from cleandata36
* Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.
* If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respectivegroup(A,B) calculated in step 2 What is the MEAN Kilograms value for group='A' in the results.output36 data set?
Correct Answer:
76.3
0
0
0
10