Free A00-211 SAS Institute Updates

Given the raw data file ‘DEPENDENTS.TXT’:

The following SAS program is submitted:

What will be the value of _ERROR_ in the Program Data Vector for each iteration of the DATA step?

The following SAS program is submitted:

The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender within Department?

Given the following raw data records:

The following output is desired:

Which SAS program correctly reads in the raw data?

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?