Online Access Free A00-231 Practice Test

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?

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

The following SAS program is submitted:
data work.accounting;
set work.department;
length jobcode $ 12;
jobcode='FAl';
run;
The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5.
What is the result?

• A.The length of the variable JOSBODE is 12.
• B.The program fails to execute due to errors.
• C.The length of the variable JOBCODE is 3.
• D.The length of the variable JOBCODE is 5.

The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY. The following SAS program is submitted:
proc sort data = work.test out = work.testsorted;
by name;
run;
Which one of the following is the result of the SAS program?

• A.The data set WORK.TEST is stored in ascending order by values of the NAME variable.
• B.The data set WORK.TEST is stored in descending order by values of the NAME variable.
• C.The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable.
• D.The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.

The following SAS program is submitted:
data work.company;
set work.dept1(keep = jobcode)
work.dept2(rename = (jcode = jobcode));
run;
Which one of the following is the result?

• A.The variable JOBCODE is written to the output data set.
• B.The variable JCODE is written to the output data set.
• C.The program fails to execute due to errors.
• D.Neither variable JCODE nor JOBCODE is written to the output data set.

Scenario:
Open the existing program, program44.sasfrom folder cert\errors. At any time, you may save your corrected program asprogram44incert\programs. This program is intended to:
O Create a new data set using thecert.input44set as input
O Drop variables:bp_status, weight_status, andsmoking _status.
* Create a new column,chol_status, based on the following values of cholesterol:
less than 200: "Safe"
200-239: "High - Borderline"
240 and higher: "High" oShould not calculatechol_statusfor missing cholesterol values 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 3 questions.
How many variables are in thework. outdata set? Enter your numeric answer in the space below:

Correct Answer:

5