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 program fails to execute due to errors.
• B.The length of the variable JOBCODE is 5.
• C.The length of the variable JOBCODE is 3.
• D.The length of the variable JOSBODE is 12.

Comment: *

Name: *

Email: *

Verification: *

Which one of the following is true of the RETAIN statement in a SAS DATA step program?

• A.It has no effect on variables read with the SET, MERGE and UPDATE statements.
• B.It adds the value of an expression to an accumulator variable and ignores missing values.
• C.It is only valid in conjunction with a SUM function.
• D.It can be used to assign an initial value to _N_ .

Comment: *

Name: *

Email: *

Verification: *

A user-defined format has been created using the FORMAT procedure. Where is it stored?

• A.in a SAS catalog
• B.in an external binary file
• C.in a SAS dataset in the WORK library
• D.in a SAS dataset in a permanent SAS data library

Comment: *

Name: *

Email: *

Verification: *

You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:

What does it mean?

• A.An error on the INPUT statement specification for reading the variable Salary.
• B.A compiler error, triggered by an invalid character for the variable Salary.
• C.An execution error, triggered by an invalid character for the variable Salary.
• D.The 1st of potentially many errors, this one occurring on the 4th observation.

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
data work.totalsales (keep = monthsales{12} );
set work.monthlysales (keep = year product sales);
array monthsales {12} ;
do i=1 to 12;
monthsales{i} = sales;
end;
run;
The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?

• A.The program fails execution due to data errors.
• B.The program executes with warnings and creates the WORK.TOTALSALES data set.
• C.The program fails execution due to syntax errors.
• D.The program executes without errors or warnings and creates the WORK.TOTALSALES data set

Comment: *

Name: *

Email: *

Verification: *