SAS Base Programming for SAS 9

The following SAS program is submitted:

data stats;
set revenue;
array weekly{5} mon tue wed thu fri;

total = weekly{i} * .25;
output;
end;
run;

Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?

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:

data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;

Which variables does the WORK.JANUARY data set contain?

Given the following raw data record:

07Jan2005

Which INFORMAT reads this raw data and stores it as a SAS date value?

Which step displays a listing of all the data sets in the WORK library?

The following SAS program is submitted:

data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;

If data set WORK.DEPARTMENT has a numeric variable EmpId.

Which statement is true about the output dataset?

The following SAS program is submitted:

data combine;
prefix='505';
middle='6465 `;
end='09090';
<insert statement here>;
run;

Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?

The following SAS program is submitted:

data one;
date = `04juI2005'd;
format date weekdate.; run;
proc print data = one; run;

What output is generated?

Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

The SAS data set WORK.AWARDS is listed below: fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2

The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;

Which one of the following represents how the observations are sorted?