The following SAS program is submitted:
data work.totalsales;
set work.monthlysales(keep = year product sales);
retain monthsales {12} ;
array monthsales {12} ;
do i = 1 to 12;
monthsales{i} = sales;
end;
cnt + 1;
monthsales{cnt} = sales;
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 fails execution due to syntax errors.
• C.The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.
• D.The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable PROD in the output data set?

• A.8
• B.6
• C.7
• D.(missing numeric)

Comment: *

Name: *

Email: *

Verification: *

Given the raw data file AMOUNT:
----I---- 10---I----20---I----30
$1,234
The following SAS program is submitted:
data test;
infile 'amount';
input@1 salary 6.;
if_error_then description = 'Problems';
else description = 'No Problems';
run;
What is the result?

• A.The value of the DESCRIPTION variable is No Probl.
• B.The value of the DESCRIPTION variable is Problems.
• C.The value of the DESCRIPTION variable is No Problems.
• D.The value of the DESCRIPTION variable can not be determined.

Comment: *

Name: *

Email: *

Verification: *

Given the following SAS data set WORK.SALES:

The following SAS program is submitted:

Which output is produced?

Comment: *

Name: *

Email: *

Verification: *

The following SAS program is submitted:

What is the value of the variable Prod in the output data set?

• A.. (missing numeric)
• B.7
• C.6
• D.8

Comment: *

Name: *

Email: *

Verification: *