Online Access Free A00-231 Practice Test

The following SAS program is submitted:
data work.accounting;
set work.dept1 work.dept2;
jobcode = 'FA1';
length jobcode $ 8;
run;
A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set.
What is the length of the variable JOBCODE in the output data set?

• A.3
• B.8
• C.5
• D.7

Consider the following data step:

In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing value?

• A.X would retain its original value of missing.
• B.X would get a value of 1.
• C.This step does not run because of syntax errors.
• D.X would get a value of 3.

Given the SAS data set WORKAWARDS:
WORK.AWARDS
FNAMEPOINTSMONTH
----------------------------------
Amy24
Amy17
Gerard33
Wang33
Wang112
Wang18
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?

• A.ENAME POINTS MONTH Amy24 Amy17 Gerard33 Wang33 Wang18 Wang112
• B.ENAME POINTS MONTH Wang33 Wang112 Wang18 Gerard33 Amy24 Amy17
• C.ENAME POINTS MONTH Wang112 Wang18 Wang33 Gerard33 Amy17 Amy24
• D.ENAME POINTS MONTH Wang33 Wang18 Wang112 Gerard33 Amy24 Amy17

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.tables region*product;
• B.tables region product;
• C.var region * product;
• D.var region product;

Which one of the following is true when SAS encounters a data error in a DATA step?

• A.The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
• B.A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
• C.The DATA step stops executing at the point of the error, and no SAS data set is created.
• D.A note is written to the SAS log explaining the error, and the DATA step continues to execute.